07-25-2003 11:02 AM
After upgrading our database from 184.108.40.206 to 220.127.116.11, our perl scripts were broken with "ORA-12154: TNS: could not resolve service name" error. Database, listener, /etc/tnsnames.ora file, everything seems OK. Then later, after some desperate tries, I somehow figured out that it works if I put a dot just after the service name.
For example, assuming "SRVC" is the service name in the /etc/tnsnames.ora file,
"tnsping SRVC" doesn't work, while
"tnsping SRVC." works.
Have you ever seen this problem before?
I appreciate any help/advice.
07-27-2003 03:25 AM
08-04-2003 01:17 PM
is "db_domain" set in your Listener-configuration ?
Check Your Environment: from 8.1.7 on you have a new ORACLE_HOME whilst before this, upgrades where installed into the same ORACLE_HOME. May be something is missing here, esp. if TNS_ADMIN is used in your environment.
Hope this helps
08-11-2003 02:04 AM
is db_domain = world ?
or db_domain = .world ?
Remove the dot. The Dot is only used as a seperator if multi values are used.