OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » ORA-28546

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-28546 [message #206659]

Fri, 01 December 2006 00:46

saikatermail
Messages: 20
Registered: November 2006
Location: Hyderabad

Junior Member

Hi,

I am getting ORA-28546 when trying to access data from MS Access 2000 Table. The steps I have done are as following.

1. Created System DSN name "ORACLE_ACCESS".
2. Added following lines in LISTENER.ORA
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORACLE_DB)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = HSODBC)
)
)
3. Executed lsnrctl stop
4. Executed lsnrctl start
5. Added following lines in INITHSODBC.ORA
HS_FDS_CONNECT_INFO=ORACLE_ACCESS
HS_FDS_TRACE_LEVEL = OFF
6. Added following lines in TNSNAMES.ORA
ORACLE_ACCESS.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = OS_SERVER)
(PORT = 1521)
)
)
(
CONNECT_DATA = (SID = ORACLE_DB)
)
(HS = OK)
)
7. Created Public Database Link ORACLE_ACCESS

Now, the following Select statement is generating ORA-28546

Select * from ACCESS_TABLE@ORACLE_ACCESS;

Please suggest the Solution

Saikat

Report message to a moderator

Re: ORA-28546 [message #206667 is a reply to message #206659]

Fri, 01 December 2006 00:57

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Hmm hard to say, but since it's on windows and it's an net adminstration error.
It could be realted to the NTS authentication.
try and set sqlnet.authentication_services=(NONE) in sqlnet.ora

Report message to a moderator

Re: ORA-28546 [message #206767 is a reply to message #206667]

Fri, 01 December 2006 07:12

saikatermail
Messages: 20
Registered: November 2006
Location: Hyderabad

Junior Member

Done. But the problem is still there.

Report message to a moderator

Re: ORA-28546 [message #206783 is a reply to message #206767]

Fri, 01 December 2006 07:46

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

What about

HS_FDS_TRACE_LEVEL=ON

That give you anything?

Also can you verfy the listner status

lsnrctl status

And see if that is runnig ok ?

[Updated on: Fri, 01 December 2006 08:07]

Report message to a moderator

Re: ORA-28546 [message #206883 is a reply to message #206783]

Fri, 01 December 2006 23:19

saikatermail
Messages: 20
Registered: November 2006
Location: Hyderabad

Junior Member

Done the same. Listener Status is Ready. But, problem is still there.

Report message to a moderator

Previous Topic:	[SOLVED] ORA-31202: DBMS_LDAP: LDAP client/server error: Insufficient
Next Topic:	oracle error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 17 23:14:42 CDT 2024