Re: Strange Oracle Net8 problem on Tru64 Unix.. (102 Views)
Reply
Occasional Visitor
Tuncay Ergun
Posts: 1
Registered: ‎07-24-2003
Message 1 of 5 (102 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.
Please use plain text.
Honored Contributor
Ralf Puchner
Posts: 1,657
Registered: ‎04-22-2003
Message 2 of 5 (102 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;; }
Please use plain text.
Honored Contributor
Volker Borowski
Posts: 1,521
Registered: ‎04-20-1998
Message 3 of 5 (102 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

Please use plain text.
Honored Contributor
twang
Posts: 1,264
Registered: ‎11-15-2000
Message 4 of 5 (102 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.
Please use plain text.
Honored Contributor
Michael Schulte zur Sur
Posts: 4,040
Registered: ‎06-18-2003
Message 5 of 5 (102 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
Please use plain text.
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