Re: Still Problem with ORA-12514

Hi,

If you are sure other recomendations are correct, open your tnsnames.ora with a text editor, check if there is a weird character(i.e. tabs) in it. Or remove your tnsnames.ora, then recreate it.

danisment...

Suzy Vordos wrote:

> You can have a tnsnames.ora in each ORACLE_HOME, but not recommended
> because you'd need to maintain multiple copies.
>
> Try stopping/restarting the listener, and be certain you're running only
> the listener for the highest version of Oracle.
>
> On rare occasion something in sqlnet.ora causes problems. You could
> temporarily rename it (or comment out the contents) and see if that
> makes a difference.
>
> Hamid Alavi wrote:
> >
> > I did it and still NOT working,
> > Question? Can I have one tnsnames.ora for BOTH oracle-home or not???
> >
> > -----Original Message-----
> > Sent: Friday, April 05, 2002 12:29 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > 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: 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).
> >
> > ======================= Confidentiality Statement =======================
> > 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.
> > ===================== End Confidentiality Statement =====================
> >
> > 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).

--
Danisment Gazi Unal
http://www.unal-bilisim.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal
  INET: dunal_at_unal-bilisim.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).