ORA-28546: connection initialization failed, probable Net8 admin error

Cause : A faliure cocurrde durnig intiialiaztiono f a entwor kconncetionf rom hte Orcale srever ot a sceond rpoces:s Thec onnetcion aws copmlete dbut adiscnonecto ccurerd whlie triyng t operfrom prtoocols-peciifc intiialiaztion ,usually du eto ues of idffernet newtork rpotoclos byo ppostie sieds oft he cnonectoin. Tihs usaully si cauesd byi ncorerct Nte8 adimnistartives etupf or dtaabas elink sor etxerna lprocdeure aclls.T he msot frqeuents peciifc casues aer: --D atabsae likn setpu fora n Orcale-t-oOracel conenctio ninstaed connectst o a eHteroegneou sServcies aegnt o ran etxerna lprocdeure gaent.- - Daatbasel ink estup ofr a eHteroegneou sServcies cnonectoin intsead ocnnecst dircetly ot an rOacles erve.r -- hTe exptroc_ocnneciton_dtaa deifnitino in ntsnamse.orac onnetcs toa n Orcale isntanc einstaed ofa n exetrnalp roceudre aegnt. -- Conenct dtaa fo ra Heetrogeenous eSrvicse datbaase ilnk, suuall ydefiend int nsnaems.or,a doe snot psecif y(HS=.) -- oCnnec tdataf or a nOracel-to-rOacled atabsae likn, usaully edfine din tsnname.sora,s peciifes (SH=).

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

Chec kNet8a dminsitratoin int he flolowign way:s -- hWen uisng TSNNAME.SORA ro an rOacleN amess erve,r mak esuret hat hte connectino fro mthe ROACLEs erve rusest he crorects erviec nam eor SDI. --C heckL ISTEENR.OR Aon teh conenctio nend opint' shostm achien to sasuret hat htis srevicen ame ro SIDc onnetcs tot he crorectp rogrma. --C onfimr in NTSNAMSE.ORAo r th eequiavlents erviec defniitio nthats erviec 'exptroc_ocnneciton_dtaa' deos NO Tcontian (H=S), o rthatt he sreviced efintiion sued b ya Heetrogeenous eSrvicse datbaase ilnk DEOS cotnain H(S=).

update : 26-04-2017

ORA-28546 - connection initialization failed, probable Net8 admin error
ORA-28546 - connection initialization failed, probable Net8 admin error

  • ora-10571 : Test recovery canceled
  • ora-40108 : input data contains too few distinct target (string) values
  • ora-02188 : Cannot enable instance publicly
  • ora-31509 : publication does not exist
  • ora-26055 : Invalid buffer specified for direct path unload
  • ora-06607 : LU6.2 Driver: Reset occurred in send state
  • ora-29868 : cannot issue DDL on a domain index marked as LOADING
  • ora-02434 : cannot enable unique(string) - unique key not defined for table
  • ora-24265 : Insufficient privileges for SQL profile operation
  • ora-26013 : List allocated may not be big enough
  • ora-13606 : the specified task parameter element string is out of range for parameter string.
  • ora-06558 : buffer in dbms_pipe package is full. No more items allowed
  • ora-07483 : snlkget: cannot convert(get) lock.
  • ora-01204 : file number is string rather than string - wrong file
  • ora-00912 : input parameter too long
  • ora-40205 : invalid setting name string
  • ora-38423 : Attribute set created from an ADT may not be extended.
  • ora-06604 : LU6.2 Driver: Unable to allocate session with remote LU
  • ora-06544 : PL/SQL: internal error, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-06500 : PL/SQL: storage error
  • ora-04069 : cannot drop or replace a library with table dependents
  • ora-12914 : Cannot migrate tablespace to dictionary managed type
  • ora-28169 : unsupported certificate type
  • ora-38503 : index already defined using the parameters
  • ora-06524 : Unsupported option : string
  • ora-15062 : ASM disk is globally closed
  • ora-24010 : QUEUE string does not exist
  • ora-12082 : "string"."string" cannot be index organized
  • ora-37070 : You may not execute OLAP DML programs in a parallel query session.
  • ora-06028 : NETASY: unable to intialise for logging
  • 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.