Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Still Problem with ORA-12514
I have had one instance (out of many) where using a hostname would not work.
I was getting the same error and I had to use the IP address in the Listener
to get it to work. There were two IP addresses and the listener was
accessing the second address where the client was accessing the first IP
address.
Laura
-----Original Message-----
Sent: Saturday, April 06, 2002 12:08 PM
To: Multiple recipients of list ORACLE-L
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)
> > > )
> > > )
> > >
> >
-- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Burton, Laura L. INET: BurtonL_at_prismplus.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 Sat Apr 06 2002 - 12:38:18 CST
![]() |
![]() |