| query regading listener.ora file [message #274066] |
Sat, 13 October 2007 05:51  |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
I have created oracle 10g Release 1 database(orcl) in Windows Xp Professional edition through DBCA . I also created one more database(sample) manually .
The ORCL server process listens to port no 1522 and
SAMPLE server process listens to port no 1521
Once I start the OracleServiceORCL (Service for orcl) from services.exe and check the listener status it displays
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
But when I start OracleServiceSAMPLE (Service for sample) from services.exe and check the listener status there is no change . Only when i start the instance the dynamic registration takes place with port no 1521 .
There is no entry for listener parameter in init.ora file . My question is how is the service ORCL able to get itself registered with the listener even before the instance is up ?
The listener file looks like this
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_2)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = irobo)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = irobo)(PORT = 1522))
)
)
The tnsnames file has the following entry
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = irobo)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
SAMPLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = irobo)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
|
|
|
|
|
|
| Re: query regading listener.ora file [message #274070 is a reply to message #274066] |
Sat, 13 October 2007 06:13  |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
Sorry for that
Listener.ora file
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_2)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = irobo)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = irobo)(PORT = 1522))
)
)
Tnsnames.ora file
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = irobo)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
SAMPLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = irobo)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
|
|
|
|
|
|
| Re: query regading listener.ora file [message #274104 is a reply to message #274066] |
Sat, 13 October 2007 20:04 |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
Sorry for that ... actually it is SAMPLE
But still whenever I start the OracleServiceORCL service (not the instance) and check status of listener through lsnrctl I see that
Service "orcl" has 1 instance(s)
Instance "orcl", status READY, has 1 handler(s) for this service
How does this happen ? How is the service able to register itself with the listener even before the instance is up ?
|
|
|
|
|
|
| Re: query regading listener.ora file [message #274108 is a reply to message #274106] |
Sat, 13 October 2007 20:43 |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
So do you mean that this registration happens even before startup ?
I changed tnsnames.ora file such that port number of ORCL is 1521
and port number of SAMPLE is 1522 . For both instances I have not set the LOCAL_LISTENER initialization parameter.
However, when I start the instance and check the listener it displays
Service "sample" has 1 instance(s).
Instance "sample", status READY, has 1 handler(s) for this service...
How is sample instance able to dynamically register to the listener since the port number used in tnsnames is not he default one ?
|
|
|
|
|
|
| Re: query regarding listener.ora file [message #274110 is a reply to message #274066] |
Sat, 13 October 2007 21:38 |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
Sorry I still have a doubt regarding the listener.ora file
Consider if we have only one port number specified in listener.ora file , can both the databases share the same port since I changed the listener.ora specifying only one entry with port number 1521 .
When I tried connecting to both the databases it was working fine .
When i checked netstat earlier when there were two port numbers specified in the listener.ora file , only one port number 1521 was used . Does this mean the same port number is shared by both server process?
|
|
|
|
|
|
| Re: query regading listener.ora file [message #274112 is a reply to message #274066] |
Sat, 13 October 2007 22:23 |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
I am working in Windows XP
When I start the service(OracleSericeORCL) using services.msc even though the instance is not started the instance is registered with listener . Here the instance is not up but still its getting registered.
When I start the service(OracleSericeSAMPLE) using services.msc the instance is not getting registered with listener unless i start up the instance using startup command .
Why is that so ?
The only difference is I created ORCL through DBCA and I created SAMPLE manually
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
