Home » RDBMS Server » Server Administration » Help! Net8 connection testing ! Urgent
Help! Net8 connection testing ! Urgent [message #54267] Thu, 07 November 2002 13:34 Go to next message
JOHN
Messages: 182
Registered: April 1998
Senior Member
Hi,
I'm trying to connect to an oracle oracle 8.1.7 server running on a solaris system from the internet. The database instance on the server is called 'prd1'. I added the following entry in tnsnames.ora on the client system. But when trying to connect I keep getting the following error:


ORA-12545: Connect failed because target host or object does not exist

There may be an error in the fields entered,
or the server may not be ready for a connection.

Port 1521 is open on the server. What else should be open to get a connection?

Help please

Thanks
Oops forgot to add the tnsnames entry [message #54268 is a reply to message #54267] Thu, 07 November 2002 14:21 Go to previous message
JOHN
Messages: 182
Registered: April 1998
Senior Member
Here it is:
prd1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 125.121.341.43)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = proddb1)
)
)
Previous Topic: Temp Segments in Non-Temp Tablespaces
Next Topic: dB crash/restore problem
Goto Forum:
  


Current Time: Thu Sep 19 17:05:38 CDT 2024