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 : 28-05-2017
ORA-28546

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

  • ora-23514 : invalid or incorrect number of arguments
  • ora-26682 : invalid value for publication_on
  • ora-34210 : (MXCHGDCL18) You cannot change workspace object to a dimension composite because one or more surrogates has been defined for it.
  • ora-29253 : Invalid count argument passed to procedure dbms_sql.define_array
  • ora-24802 : user defined lob read callback error
  • ora-01243 : system tablespace file suffered media failure
  • ora-12696 : Double Encryption Turned On, login disallowed
  • ora-39208 : Parameter string is invalid for string jobs.
  • ora-31157 : Invalid Content-Type charset
  • ora-24059 : invalid COMPATIBLE parameter setting string specified in DBMS_AQADM.string
  • ora-01999 : password file cannot be updated in SHARED mode
  • ora-16638 : could not get the instance status
  • ora-29830 : operator does not exist
  • ora-38432 : EVALUATE operator only allowed on an expression column
  • ora-24317 : define handle used in a different position
  • ora-13370 : failure in applying 3D LRS functions
  • ora-25209 : invalid value string, EXPIRATION should be non-negative or NEVER
  • ora-02047 : cannot join the distributed transaction in progress
  • ora-40222 : data mining model export failed, job name=string, error=string
  • ora-39092 : unable to set SCN metadata for object "string.string" of type string
  • ora-16246 : User initiated abort apply successfully completed
  • ora-12667 : Shared server: outbound transport protocol different from inbound
  • ora-13205 : internal error while parsing spatial parameters
  • ora-13835 : invalid attribute name specified
  • ora-10642 : Found rollback segments in dictionary managed tablespaces
  • ora-36722 : (XSALLOC02) In AGGMAP workspace object, you specified an NA or ZERO sourceval but supplied formula workspace object as your source for ALLOCATE.
  • ora-06442 : ssvwatev: Failed with unexpected error number.
  • ora-07657 : slsprom:$ASSIGN failure
  • ora-31493 : could not prepare session for LogMiner session
  • ora-09758 : osnipn: could not check port in name server.
  • 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.