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-07-2017

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

  • ora-23401 : materialized view "string"."string" does not exist
  • ora-13119 : invalid edge_id [string]
  • ora-31011 : XML parsing failed
  • ora-39017 : Worker request not supported when job is in string state.
  • ora-14056 : partition number string: sum of PCTUSED and PCTFREE may not exceed 100
  • ora-19578 : end of volume while duplexing to sequential files, backup piece incomplete
  • ora-22800 : invalid user-defined type
  • ora-39317 : call to DBMS_SCHEMA_COPY.VALIDATION_CHECK is not legal
  • ora-29522 : authorization error for referenced name string.string
  • ora-28022 : cannot grant external roles to global user or role
  • ora-07237 : slemcl: invalid file handle, seals do not match.
  • ora-29337 : tablespace 'string' has a non-standard block size (string)
  • ora-39962 : invalid parameter for PLSQL_CCFLAGS
  • ora-32643 : invalid use of window function in MODEL rule
  • ora-08341 : On nCUBE, this command can only be executed from instance 1.
  • ora-28042 : Server authentication failed
  • ora-19556 : required destination LOG_ARCHIVE_DUPLEX_DEST currently is deferred
  • ora-09793 : szguns: length of user name is greater than buffer.
  • ora-37101 : (XSVPART01) Partitioning information can only be given for variables dimensioned by a PARTITION TEMPLATE.
  • ora-13771 : cannot obtain exclusive lock string on "SQL Tuning Set" "string" owned by user "string"
  • ora-32815 : message system link string is referenced by a foreign queue
  • ora-01102 : cannot mount database in EXCLUSIVE mode
  • ora-26514 : object 'string.string' not found
  • ora-22627 : tc [string] must be that of object/varray/nested table
  • ora-23331 : column group string does not exist
  • ora-26521 : rpc initialization error
  • ora-01089 : immediate shutdown in progress - no operations are permitted
  • ora-40303 : invalid prior probability specification
  • ora-14023 : creation of GLOBAL partitioned cluster indices is not supported
  • ora-02815 : Unable to attach shared memory
  • 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.