Home » SQL & PL/SQL » SQL & PL/SQL » New Database connection
New Database connection [message #218097] Tue, 06 February 2007 17:15 Go to next message
florida
Messages: 82
Registered: April 2006
Member
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 on my Windows 2000 Workstation.

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?
Re: New Database connection [message #218098 is a reply to message #218097] Tue, 06 February 2007 17:20 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Does a firewall reside between the client & the server now?
Re: New Database connection [message #218099 is a reply to message #218097] Tue, 06 February 2007 17:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> ping ftp.myserver.here.com
You are pinging the server. Not the database.

>>tnsping ftp.myserver.here.com
tnsping will look for the availablity of the listener. First make sure the listener is up and available.
You are supposed to use
tnsping your_tns_entry_in_tnsnames.ora

Are you sure that ftp.myserver.here.com is your tnsentry?
Re: New Database connection [message #218117 is a reply to message #218097] Tue, 06 February 2007 21:41 Go to previous messageGo to next message
florida
Messages: 82
Registered: April 2006
Member
It is behind a firewall and the other database was also behind firewall.


I am using the same entry that is in my tnsnames.ora which is:
ftp.myserver.here.com

Please advise.

Re: New Database connection [message #218135 is a reply to message #218117] Tue, 06 February 2007 23:25 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI,
can you post your listener.ora or tnsnames.ora file.
regards
Taj
Re: New Database connection [message #218179 is a reply to message #218117] Wed, 07 February 2007 02:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
What is the OS?
In case of windows,
The standard workaround for that is make the registry settting use_shared_socket=TRUE. Bounce the server. Try again.
Re: New Database connection [message #218234 is a reply to message #218097] Wed, 07 February 2007 07:46 Go to previous messageGo to next message
florida
Messages: 82
Registered: April 2006
Member
Thanks for all responses!

My sqlnet.ora shows the same error such as ORA-12537: TNS:connection closed

Where do I make registry setting on my Windows client?
I dont see any listener.ora file on my Windows client workstation after searching for it.

Here is my tnsnames.ora
mysidhere =
   (DESCRIPTION =
     (ADDRESS_LIST =
         (ADDRESS =
           (COMMUNITY = TCP)
           (PROTOCOL = TCP)
          (HOST = ftp.myserver.here.com
)
           (PORT = 1521)
          )
      )
     (CONNECT_DATA = (SID = mysidhere)
     (SERVER=DEDICATED)
    )

[Updated on: Wed, 07 February 2007 08:05]

Report message to a moderator

Re: New Database connection [message #218251 is a reply to message #218234] Wed, 07 February 2007 08:25 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
ORA-12537: TNS:connection closed
Your TNSENTRY is >>>>> MYSIDHERE.
again try to connect like
SQL>conn USER/pwd@mysidhere

before connect check below thing.
1.your listener services is running and SID is register with servers.
2.if you have more than one oracle home on your machine then set TNS_ADMIN variable to point correct TNSNAMES.ORA file.
3.again check your FIREWALL setting.
4.search on you machine SQLNET.LOG file. is there any error or message recoreded.



regards
Taj

[Updated on: Wed, 07 February 2007 08:26]

Report message to a moderator

Previous Topic: Max number of field in table?
Next Topic: Replacing variable string with a fixed part
Goto Forum:
  


Current Time: Sat Dec 03 06:16:21 CST 2016

Total time taken to generate the page: 0.10517 seconds