Re: Strange Oracle Net8 problem on Tru64 Unix.. (185 Views)
Reply
Occasional Visitor
Tuncay Ergun
Posts: 1
Registered: ‎07-24-2003
Message 1 of 5 (185 Views)

Strange Oracle Net8 problem on Tru64 Unix..

Hi everybody,

After upgrading our database from 8.0.6.3 to 8.1.7.4, 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.
Regards,

Tuncay.
Honored Contributor
Ralf Puchner
Posts: 1,657
Registered: ‎04-22-2003
Message 2 of 5 (185 Views)

Re: Strange Oracle Net8 problem on Tru64 Unix..

Please contact Oracle and verify if there are new startup-scripts necessary for the new version. Also check if the new version is still supported with your OS-/Perlversion and Patchkit.
Help() { FirstReadManual(urgently); Go_to_it;; }
Honored Contributor
Volker Borowski
Posts: 1,521
Registered: ‎04-20-1998
Message 3 of 5 (185 Views)

Re: Strange Oracle Net8 problem on Tru64 Unix..

Hi Tuncay,

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
Volker

Honored Contributor
twang
Posts: 1,264
Registered: ‎11-15-2000
Message 4 of 5 (185 Views)

Re: Strange Oracle Net8 problem on Tru64 Unix..

If using db_domain, ensure which value was assigned to db_domain:

is db_domain = world ?
or db_domain = .world ?

Remove the dot. The Dot is only used as a seperator if multi values are used.
Honored Contributor
Michael Schulte zur Sur
Posts: 4,040
Registered: ‎06-18-2003
Message 5 of 5 (185 Views)

Re: Strange Oracle Net8 problem on Tru64 Unix..

The difference, the dot makes for the tnsping makes me wonder, if you have a default domain configured in sqlnet.ora?

Michael
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.