OraFAQ Forum: Networking and Gateways » Listener problem

Home » RDBMS Server » Networking and Gateways » Listener problem (

) 1 Vote

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

Listener problem [message #177101]

Tue, 13 June 2006 01:32

viv_pol
Messages: 14
Registered: June 2006
Location: INDIa

Junior Member

hi...
i've installed oracle 9i on Linux Application server.
when start lsnrctl service on linux server, following error occurs:

LSNRCTL> start
Starting /usr/opt/ora9/product/9.1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.0.1.0.0 - Production
System parameter file is /usr/opt/ora9/product/9.1/network/admin/listener.ora
Log messages written to /usr/opt/ora9/product/9.1/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use

Listener failed to start. See the error message(s) above...

Please help me out

Report message to a moderator

Re: Listener problem [message #177119 is a reply to message #177101]

Tue, 13 June 2006 02:39

aciolac
Messages: 242
Registered: February 2006

Senior Member

Possible that port, that must to listen your listener already are used. Use nmap to see if port is not used.

Report message to a moderator

Re: Listener problem [message #177120 is a reply to message #177119]

Tue, 13 June 2006 02:44

viv_pol
Messages: 14
Registered: June 2006
Location: INDIa

Junior Member

hi..
i used nmap command... following is the result:

[root@c-3176 root]# nmap 172.22.4.4(Linux Server)

Starting nmap V. 2.54BETA22 ( www.insecure.org/nmap/ )
Interesting ports on (172.22.4.4):
(The 1534 ports scanned but not shown below are in state: closed)
Port State Service
21/tcp open ftp
22/tcp open ssh
23/tcp open telnet
111/tcp open sunrpc
139/tcp open netbios-ssn
512/tcp open exec
1521/tcp open ncube-lm
6000/tcp open X11

Nmap run completed -- 1 IP address (1 host up) scanned in 0 seconds

Report message to a moderator

Re: Listener problem [message #177122 is a reply to message #177120]

Tue, 13 June 2006 02:48

aciolac
Messages: 242
Registered: February 2006

Senior Member

1521/tcp open ncube-lm - this is the problem. Port 1521 is default for Oracle listener. You must to change port number in file listener.ora(and also in file tnsnames.ora at client part) or to change port in program ncube-lm.

Report message to a moderator

Re: Listener problem [message #177124 is a reply to message #177122]

Tue, 13 June 2006 02:59

viv_pol
Messages: 14
Registered: June 2006
Location: INDIa

Junior Member

sorry sir, i could not get it.

How to change the port number?

Which alternative port number is to be given to service ncube-lm

Report message to a moderator

Re: Listener problem [message #177126 is a reply to message #177124]

Tue, 13 June 2006 03:04

aciolac
Messages: 242
Registered: February 2006

Senior Member

I don't know how to change port number for ncube-lm. To change port number for listener, see file listener.ora in the directory $ORACLE_HOME/network/admin. There are indicated port number. You must change them to any other, that yet not used. Don't forget to change also port number in file $ORACLE_HOME/network/admin/tnsnames.ora at the clinet part.

Report message to a moderator

Re: Listener problem [message #177127 is a reply to message #177126]

Tue, 13 June 2006 03:08

viv_pol
Messages: 14
Registered: June 2006
Location: INDIa

Junior Member

sir,
how to check indicated port number that ar not in use...

Report message to a moderator

Re: Listener problem [message #177130 is a reply to message #177127]

Tue, 13 June 2006 03:17

aciolac
Messages: 242
Registered: February 2006

Senior Member

All the ports not shown by nmap, are not used.

In your case you can use port 1522 for example.

Report message to a moderator

Re: Listener problem [message #177133 is a reply to message #177101]

Tue, 13 June 2006 03:52

viv_pol
Messages: 14
Registered: June 2006
Location: INDIa

Junior Member

sir, i've changed portnumber to 1522 in listener.ora

since i donot have installed client of oracle, i've changed tnsnames.ora at server side with port number to 1522

but it's again showing same error message(port already in use) when i try to start lsnrctl service

[Updated on: Tue, 13 June 2006 03:55]

Report message to a moderator

Re: Listener problem [message #177134 is a reply to message #177133]

Tue, 13 June 2006 03:54

aciolac
Messages: 242
Registered: February 2006

Senior Member

Post your listener.ora here.

Report message to a moderator

Re: Listener problem [message #177136 is a reply to message #177134]

Tue, 13 June 2006 03:58

viv_pol
Messages: 14
Registered: June 2006
Location: INDIa

Junior Member

my Listener.ora file contains:

# LISTENER.ORA Network Configuration File: /usr/opt/ora9/product/9.1/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 = 172.22.4.4)(PORT = 1522))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/opt/ora9/product/9.1)
(PROGRAM = extproc)
)

Report message to a moderator

Re: Listener problem [message #177152 is a reply to message #177136]

Tue, 13 June 2006 04:56

aciolac
Messages: 242
Registered: February 2006

Senior Member

Try at start this confoguration:
# LISTENER.ORA Network Configuration File: /usr/opt/ora9/product/9.1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.4.4)(PORT = 1522))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/opt/ora9/product/9.1)
(PROGRAM = extproc)
))

This will exclude listening for IPX protocol. Also I am added one bracket at the end of description for SID_LIST_LISTENER(number of opened brackets must be equal for number of closed brackets). Verify if there not started any listener(ps -ef| grep lsnr) and kill any of existing. After that start you listener explicitly:
LSNRCTL>start listener

Report message to a moderator

Re: Listener problem [message #177162 is a reply to message #177152]

Tue, 13 June 2006 05:40

viv_pol
Messages: 14
Registered: June 2006
Location: INDIa

Junior Member

Thanks.....
that problem has been solved. but now i'm facing another problem when i start up sqlplus. following error message appears:

[oracle@c-3176 oracle]$ sqlplus

SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jun 13 16:06:25 2006

(c) Copyright 2001 Oracle Corporation. All rights reserved.

Enter user-name: system as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORA-03113: end-of-file on communication channel

Report message to a moderator

Re: Listener problem [message #177165 is a reply to message #177162]

Tue, 13 June 2006 05:49

orausern
Messages: 826
Registered: December 2005

Senior Member

check the alert log file under bdump directory , if any more error messages are recorded there. post them here.

Report message to a moderator

Re: Listener problem [message #177170 is a reply to message #177165]

Tue, 13 June 2006 06:04

viv_pol
Messages: 14
Registered: June 2006
Location: INDIa

Junior Member

hi...
there are no error messages for today's date. Following is the content of alert log:

Fri Jun 2 16:04:26 2006
starting up 1 shared server(s) ...
RECO started with pid=7
Fri Jun 2 16:04:26 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Jun 2 16:04:27 2006
ALTER DATABASE MOUNT
Fri Jun 2 16:04:34 2006
Successful mount of redo thread 1, with mount id 4036159885.
Fri Jun 2 16:04:34 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Jun 2 16:04:34 2006
ALTER DATABASE OPEN
Fri Jun 2 16:04:37 2006
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: /usr/opt/ora9/oradata/erpdb/redo03.log
Successful open of redo thread 1.
Fri Jun 2 16:04:37 2006
SMON: enabling cache recovery
Fri Jun 2 16:04:40 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Fri Jun 2 16:04:41 2006
SMON: enabling tx recovery
Fri Jun 2 16:04:59 2006
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Fri Jun 2 16:06:43 2006
Restarting dead background process EMN0
EMN0 started with pid=13
Fri Jun 2 16:06:43 2006
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 1
Fri Jun 2 16:06:46 2006
ALTER DATABASE CLOSE NORMAL
Fri Jun 2 16:06:47 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Jun 2 16:06:47 2006
Thread 1 closed at log sequence 1
Fri Jun 2 16:06:47 2006
Completed: ALTER DATABASE CLOSE NORMAL
Fri Jun 2 16:06:47 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
Fri Jun 2 16:06:52 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 9.0.1.0.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 117440512
large_pool_size = 1048576
java_pool_size = 117440512
resource_manager_plan = SYSTEM_PLAN
control_files = /usr/opt/ora9/oradata/erpdb/control01.ctl, /usr/opt/ora9/oradata/erpdb/control02.ctl, /usr/opt/ora9/oradata/erpdb/control03.ctl
db_block_size = 8192
db_cache_size = 67108864
compatible = 9.0.0
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = ora9
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = /usr/opt/ora9/admin/erpdb/bdump
user_dump_dest = /usr/opt/ora9/admin/erpdb/udump
core_dump_dest = /usr/opt/ora9/admin/erpdb/cdump
sort_area_size = 524288
db_name = erpdb
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
Fri Jun 2 16:07:05 2006
starting up 1 shared server(s) ...
RECO started with pid=7
Fri Jun 2 16:07:05 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Jun 2 16:07:07 2006
ALTER DATABASE MOUNT
Fri Jun 2 16:07:13 2006
Successful mount of redo thread 1, with mount id 4036136236.
Fri Jun 2 16:07:13 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Jun 2 16:07:13 2006
ALTER DATABASE OPEN
Fri Jun 2 16:07:13 2006
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: /usr/opt/ora9/oradata/erpdb/redo03.log
Successful open of redo thread 1.
Fri Jun 2 16:07:13 2006
SMON: enabling cache recovery
Fri Jun 2 16:07:14 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Fri Jun 2 16:07:14 2006
SMON: enabling tx recovery
Fri Jun 2 16:07:24 2006
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Fri Jun 2 16:29:25 2006
/* OracleOEM */ ALTER DATABASE DATAFILE '/usr/opt/ora9/product/9.1/oradata/erpdb/system01.dbf' RESIZE 512M^@
Fri Jun 2 16:29:34 2006
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE '/usr/opt/
Fri Jun 2 16:32:40 2006
/* OracleOEM */ CREATE TABLESPACE "BAANDAT" LOGGING DATAFILE '/usr/opt/ora9/product/9.1/oradata/erpdb/BAANDAT.dbf' SIZE 2000M EXTENT MANAGEMENT LOCAL^@
Fri Jun 2 16:33:36 2006
Completed: /* OracleOEM */ CREATE TABLESPACE "BAANDAT" LOGGIN
Fri Jun 2 16:34:27 2006
/* OracleOEM */ CREATE TABLESPACE "BAANIDX" LOGGING DATAFILE '/usr/opt/ora9/product/9.1/oradata/erpdb/BAANIDX.dbf' SIZE 2000M EXTENT MANAGEMENT LOCAL^@
Fri Jun 2 16:35:28 2006
Completed: /* OracleOEM */ CREATE TABLESPACE "BAANIDX" LOGGIN
Mon Jun 12 15:43:36 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Listener address (ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)) not valid.
Mon Jun 12 15:50:15 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Listener address (ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)) not valid.
Mon Jun 12 15:51:18 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Listener address (ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)) not valid.
Mon Jun 12 15:54:04 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Listener address (ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)) not valid.
Mon Jun 12 15:57:41 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Listener address (ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)) not valid.

Report message to a moderator

Re: Listener problem [message #177171 is a reply to message #177170]

Tue, 13 June 2006 06:08

orausern
Messages: 826
Registered: December 2005

Senior Member

the message below means that the listener configuration is improper :

Code: [Select all] [Show/ hide]

Listener address (ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)) not valid.
--the host name is null whereas it should be the hostname of the server or the ip address

use oracle net configuration assistant to set up another listener with proper settings.

Report message to a moderator

Re: Listener problem [message #177176 is a reply to message #177171]

Tue, 13 June 2006 06:23

viv_pol
Messages: 14
Registered: June 2006
Location: INDIa

Junior Member

Actually i was getting another problem before this port 1521 was already in use. we changed it to 1522.in listener.ora file

Any how what are the steps to set up another listener

Report message to a moderator

Re: Listener problem [message #177194 is a reply to message #177176]

Tue, 13 June 2006 06:52

orausern
Messages: 826
Registered: December 2005

Senior Member

so here it is clear that the change in port number that u made has not taken its effect...becoz u say that u changed the port to 1522 whereas in the alert log the error recorded is for port 1521.

also the other thing is that, the error has to do with the entry related to host- it has an empty string like (host=) which is invalid. so the recorded error has to do with host and not with port.

before reconfiguring the listener, can you post what is the ip address of the server? and what is the hostname?

Report message to a moderator

Re: Listener problem [message #177199 is a reply to message #177176]

Tue, 13 June 2006 07:03

viv_pol
Messages: 14
Registered: June 2006
Location: INDIa

Junior Member

sir,
that error was of yesterday. any how my linux server where oracle server is also residing has ipaddr:172.22.4.4 and hostname is c-3176

also, i've tried to add another listener through configuration assistant, but it's not creating.

Report message to a moderator

Re: Listener problem [message #177207 is a reply to message #177199]

Tue, 13 June 2006 07:30

orausern
Messages: 826
Registered: December 2005

Senior Member

to add another listener:

on linux server, go to <oracle_home>/bin directory and type

#./netca

this will bring up net config. assistant. (assuming that graphical environment is set up )

then choose the tab "Listener Configuration" , then "add" then listener_a (or other such name) , then protocol "tcp" then port number (give 1523 or 1524 ) and click finish..

save the changes and then
try to start the listener by going to lsnrctl and start listener_a and post the output..

Report message to a moderator

Previous Topic:	Connecting Oracle with MS-Access with instant client packages
Next Topic:	tnsping --TNS-12541: TNS:no listener

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 00:58:09 CDT 2025