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 : 29-05-2017

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

  • ora-32014 : error processing parameter "string" from the SPFILE restore image
  • ora-30377 : table string.MV_CAPABILITIES_TABLE not found
  • ora-29883 : cannot create a domain index on column expressions
  • ora-01240 : too many data files to add in one command
  • ora-12668 : Dedicated server: outbound protocol does not support proxies
  • ora-08444 : syntax error in JUSTIFIED clause in mask options
  • ora-13526 : baseline (string) does not exist
  • ora-28665 : table and partition must have same compression attribute
  • ora-06513 : PL/SQL: index for PL/SQL table out of range for host language array
  • ora-00384 : Insufficient memory to grow cache
  • ora-38414 : invalid datatype for the attribute string
  • ora-10658 : Lob column to be shrunk is marked unused
  • ora-39169 : Local version of string cannot work with remote version of string.
  • ora-30556 : functional index is defined on the column to be modified
  • ora-31502 : invalid number supplied for supplemental_processes
  • ora-13192 : failed to read number of element rows
  • ora-13461 : the interleaving type is not supported
  • ora-33290 : (DBERR17) Analytic workspace string cannot be attached in the mode you requested because another user has it attached in an incompatible mode.
  • ora-14098 : index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-02807 : Allocation of memory for I/O vectors failed.
  • ora-19645 : datafile string: incremental-start SCN is prior to creation SCN string
  • ora-02795 : Request list is empty
  • ora-25020 : renaming system triggers is not allowed
  • ora-09818 : Number is too large
  • ora-12048 : error encountered while refreshing materialized view "string"."string"
  • ora-00453 : backgroud process 'string' is dead
  • ora-32337 : cannot alter materialized view with pending changes refresh on commit
  • ora-38750 : FLASHBACK DATABASE may not be performed using a dispatcher.
  • ora-22614 : error while construction the collection in the image
  • ora-06928 : CMX: wrong ORACLE_SID
  • 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.