In tnsnames.ora set SERVICE_NAME=cms.hollywood, and in listener.ora
remove SID_DESC for that database as it's really not needed for 8i.
Here's what my config looks like:
# ----------------------
# Filename: listener.ora
# ----------------------
LSNR01 =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY=lsnr01))
(ADDRESS= (PROTOCOL= TCP)(Host= host.domain)(Port= 1521))
)
STARTUP_WAIT_TIME_LSNR01 = 0
CONNECT_TIMEOUT_LSNR01 = 10
TRACE_LEVEL_LSNR01 = OFF
LSNR02 =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY=lsnr02))
(ADDRESS= (PROTOCOL= TCP)(Host= host.domain)(Port= 1526))
)
STARTUP_WAIT_TIME_LSNR02 = 0
CONNECT_TIMEOUT_LSNR02 = 10
TRACE_LEVEL_LSNR02 = OFF
# ----------------------
# Filename: tnsnames.ora
# ----------------------
orcl01 =
(DESCRIPTION =
(SDU = 8192)(TDU = 8192)
(ADDRESS = (PROTOCOL=TCP)(HOST=host.domain)(PORT=1521))
(ADDRESS = (PROTOCOL=TCP)(HOST=host.domain)(PORT=1526))
(CONNECT_DATA = (SERVICE_NAME = orcl01.world))
)
Hamid Alavi wrote:
>
> I am really Buffled, and need your help guys. Here is my Tnsnames.ora &
> listener.ora & sqlnet.ora in server side:
>
> db-name = "CMS" , db_domain="hollywood" , instance_name = CMS ,
> service_name = CMS.HOLLYWOOD
>
> LISTENER.ora on Server:
> # LISTENER.ORA Network Configuration File:
> /u04/app/oracle/network/admin/listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521))
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 2481))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /u04/app/oracle)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = CMS.HOLLYWOOD)
> (ORACLE_HOME = /u04/app/oracle)
> (SID_NAME = CMS)
> )
> )
> ----------------------------------------------------------------------------
> ----------------
> TNSNAMES.ora on server side:
>
> # TNSNAMES.ORA Network Configuration File:
> /u04/app/oracle/network/admin/tnsnames.ora
> # Generated by Oracle configuration tools.
>
> CMS =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = CMS)
> )
> )
>
> INST1_HTTP =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME = CMS)
> (PRESENTATION = http://admin)
> )
> )
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> ------------------------------------------------------------------------
> # SQLNET.ORA Configuration File:/u01/app/oracle/network/admin/sqlnet.ora
> # Generated by Oracle configuration tools.
>
> # NAMES.DEFAULT_DOMAIN = hollywood
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
>
> I know all of you are busy but may be you can see some thing which I
> couldn't, I did my best and couldn't solve the problem.
> Thanks allot
> Have a nice Day.
>
> Hamid Alavi
> Office 818 737-0526
> Cell 818 402-1987
>
> The information contained in this message and any attachments is intended
> only for the use of the individual or entity to which it is addressed, and
> may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
> disclosure under applicable law. If you have received this message in error,
> you are prohibited from copying, distributing, or using the information.
> Please contact the sender immediately by return e-mail and delete the
> original message from your system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suzy Vordos
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
