Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problems connecting from Client to Database

349402Oct 4 2002
I've run into a strange situation,
We are running Oracle 8.1.7 installed on Sco?!? In the past everyone has just opened a netterm connection from windows 2000 to the box that the database exists on and run SQL Plus from within that window. They do not use any of the client side Oracle tools.
I just started working here and was trying to explain the benefits of some of the existing Oracle tools that are out there. I installed Discoverer along with some other tools and was having troubles connecting. I uninstalled everything and started with just SQL Plus. The following is my tnsnames entry for the database:

oradev =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = ORADEV)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = DVCX)
)
)

and the error that I get when I try to connect is:

ORA-12514: Message 12514 not found; product=RDBMS80; facility=ORA

The strange thing is that I installed JDeveloper and told it to start a SQL Plus session and it works fine. It is pointing at the exact same executable that I tried running from the start menu. C:\ORACLE\806\BIN\PLUS80W.EXE

I tried running this executable frmo the Dos prompt using this:

C:\ORACLE\806\BIN\PLUS80W.EXE user/passwd@oradev:1521:DVCX

and I get this error message:

ORA-06401: NETCMN: invalid driver designator

Does anyone have any ideas? It would be really nice to be able to show these guys why they spent so much money to buy Oracle. Right now they're only using it to store data.

Any responses would be appreciated. If I don't know the answer to your questino I can ask around and find it.

Thanks,
Chris S.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2002
Added on Oct 4 2002
12 comments
527 views