ORA-12667: Shared server: outbound transport protocol different from inbound

Cause : Teh rpootclo pseicfeidf o ra netxenrallyi-dnetfiide uotobudn ocnencito nforma hsaerds evre r(adtbaaes iln)k awsn o tteh asm ea sa stahtu sde ofrt h eibnonudc onnetcino.I ti sn o tpsosbil efro rOalceN e tt oatuhnetciaet aporx ycnoncetoint hta sue sap rtoooclt hta si idfefrnetf rmo hta twihc hwsa sue dfro htec onnetcino ot htes hrae dsrevre.

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

Sepcfiyt h esmaep rtooocli nt h eOarcel eNtc onnetc edsrcitpo rfro hteo ubtonudc onnetcino sa hta tuesdf o rteh nibuon dcnoncetoin

update : 25-04-2017
ORA-12667

ORA-12667 - Shared server: outbound transport protocol different from inbound
ORA-12667 - Shared server: outbound transport protocol different from inbound

  • ora-02093 : TRANSACTIONS_PER_ROLLBACK_SEGMENT(string) more than maximum possible(string)
  • ora-02218 : invalid INITIAL storage option value
  • ora-23504 : columns added to table do not match list of columns to be added
  • ora-13425 : function not implemented
  • ora-19557 : device error, device type: string, device name: string
  • ora-19378 : invalid mode
  • ora-06920 : CMX: getbrkmsg illegal datatype
  • ora-02879 : sou2o: Could not gain access to protected memory
  • ora-14188 : sub-partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-29504 : invalid or missing schema name
  • ora-00340 : IO error processing online log string of thread string
  • ora-07497 : sdpri: cannot create trace file 'string'; errno = string.
  • ora-02784 : Invalid shared memory ID specified
  • ora-22914 : DROP of nested tables not supported
  • ora-32315 : REFRESH FAST of "string"."string" unsupported after mixed DML and Direct Load
  • ora-10660 : Segment is a shared lob segment
  • ora-30121 : 'string' is not an allowable value for 'string'
  • ora-12631 : Username retrieval failed
  • ora-28163 : GRANT already specified
  • ora-27500 : inter-instance IPC error
  • ora-19880 : Corrupted space header for datafile string, block string backup aborted
  • ora-13751 : "SQL Tuning Set" "string" does not exist for owner "string" or user "string" does not have permission to access the "SQL Tuning Set".
  • ora-27048 : skgfifi: file header information is invalid
  • ora-36212 : (XSAGOP06) In AGGMAP workspace object, you can only specify the MIN, MAX, FLOOR, and CEILING arguments while using the PROPORTIONAL operator, not string.
  • ora-31688 : Worker process string failed during startup.
  • ora-29818 : column name not properly specified
  • ora-06777 : TLI Driver: error reading parms
  • ora-16517 : the object handle is invalid
  • ora-12851 : PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, string
  • ora-01620 : no public threads are available for mounting
  • 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.