File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes Oracle connection problems Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Oracle connection problems" Watch "Oracle connection problems" New topic
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle connection problems