Re: ORA-12541: TNS: no listener..and

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 28 Oct 2003 13:58:34 -0800
Message-ID: <1067378331.710313@yasure>

carlo wrote:

>>Go to c:\oracle\ora81\bin and type the following at the DOS prompt:
>>lsnrctl start
>>
>>
>-Well, the answer is: (translated in english)....
> TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production
> The file of system parameter is: D:\oracle\ora81\network\admin\listener.ora
> Log messages in D:\oracle\ora81\network\log\listener.log
> TNS-01150: The address of the listener name is wrong
>
>- I saw those files and in listener.log I read: "Actual trace level is 0"
> (maybe the reason I don't have the file listener.trc)
>
>- In listsener.ora I have: LISTENER = JAM , which is the name I have to use
> in BEA Weblogic server to create a connection pool:
> URL=jdbc:oracle:thin:@IPAddress:jam
>
>I don't know what is jam, (I dont't know what a listener is) I only know It
>must matches
>in listener.ora in this way:
>
>JAM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = IPAddress)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = DBNAME)
> )
> )
>
>
>Thanks for your attention!!!
>
>
>
>
>"Daniel Morgan" <damorgan_at_x.washington.edu> ha scritto nel messaggio
>news:1067264151.326476_at_yasure...
>
>
>>carlo wrote:
>>
>>
>>
>>>Hello,
>>>I get this error... could be because in windows service I can't start
>>>the: OracleOraHome81TNSListener on local computer, service?
>>>Could anyone help me, please?
>>>
>>>TIA
>>>
>>>
>>>
>>>
>>Not really because you apparently think telling people what you've tried
>>to do that didn't
>>work wouldn't be of value.
>>
>>But working with just a guess:
>>Go to c:\oracle\ora81\bin and type the following at the DOS prompt:
>>lsnrctl start
>>
>>If that doesn't work post the complete error message you receive.
>>
>>--
>>Daniel Morgan
>>http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
>>http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
>>damorgan_at_x.washington.edu
>>(replace 'x' with a 'u' to reply)
>>
>>
>>

Here's a generic LISTENER.ORA to use as a model for yours:

# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = NTORA)(PORT = 1521))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\ora92)
      (PROGRAM = extproc)

    )
  )

In the above case NTORA is the name of the host machine.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Tue Oct 28 2003 - 15:58:34 CST