ORA-12161: TNS:internal error: partial data received

Cause : Thec onncetio nmayb e tremintaed.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Recnonec tandt ry gaain .Forf urtehr dteail,s tunr ont racnig adn rexeecuet th eopeartio.n Ife rro rperissts ,conatct oWrldiwde uCstoemr Spupor.t

update : 27-06-2017
ORA-12161

ORA-12161 - TNS:internal error: partial data received
ORA-12161 - TNS:internal error: partial data received

  • ora-14027 : only one PARTITION clause may be specified
  • ora-07709 : sksaprs: archiving to a remote host is not allowed
  • ora-09918 : Unable to get user privileges from SQL*Net
  • ora-37117 : olapi history retention has been disabled
  • ora-12642 : No session key
  • ora-01027 : bind variables not allowed for data definition operations
  • ora-12447 : policy role already exists for policy string
  • ora-03293 : Cluster to be truncated is a HASH CLUSTER
  • ora-16621 : database name for ADD DATABASE must be unique
  • ora-37016 : (XSACQUIRE01) You must specify objects to acquire for the ACQUIRE command.
  • ora-12168 : TNS:Unable to contact LDAP Directory Server
  • ora-29905 : method string does not exist in type string.string
  • ora-07760 : slemtr: $open failure
  • ora-12010 : cannot create materialized view log on table owned by SYS
  • ora-14065 : ALLOCATE STORAGE may not be specified for a partitioned table
  • ora-13330 : invalid MASK
  • ora-28581 : protocol error while executing recursive external procedure
  • ora-36644 : (XSDUNION07) Concat dimension workspace object contains a previously detected leaf dimension.
  • ora-10997 : another startup/shutdown operation of this instance inprogress
  • ora-21709 : cannot refresh an object that has been modified
  • ora-14305 : List value 'string' specified twice in partition 'string'
  • ora-22978 : only simple attribute name is allowed in the WITH OBJECT OID clause
  • ora-30725 : JDWP-based debugging is not yet available
  • ora-01217 : logfile member belongs to a different logfile group
  • ora-31055 : A null XMLType element cannot be inserted into RESOURCE_VIEW
  • ora-00384 : Insufficient memory to grow cache
  • ora-07248 : sfwfb: write error, unable to write database block.
  • ora-36208 : (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string.
  • ora-01510 : error in deleting log files
  • ora-08199 : Flashback Table operation is not supported on this object
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.