| Strange problem connecting on Windows 2000 [message #61519] |
Fri, 30 April 2004 13:38  |
Wendy Hopper
Messages: 3
Registered: July 2003
|
Junior Member |
|
|
I have just been assigned to try to do testing on a Windows 2000 machine. Oracle 8.1.7 had already been installed and an instance 'abc' existed. Something weird is going on and I'm sure it is a configuration problem, but I can't figure out where. When I am at a command prompt and perform set ORACLE_SID=abc, and then try to connect to db, I receive the common 12560 error. HOWEVER, when I type sqlplus user/pwd@ abc I am able to connect fine. The service is set up in tnsnames.ora and listener.ora. Does anyone have any troubleshooting tips they can share?
Thanks in advance.
|
|
|
|
| Re: Strange problem connecting on Windows 2000 [message #61539 is a reply to message #61519] |
Tue, 04 May 2004 10:21  |
Bernie Anderson
Messages: 1
Registered: May 2004
|
Junior Member |
|
|
I have this problem all the time, sometimes and I stress only sometimes! setting the sqlnet.ora parameter NAMES.AUTHENTICATION_SERVICES to = (NONE)e.g. NAMES.AUTHENTICATION_SERVICES = (NONE) works I do not know why it does not always work I suspect it is something to do with windows security.
HTH.
Bernie
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
