| Author |
Oracle connection problems
|
John Sinues
Ranch Hand
Joined: Feb 21, 2000
Posts: 52
|
|
I installed Oracle 9i as administrator of the local machine and can successfully establish a connection while logged on as administrator. However, when I log off and log in as myself onto the domain, I cannot connect. I've received both the and errors. The database and TNS name services are running. tnsping reports: sqlplus scott/tiger reports: The sqlnet.log file reports the following error: Any ideas what is preventing users of the domain from connecting to the Oracle database that was installed on the local machine and how I can fix this? Specs: Win2K SP4 Oracle 9i 512 MB RAM 50 GB HDD TIA, - John [ November 03, 2003: Message edited by: John Sinues ] [ November 03, 2003: Message edited by: John Sinues ] [ November 03, 2003: Message edited by: John Sinues ]
|
 |
John Sinues
Ranch Hand
Joined: Feb 21, 2000
Posts: 52
|
|
|
I think I resolved the issue. I commented out from sqlnet.ora. Now it looks like I can connect.
|
 |
SJ Adnams
Ranch Hand
Joined: Sep 28, 2001
Posts: 925
|
|
you are running bequeath protocol "PROTOCOL=beq" which means people from the domain should not be able to connect... are you still having problems?
|
 |
John Sinues
Ranch Hand
Joined: Feb 21, 2000
Posts: 52
|
|
|
Commenting out the above line from the sqlnet.ora file resolved the problem.
|
 |
 |
|
|
subject: Oracle connection problems
|
|
|