Listener ( lsnrctl ) - stop and start just one instance
658204Sep 5 2008 — edited Sep 9 2008Hey 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