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

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

  • ora-09280 : sllfcf: error closing file
  • ora-26020 : index string.string loaded successfully with string keys
  • ora-16712 : the resource handle is invalid
  • ora-14119 : specified partition bound is too long
  • ora-29926 : association already defined for the object
  • ora-26082 : load of overlapping segments on table string.string is not allowed
  • ora-25178 : duplicate PCTTHRESHOLD storage option specification
  • ora-32773 : operation not supported for smallfile tablespace string
  • ora-02198 : ONLINE/OFFLINE option already specified
  • ora-13775 : inconsistent datatype in input cursor
  • ora-14185 : incorrect physical attribute specified for this index partition
  • ora-31472 : Importing Change Data Capture version string.string is too new
  • ora-02258 : duplicate or conflicting NULL and/or NOT NULL specifications
  • ora-01657 : invalid SHRINK option value
  • ora-02055 : distributed update operation failed; rollback required
  • ora-24101 : stopped processing the argument list at: string
  • ora-06602 : LU6.2 Driver: Error allocating context area
  • ora-01316 : Already attached to a Logminer session
  • ora-13601 : The specified Advisor string does not exist.
  • ora-06413 : Connection not open.
  • ora-16756 : resource guard could not open standby database read-only
  • ora-19253 : XQ0033 - too many declarations for namespace prefix string
  • ora-26061 : Concurrent direct unloads is not allowed.
  • ora-25145 : allocation policy already specified
  • ora-28347 : encryption properties mismatch
  • ora-16614 : object has an ancestor that is disabled
  • ora-07549 : sftopn: $OPEN failure
  • ora-27010 : skgfwrt: write to file failed
  • ora-13369 : invalid value for etype in the 4-digit format
  • ora-00705 : inconsistent state during start up; shut down the instance, then restart it
  • 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.