Re: HELP! TNS error and I can't get up!

Vince Laurent wrote:

> I am running Oracle 8.1.7.3 on HP-UX 11.
>
> In my tnsnames.ora file I have:
>
> # Filename......: tnsnames.ora
> # Created.......: created by SAP AG, R/3 Rel. >= 4.0A
> # Name..........:
> # Date..........:
> ################
>
> QAS.WORLD= (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST =
> (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP)
> (HOST = sapqas) (PORT = 1527) )
> )
> (CONNECT_DATA = (SID = QAS) (GLOBAL_NAME = QAS.WORLD)
> )
> )
>
> But when I query my database I get:
> SVRMGR> select name, value from v$parameter where
> name='service_names';
> NAME VALUE
> -----------------------------------------------------------------
> service_names QAS
>
> I checked the initQAS.ora file and servce_names is not set there. If
> I do as service_names=QAS.world I get the correct answer for the query
> above but I still don't get a good connection:
>
> (sapqas):/opt/omni/lbin:root# ./util_sap.exe -APP
> QAS /oracle/QAS/817_64 /usr/sap/QAS/SYS/exe/run system@(password)@QAS
> *RETVAL*0
> (sapqas):/opt/omni/lbin:root# ./util_sap.exe -CHKCONF QAS
> Oracle Login information:system@(password)@QAS
> Oracle Server Manager Release 3.1.7.0.0 - Production
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
> Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production
> With the Partitioning option
> JServer Release 8.1.7.3.0 - 64bit Production
> Password:
> ORA-12154: TNS:could not resolve service name
> Server Manager complete.
> *RETVAL*8706
>
> Any one have any ideas?
> Vince

Look at SQLNET.ORA

Daniel Morgan Received on Tue Jun 11 2002 - 14:36:51 CDT