Dev's Weblog

Reading time: 2 - 4 minutes

[oracle@quartz admin]$ vi listener.ora

LISTENER01 =
A (DESCRIPTION_LIST =
AAA (DESCRIPTION =
AAAAA (ADDRESS = (PROTOCOL = TCP)(HOST = quartz)(PORT = 1521))
AAA )
A )

SID_LIST_LISTENER01 =
A (SID_LIST =
AAA (SID_DESC =
AAAAA (SID_NAME = dev)
AAAAA (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
AAA )
A )

LISTENER02 =
A (DESCRIPTION_LIST =
AAA (DESCRIPTION =
AAAAA (ADDRESS = (PROTOCOL = TCP)(HOST = quartz)(PORT = 1522))
AAA )
A )

SID_LIST_LISTENER02 =
A (SID_LIST =
AAA (SID_DESC =
AAAAA (SID_NAME = stan)
AAAAA (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_2)
AAA )
A )

[oracle@quartz admin]$ lsnrctl start LISTENER01

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-OCT-2008 11:55:22

Copyright (c) 1991, 2005, Oracle.A All rights reserved.

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener01.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=quartz)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=quartz)(PORT=1521)))
STATUS of the LISTENER
------------------------
AliasAAAAAAAAAAAAAAAAAAAA LISTENER01
VersionAAAAAAAAAAAAAAAAAA TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start DateAAAAAAAAAAAAAAA 13-OCT-2008 11:55:22
UptimeAAAAAAAAAAAAAAAAAAA 0 days 0 hr. 0 min. 3 sec
Trace LevelAAAAAAAAAAAAAA off
SecurityAAAAAAAAAAAAAAAAA ON: Local OS Authentication
SNMPAAAAAAAAAAAAAAAAAAAAA OFF
Listener Parameter FileAA /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log FileAAAAAAAA /u01/app/oracle/product/10.2.0/db_1/network/log/listener01.log
Listening Endpoints Summary...
A (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=quartz)(PORT=1521)))
Services Summary...
Service "dev" has 1 instance(s).
A Instance "dev", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

[oracle@quartz admin]$ ps -ef | grep -i liste
oracleAA 22182AAAA 1A 0 11:55 ?AAAAAAA 00:00:00 /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER01 -inherit
oracleAA 22190 20035A 0 11:55 pts/0AAA 00:00:00 grep -i liste

[oracle@quartz admin]$ lsnrctl start LISTENER02

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-OCT-2008 11:55:33

Copyright (c) 1991, 2005, Oracle.A All rights reserved.

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener02.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=quartz)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=quartz)(PORT=1522)))
STATUS of the LISTENER
------------------------
AliasAAAAAAAAAAAAAAAAAAAA LISTENER02
VersionAAAAAAAAAAAAAAAAAA TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start DateAAAAAAAAAAAAAAA 13-OCT-2008 11:55:33
UptimeAAAAAAAAAAAAAAAAAAA 0 days 0 hr. 0 min. 3 sec
Trace LevelAAAAAAAAAAAAAA off
SecurityAAAAAAAAAAAAAAAAA ON: Local OS Authentication
SNMPAAAAAAAAAAAAAAAAAAAAA OFF
Listener Parameter FileAA /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log FileAAAAAAAA /u01/app/oracle/product/10.2.0/db_1/network/log/listener02.log
Listening Endpoints Summary...
A (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=quartz)(PORT=1522)))
Services Summary...
Service "stan" has 1 instance(s).
A Instance "stan", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

[oracle@quartz admin]$ ps -ef | grep -i liste
oracleAA 22182AAAA 1A 0 11:55 ?AAAAAAA 00:00:00 /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER01 -inherit
oracleAA 22193AAAA 1A 0 11:55 ?AAAAAAA 00:00:00 /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER02 -inherit
oracleAA 22197 20035A 0 11:55 pts/0AAA 00:00:00 grep -i liste