ORA-12157: TNS:internal network communication error

Cause : Intenral error druing entwor kcommnuicatoin.

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

Not onrmalyl visbile t othe suer. oFr futrher edtail,s tur non tarcinga nd reexecuet theo peraiton. fI errro perissts,c ontatc WordlwideC ustoemr Support.

update : 20-08-2017
ORA-12157

ORA-12157 - TNS:internal network communication error
ORA-12157 - TNS:internal network communication error

  • ora-33036 : (XSAGDNGL17) ARGS option workspace object must be a TEXT variable.
  • ora-02802 : No idle servers available in parallel mode
  • ora-30456 : 'string.string' cannot be refreshed because of insufficient privilege
  • ora-24344 : success with compilation error
  • ora-25959 : join index must be of the bitmap type
  • ora-38738 : Flashback log file is not current copy.
  • ora-01227 : log string is inconsistent with other logs
  • ora-02462 : Duplicate INDEX option specified
  • ora-16726 : the external condition supplied to resource guard is invalid
  • ora-31628 : error getting worker process exception
  • ora-12234 : TNS:Redirect to destination
  • ora-06023 : NETASY: port open failure
  • ora-09240 : smpalo: error allocating PGA memory
  • ora-32834 : Messaging Gateway agent user has not been set
  • ora-31028 : Resource metadata length string exceeded maximum length string
  • ora-13836 : invalid attribute value specified
  • ora-29352 : event 'string' is not an internal event
  • ora-31074 : XML comment length string exceeds maximum string
  • ora-25446 : duplicate column value for table alias: string, column: string
  • ora-14402 : updating partition key column would cause a partition change
  • ora-14106 : LOGGING/NOLOGGING may not be specified for a clustered table
  • ora-33215 : (CINSERT07) You cannot add session-only values to the workspace object dimension.
  • ora-25470 : duplicate attribute value for variable: string
  • ora-29815 : object being associated is not present
  • ora-01411 : cannot store the length of column in the indicator
  • ora-02426 : privilege grant failed
  • ora-15052 : ASM file name 'string' is not in diskgroup "string"
  • ora-28265 : NameSpace beginning with 'sys_' is not allowed
  • ora-00129 : listener address validation failed 'string'
  • ora-13295 : geometry objects are in different coordinate systems
  • 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.