Printable View
Hi
We have a sun solaris server with 2 instances of Oracle 8.0.5 installed.One Oracle 8 listner is running for both the instances.
Now we have installed Oracle 9i on the same server.we have configured the listener for oracle8 (old one) to listen to the 9i database also.
What i am interested is is there a way to run both the Oracle 8 and Oracle 9i listeners together on the same machine?
Thanks
Sam
Yes, you can. Is it the same OS user who owns the 8 and 9i binaries? Remember to satrt the listener under the 8 binaries!Quote:
Originally posted by samx18
Hi
We have a sun solaris server with 2 instances of Oracle 8.0.5 installed.One Oracle 8 listner is running for both the instances.
Now we have installed Oracle 9i on the same server.we have configured the listener for oracle8 (old one) to listen to the 9i database also.
What i am interested is is there a way to run both the Oracle 8 and Oracle 9i listeners together on the same machine?
Thanks
Sam
The Oracle OS users are different for Oracle 8 and Oracle 9i
When we try to start the Oracle 9i listner it gives a message of address already in use.
Sam :confused:
Use another port for your 9i listener.
Have already tried changing the port numbers but it dosent seem to work.
Sam
Look at my sample:
[oracle@ish2 oracle]$ lsnrctl start
LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 22-FEB-2003 19:51:10
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Starting /home/oracle/product/8.1.7/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 8.1.7.0.0 - Production
System parameter file is /home/oracle/product/8.1.7/network/admin/listener.ora
Log messages written to /home/oracle/product/8.1.7/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ish2.eachnet.com)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ish2)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 8.1.7.0.0 - Production
Start Date 22-FEB-2003 19:51:10
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP ON
Listener Parameter File /home/oracle/product/8.1.7/network/admin/listener.ora
Listener Log File /home/oracle/product/8.1.7/network/log/listener.log
Services Summary...
archdb has 1 service handler(s)
catalog has 1 service handler(s)
ora9 has 1 service handler(s)
The command completed successfully
[oracle@ish2 oracle]$ . ora9.env
[oracle@ish2 oracle]$ lsnrctl start ora9standby
LSNRCTL for Linux: Version 9.2.0.1.0 - Production on 22-FEB-2003 19:51:49
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /oradata/9.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.1.0 - Production
System parameter file is /oradata/9.2.0/network/admin/listener.ora
Log messages written to /oradata/9.2.0/network/log/ora9standby.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ish2.eachnet.com)(PORT=1522)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ish2)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias ora9standby
Version TNSLSNR for Linux: Version 9.2.0.1.0 - Production
Start Date 22-FEB-2003 19:51:49
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oradata/9.2.0/network/admin/listener.ora
Listener Log File /oradata/9.2.0/network/log/ora9standby.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ish2.eachnet.com)(PORT=1522)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ora9" has 1 instance(s).
Instance "ora9", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
my ora9 listener.ora file:
SID_LIST_ora9standby =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oradata/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ora9)
(ORACLE_HOME = /oradata/9.2.0)
(SID_NAME = ora9)
)
)
ora9standby =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ish2)(PORT = 1522))
)
)
)
my ora8 listener.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ish2)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ora9)
(ORACLE_HOME = /oradata/9.2.0)
)
(SID_DESC =
(GLOBAL_DBNAME = catalog.eachnet.com)
(ORACLE_HOME = /home/oracle/product/8.1.7)
(SID_NAME = catalog)
)
(SID_DESC =
(GLOBAL_DBNAME = archdb.eachnet.com)
(ORACLE_HOME = /home/oracle/product/8.1.7)
(SID_NAME = archdb)
)
)
and also change the listener name....Quote:
Originally posted by chao_ping
Use another port for your 9i listener.
the way chao_ping has shown above.