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

"Vince Laurent" <vlaurent_at_NOSPAM.networkusa.net> wrote in message news:19icgugr26ji29js5nk7f25v0i98k5skv3_at_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

You are using the sid = syntax in your connect_data section. To do so you need to have a sid_list_<listenername> section in your listener.ora.
Try switching to service_name = in tnsnames.ora, service names register with the listener automatically.
The default domain currently is no longer world, but NULL. If you don't have a domain in your db_domain init.ora parameter you shouldn't use in it your service_name string.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address