ORA-28546: connection initialization failed, probable Net8
admin error
Answer Posted / guest
Cause: A failure occurred during initialization of a network
connection from the Oracle server to a second process: The
connection was completed but a disconnect occurred while
trying to perform protocol-specific initialization, usually
due to use of different network protocols by opposite sides
of the connection. This usually is caused by incorrect Net8
administrative setup for database links or external
procedure calls. The most frequent specific causes are: --
Database link setup for an Oracle-to-Oracle connection
instead connects to a Heterogeneous Services agent or an
external procedure agent. -- Database link setup for a
Heterogeneous Services connection instead connects directly
to an Oracle server. -- The extproc_connection_data
definition in tnsnames.ora connects to an Oracle instance
instead of an external procedure agent. -- Connect data for
a Heterogeneous Services database link, usually defined in
tnsnames.ora, does not specify (HS=). -- Connect data for an
Oracle-to-Oracle database link, usually defined in
tnsnames.ora, specifies (HS=).
Action: Check Net8 administration in the following ways: --
When using TNSNAMES.ORA or an Oracle Names server, make sure
that the connection from the ORACLE server uses the correct
service name or SID. -- Check LISTENER.ORA on the connection
end point's host machine to assure that this service name or
SID connects to the correct program. -- Confirm in
TNSNAMES.ORA or the equivalent service definition that
service 'extproc_connection_data' does NOT contain (HS=), or
that the service definition used by a Heterogeneous Services
database link DOES contain (HS=).
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?
ORA-16516: The current state is invalid for the attempted operation.
ORA-26076: cannot set or reset value after direct path structure is allocated
ORA-26082: load of overlapping segments on table string.string is not allowed
When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............
ORA-16626: failed to enable specified object
ORA-26095: unprocessed stream data exists
ORA-07497: sdpri: cannot create trace file 'string'; errno = string.
ORA-26094: stream format error: input column overflow
ORA-26079: file "string" is not part of table string.string
IMP-00070: Lob definitions in dump file are inconsistent with database.
IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created
NZE-28890: Entrust Login Failed
ORA-26027: unique index string.string partition string initially in unusable state
IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier