Cant connect to new database

[dreampolice]

An Oracle 9i database I was connecting to was moved to another server.
I was given a new hostname and sid which I changed in my tnsnames.ora for my Oracle Client.

I can ping the server using ftp such as:
ping ftp.myserver.here.com

I try and connect using Oracle Client and using the command:

tnsping ftp.myserver.here.com

and they both gave me the following error:
ORA-12537: TNS:connection closed

Please advise?

 

[Welshbird]

I think you also need to check/change the listener as well.

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]

 

[SantaMufasa]

Dream,

What are the results of the following exercise on the new server that is the venue for your Oracle instance?:

% lsnrctl
LSNRCTL> status

What response do you receive when you attempt your Oracle connection (also using the tnsnames.ora alias for that instance) to that database from that same machine where you just did the lsnrctl?

If that connection works, then compare the tnsnames.ora entries on that machine with the counterpart tnsnames.ora entry for that Oracle server on your remote machine.

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[dreampolice]

Thanks,

I found out the hostname was incorrect and it now works.

For future knowledge, is there anyway to find the Oracle Database hostname (to be used in my tnsnames.ora) after I log onto a Server that hosts the actual database?

 

[KenCunningham]

If *nix, uname -a should tell you the hostname.