Home » RDBMS Server » Networking and Gateways » Can i log to a remote oracle 920i database from an oracle 80 client
Can i log to a remote oracle 920i database from an oracle 80 client [message #126185] Fri, 01 July 2005 07:10 Go to next message
hrforafaq
Messages: 8
Registered: July 2005
Junior Member
Could u help me to connect remotely to an oracle920i database
using forms 6 or sqlplus 8.0. i don't know if it's possible.
My Oracle 9i database is installed on Windows 2000 server and i have no problem to log in localy. i check the listener it run with success. I get the message ( both in sql plus 8 and forms 6) :
connect system/password@hostname.domanine.net

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

full thanks

Report message to a moderator

Re: Can i log to a remote oracle 920i database from an oracle 80 client [message #126228 is a reply to message #126185] Fri, 01 July 2005 13:29 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Hi

On the client side, u need to modify the tnsnames.ora file & add oracle servers SID information there.
After that check for the connectivity using tnsping <service_identifier>.

Regds
Girish

Report message to a moderator

Previous Topic: sqlplus from run command
Next Topic: oracle connectivity
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 21:50:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.