Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Listener ( lsnrctl ) - stop and start just one instance

658204Sep 5 2008 — edited Sep 9 2008
Hey all. I hava a Oracle 9.2 installed over a Linux Red Hat 4.0 64 bits server.
Some Virtual Machines will connect in some databases installed in my Oracle server. My listener has one instance for each database like this:


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = VM01)
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(SID_NAME = VM01)
)
(SID_DESC =
(GLOBAL_DBNAME = VM02)
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(SID_NAME = VM02)
)
(SID_DESC =
(GLOBAL_DBNAME = VM03)
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(SID_NAME = VM03)


LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = VM01))
(ADDRESS = (PROTOCOL = IPC)(KEY = VM02))
(ADDRESS = (PROTOCOL = IPC)(KEY = VM03))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lab2)(PORT = 1521))
)
)
)





And my tnsnames:


VM03 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lab2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = VM03)
)
)

VM02 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lab2)(PORT = 1521))
)
(CONNECT_DATA =
(SID = VM02)
)
)

VM01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lab2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = VM01)
)
)


I need to start and stop just one instance (VM01 or VM02 or VM03). I really can't stop all instances when I need to stop just one. And more if i have to create another instance i will have to stop the listener... and i can't because other people are using your instance...

Do you know how to help me?


Thanksssssss
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2008
Added on Sep 5 2008
11 comments
5,819 views