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

I think if you'll change your connect string to system@(password)@QAS.WORLD it will work.

On Tue, 11 Jun 2002 14:06:23 -0500, Vince Laurent <vlaurent_at_NOSPAM.networkusa.net> 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
Received on Tue Jun 11 2002 - 14:32:01 CDT