| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Still Problem with ORA-12514
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:
# ----------------------
# ----------------------
(ADDRESS= (PROTOCOL= IPC)(KEY=lsnr01))
(ADDRESS= (PROTOCOL= TCP)(Host= host.domain)(Port= 1521))
)
(ADDRESS= (PROTOCOL= IPC)(KEY=lsnr02))
(ADDRESS= (PROTOCOL= TCP)(Host= host.domain)(Port= 1526))
)
# ----------------------
# ----------------------
(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: hamid.alavi_at_quovadx.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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: lvordos_at_qwest.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 Fri Apr 05 2002 - 14:28:33 CST
 |
 |