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 : 24-09-2017

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

  • ora-12539 : TNS:buffer over- or under-flow
  • ora-32162 : Read/Write SQL method not registered
  • ora-02331 : cannot create constraint on column of datatype string
  • ora-12707 : error while getting create database NLS parameter string
  • ora-03207 : subpartitioned type must be specified for composite object
  • ora-01320 : Invalid Logminer dictionar attribute
  • ora-27230 : OS system call failure
  • ora-13610 : The directive string does not exist for task string.
  • ora-00404 : Convert file not found: 'string'
  • ora-06904 : CMX: no transport address available for remote application
  • ora-25233 : invalid parameter specified for NAVIGATION
  • ora-02063 : preceding stringstring from stringstring
  • ora-26576 : cannot acquire SR enqueue
  • ora-28559 : FDS_CLASS_NAME is string, FDS_INST_NAME is string
  • ora-02391 : exceeded simultaneous SESSIONS_PER_USER limit
  • ora-30038 : Cannot perform parallel insert on non-partitioned object
  • ora-19006 : XMLType TYPE storage option not appropriate for storage type
  • ora-31402 : unrecognized parameter string
  • ora-28023 : must revoke grants of this role to other user(s) first
  • ora-19605 : input filename must be specified
  • ora-00216 : control file could not be resized for migration from 8.0.2
  • ora-30163 : The thread safety initialization failed
  • ora-26525 : session connection attempt failed for string (@string)
  • ora-07217 : sltln: environment variable cannot be evaluated.
  • ora-13635 : The value provided for parameter string cannot be converted to a number.
  • ora-38458 : invalid operation "string" for XPATH_FILTER_PARAMETERS
  • ora-13347 : the coordinates defining an arc are not distinct
  • ora-10616 : Operation not allowed on this tablespace
  • ora-01016 : This function can be called only after a fetch
  • ora-00600 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • 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.