Home » RDBMS Server » Networking and Gateways » connection to databaswe
connection to databaswe [message #66425] Fri, 07 June 2002 03:51 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10707
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.
Previous Topic: Retrieve listener parameters through SQL
Next Topic: oracle error
Goto Forum:
  


Current Time: Wed Feb 21 01:15:14 CST 2024