Home » RDBMS Server » Networking and Gateways » ORA-28546
ORA-28546 [message #206659] Fri, 01 December 2006 00:46 Go to next message
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
Re: ORA-28546 [message #206667 is a reply to message #206659] Fri, 01 December 2006 00:57 Go to previous messageGo to next message
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
Re: ORA-28546 [message #206767 is a reply to message #206667] Fri, 01 December 2006 07:12 Go to previous messageGo to next message
saikatermail
Messages: 20
Registered: November 2006
Location: Hyderabad
Junior Member
Done. But the problem is still there.
Re: ORA-28546 [message #206783 is a reply to message #206767] Fri, 01 December 2006 07:46 Go to previous messageGo to next message
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 Go to previous message
saikatermail
Messages: 20
Registered: November 2006
Location: Hyderabad
Junior Member
Done the same. Listener Status is Ready. But, problem is still there.
Previous Topic: [SOLVED] ORA-31202: DBMS_LDAP: LDAP client/server error: Insufficient
Next Topic: oracle error
Goto Forum:
  


Current Time: Fri Dec 09 02:12:46 CST 2016

Total time taken to generate the page: 0.16280 seconds