Home » Developer & Programmer » Designer » How to Find Which INIT.ORA and TNSNAMES
How to Find Which INIT.ORA and TNSNAMES [message #90630] Mon, 07 June 2004 03:34 Go to next message
babu
Messages: 16
Registered: September 1999
Junior Member
How can we find which init.ora and tnsnames being used .

PS: I dont have DBA Permissions.....
Re: How to Find Which INIT.ORA and TNSNAMES [message #90707 is a reply to message #90630] Fri, 20 August 2004 05:51 Go to previous message
Balaji
Messages: 102
Registered: October 2000
Senior Member
1.usually the tnsnames refer to the connect string passed on during log on.These are available in a file called tnsnames.ora on the client.Hopefully one of the names in this file must be corresponding to your connect string connecting to your host machine , the oracle server.

2.since you are NOT a DBA you are lucky to forget these.

3.IF you are so curious type this command on the DOS Prompt like this
eg:
E:> tnsping <connect string>

where connect string is the one you pass on during log on in addition to the username and password.

with best wishes
balaji
Previous Topic: migration
Next Topic: PLEASE HELP
Goto Forum:
  


Current Time: Thu Mar 28 19:32:49 CDT 2024