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

From: Vince Laurent <vlaurent_at_NOSPAM.networkusa.net>
Date: Tue, 11 Jun 2002 14:06:23 -0500
Message-ID: <19icgugr26ji29js5nk7f25v0i98k5skv3@4ax.com>

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:06:23 CDT