Home » RDBMS Server » Backup & Recovery » ORA-28546
ORA-28546 [message #205106] Thu, 23 November 2006 05:57 Go to next message
saikatermail
Messages: 20
Registered: November 2006
Location: Hyderabad
Junior Member
Hi,

I am getting ORA-28546 at the time follwoing SQL

"SELECT * FROM EMPLOYEE@ACCESS_DB"

1. Public Database Link : ACCESS_DB

2. System DSN of MS ACCESS : ACCESS_DSN

3. D:\ORACLE\ORA92\HS\INITHSOBDC.ORA

HS_FDS_CONNECT_INFO = ACCESS_DSN
HS_FDS_TRACE_LEVEL = OFF

4. LISTENER.ORA

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = MY_SERVER)
(PORT = 1521)
)
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC=
(SID_NAME=ORACLE_DB)
(ORACLE_HOME = D:\ORACLE\ORA92)
(PROGRAM = HSODBC)
)
)

5. TNSNAMES.ORA

ORACLE_DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MY_SERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORACLE_DB)
)
)

ACCESS_DB=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TEXTILE)(PORT = 1521))
)
(CONNECT_DATA = (SID = ORACLE_DB))
(HS=OK)
)

Please suggest me the solutions

Saikat
Re: ORA-28546 [message #205112 is a reply to message #205106] Thu, 23 November 2006 06:11 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

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


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=).



http://forums.oracle.com/forums/thread.jspa;jsessionid=8d92200830dee2d643a93c0c461a9daf9b8d93a94d39.e34QbhuKaxmMai0MaNeMb3aTc3v0?messageID=751046&#751046



http://asktom.oracle.com/pls/ask/f?p=4950:61:4819006867776489938::::P61_ID:4406708207206#18830681837358



Hope this helps
Taj.


If you fix ur problem reply.
Previous Topic: No-Logging Table with Archive Log
Next Topic: Db export/import
Goto Forum:
  


Current Time: Sun Dec 11 05:58:10 CST 2016

Total time taken to generate the page: 0.11068 seconds