OraFAQ Forum: Networking and Gateways » End of my rope with listners

Home » RDBMS Server » Networking and Gateways » End of my rope with listners

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

End of my rope with listners [message #135625]

Thu, 01 September 2005 10:41

cosmosis
Messages: 3
Registered: September 2005

Junior Member

I have installed oracle 10g on serveral win xp Pro boxes with no problem at all. But the last few days I have had the same problem over and over with an install on an oracle 10g R1 on a windows server 2003 box.

Install goes fine. But the default listeners wont work. I have tried using netca to create listeners and still no joy. I always get the following out of lsnrctl:

C:\Documents and Settings\cosmosis>lsnrctl

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 31-AUG-2005 21:06
:03

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=p2p.seamlessp2p.net)(POR
T=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
LSNRCTL>

I have uninstalled oracle 10g and wiped its install directory afterward. Reinstalled completely. Same exact errors with listner.

I really need some help on this one. I am totally baffled why a listner created in netca would fail to work.

Report message to a moderator

Re: End of my rope with listners [message #135630 is a reply to message #135625]

Thu, 01 September 2005 10:56

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

YOu have not started the listener.
'lnsrctl start' would do that.
If it gives error post the exact error message along your listener.ora

Report message to a moderator

Re: End of my rope with listners [message #135647 is a reply to message #135630]

Thu, 01 September 2005 12:07

cosmosis
Messages: 3
Registered: September 2005

Junior Member

LSNRCTL> start
Starting tnslsnr: please wait...

Failed to start service, error 3.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error

LSNRCTL>

listner.ora

# listener.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = p2p.seamlessp2p.net)(PORT = 1521))
)
)
)

tnsnames.ora

# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = p2p.seamlessp2p.net)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

Any ideas?

Report message to a moderator

Re: End of my rope with listners [message #135651 is a reply to message #135647]

Thu, 01 September 2005 12:34

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Where are the listener entries for this database?
You have not configured the listener at all~.
And always with tnsnames.ora and listener.ora , preserve the formatting. Spaces around equals '=' does matter here.

This is a sample listener.ora
You are missing the portions between lines 10 and 13 ( where your listener
identifies the instances it is supposed to handle).
Copy these entries, replace with your values.

     1  # listener.ora Network Configuration File: /home/oracle/10g/network/admin/listener.ora
     2  # Generated by Oracle configuration tools.
     3  SID_LIST_LISTENER =
     4    (SID_LIST =
     5      (SID_DESC =
     6        (SID_NAME = PLSExtProc)
     7        (ORACLE_HOME = /u01/10g)
     8        (PROGRAM = extproc)
     9      )
    10       (SID_DESC =
    11        (ORACLE_HOME = /u01/10g)
    12        (SID_NAME = teng)
    13      )
    14
    15    )
    16
    17  LISTENER =
    18    (DESCRIPTION_LIST =
    19      (DESCRIPTION =
    20        (ADDRESS_LIST =
    21          (ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1521))
    22        )
    23        (ADDRESS_LIST =
    24          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    25        )
    26      )
    27    )
    28

Report message to a moderator

Re: End of my rope with listners [message #135654 is a reply to message #135651]

Thu, 01 September 2005 12:51

cosmosis
Messages: 3
Registered: September 2005

Junior Member

Those were the listner and TNS files created by the default install.

In all my previous installs on XP Pro the oracle 10g install would create a default listner and a default orlc TNS that I could use.

I did just find the problem.

Apparently under windows server 2003 uninstall of oracle does not remove the oracle listner services. Thus there were like 5 zombie listner services for other install locations. Probably causing the problems I was seeing. I used the windows resource toolkit to uninstall the zombie services and did a complete reinstall of oracle 10g and now the default listner and TNS are working. And I can create new TNS now.

Thanks for the responses but I think the problem I was having was more to do with windows 2003 not allowing services to be removed by the uninstaller than anything else.

Report message to a moderator

Previous Topic:	Shared Server Configuration Doubt
Next Topic:	TNS package - SQL*Net messages waits

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 18:21:31 CDT 2024