Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle connection problems

 
John Sinues
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think I resolved the issue. I commented out from sqlnet.ora. Now it looks like I can connect.
 
SJ Adnams
Ranch Hand
Posts: 925
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Commenting out the above line from the sqlnet.ora file resolved the problem.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic