Problems connecting from Client to Database
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.