connection to databaswe [message #66425] |
Fri, 07 June 2002 03:51 |
Novica Stefanovic
Messages: 2 Registered: June 2002
|
Junior Member |
|
|
Hello,
after installation of Oracle 8i Server Personal Edition for Win98(on my local computer,of course), I wasn't able anymore to connect to Oracle 7 Server Release 7.2.3.0(through LAN), using various application tools, for example PL/SQL Developer....
getting message :ORA-12154: TNS: Could not resolve service name.
When I uninstall Oracle 8i,everything is back to normal--I can(again) connect to Oracle 7 and work without problem...
WHAT SHOULD I DO WITH TNSNAMES ????
|
|
|
Re: connection to databaswe [message #66427 is a reply to message #66425] |
Fri, 07 June 2002 08:30 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
i beleive,
different copies of tnsnames.ora are maintained.
so using the same sqlplus.exe(one in the personal) to connect to both personal database and in network.
add tnsnames .ora entries to connect to the other databases in network in the tnsnames.ora used by personal edition.
|
|
|