Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
If I change tnsnames.ora should I restart oracle 2
- Thread starter greenpee
- Start date
-
1
- #2
No. Just restart the application you are running to access the database.
Check your TNSnames file format is correct and that all SID or SERVICES are correctly defined, along with the port number (usually 1521 or 1526).
Also ensure the SQLNET.ora file matches the format expected in the TNSnames file. ie. Some SQLNET files specify a domain of .world which means the entries in TNSnames COMMUNITY must also match the domain.
Is your listener running?
Check your TNSnames file format is correct and that all SID or SERVICES are correctly defined, along with the port number (usually 1521 or 1526).
Also ensure the SQLNET.ora file matches the format expected in the TNSnames file. ie. Some SQLNET files specify a domain of .world which means the entries in TNSnames COMMUNITY must also match the domain.
Is your listener running?
-
1
- #3
SantaMufasa
Technical User
Green,
Changes to the tnsnames.ora take effect immediately. Re-booting Oracle has no effect upon tnsnames.ora files. If you are seeing the error, "TNS: no liserner", then it is not a database issue. I would check to ensure that the listener on the target machine is behaving properly. On the machine that domiciles your target database, at the o/s prompt, issue the command: "lsnrctl". At the Listener control prompt, enter the command, "status"; you should see the SID of your target instance. That is a good place to start. If that troubleshooting bears no fruit, let us know and we diagnose further.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA @ 17:22 (01Oct04) UTC (aka "GMT" and "Zulu"), 10:22 (01Oct04) Mountain Time)
Changes to the tnsnames.ora take effect immediately. Re-booting Oracle has no effect upon tnsnames.ora files. If you are seeing the error, "TNS: no liserner", then it is not a database issue. I would check to ensure that the listener on the target machine is behaving properly. On the machine that domiciles your target database, at the o/s prompt, issue the command: "lsnrctl". At the Listener control prompt, enter the command, "status"; you should see the SID of your target instance. That is a good place to start. If that troubleshooting bears no fruit, let us know and we diagnose further.
Mufasa(aka Dave of Sandy, Utah, USA @ 17:22 (01Oct04) UTC (aka "GMT" and "Zulu"), 10:22 (01Oct04) Mountain Time)
- Status
Similar threads
