| 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
|
|
|
|
|
|
| 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
|
|
|
|
| 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.
|
|
|
|
| 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
|
|
|
|
| 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.
|
|
|
|
|
|
|
|
| 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 #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)
)
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
|
|
| 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.
|
|
|
|
| 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 :
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.
|
|
|
|
| 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
|
|
|
|
| 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?
|
|
|
|
| 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.
|
|
|
|
| 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..
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
