Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How does Oracle use the parameter GLOBAL_DBNAME in listener.ora ?

How does Oracle use the parameter GLOBAL_DBNAME in listener.ora ?

From: TAG DBA <dbatag_at_tatainfotech.com>
Date: Thu, 31 May 2001 04:02:25 -0700
Message-ID: <F001.003154B5.20010531041120@fatcity.com>

How does Oracle use the parameter GLOBAL_DBNAME in listener.ora ? I faced this problem:
Note: The SERVICE_NAMES parameter was set to SFA in the init.ora file File listener.ora is
SID_LIST_JLISTENER =
(SID_LIST =

(SID_DESC =      
        (GLOBAL_DBNAME = SFA)

(ORACLE_HOME = /home6/sfa/app/oracle/product/8.1.5)
(SID_NAME = SFAPP) ) )

File tnsnames.ora on client is
SFTEST.IN.TATAINFOTECH.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 163.122.32.59)(PORT = 2521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = SFAPP)

    )
  )

When I tried to connect from client I got a error : "Unable to resolve service name". When I commented out GLOBAL_DBNAME = SFA - the connection worked !!! I am trying to understand what was going worng - since the tnsnames and listener was generated
by Oracle utilities.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: TAG DBA
  INET: dbatag_at_tatainfotech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu May 31 2001 - 06:02:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US