xoxomos
asked on
Listener Problem
I've recently installed 11.2 on a xp machine where 10.2 is already installed. The installed failed at the net configuration step. When I tried running netca separately I get a message saying port 1521 is already in use. I try 1522, 1523, and 1524 and xp says they are all in use.
How do i get a 10.2 and a 11.2 version working on the same machine?? The 10.2 is on C: and the 11.2 is on the F: drive.
How do i get a 10.2 and a 11.2 version working on the same machine?? The 10.2 is on C: and the 11.2 is on the F: drive.
Did you given the database name same for both 10.2 and 11.2 ?
you don't need two listener to use with two database, actually one listner is enough. use net manager to add the new service in the higher version of listener.
ASKER
When I go into net configuration assistant, it gives me the option to add only. Delete is grayed out so it sees no listener. If I go to add a listener it gets to the port selection part then tells me to 'use another port number:
Port 1521 provided for this listener is currently in use. You can proceed with the configuration as it is, but it will not be possible to start this listener until the conflict is resolved....'
Port 1521 provided for this listener is currently in use. You can proceed with the configuration as it is, but it will not be possible to start this listener until the conflict is resolved....'
ASKER
The same for 1522, 1523 and 1524 ??
ASKER
Net manager shows no listeners also. There is a service naming with the name of the 11g instance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
To the best of my knowledge, I have no listener at all now.
F:\u01\app\oracle\product\ 11.2.0\db_ 1\BIN>lsnr ctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 31-AUG-2010 12:19
:03
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HO ST=)(PORT= 1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
If I go through netca, i will get the message
"Port 1521 provided for this listener is currently in use. You can proceed with ......'
I'll now try manually just making a listener.ora and see what happens.
F:\u01\app\oracle\product\
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 31-AUG-2010 12:19
:03
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HO
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
If I go through netca, i will get the message
"Port 1521 provided for this listener is currently in use. You can proceed with ......'
I'll now try manually just making a listener.ora and see what happens.
ASKER
Before that, i will try starting what is not there though
F:\u01\app\oracle\product\ 11.2.0\db_ 1\BIN>lsnr ctl start
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 31-AUG-2010 12:25
:36
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting tnslsnr: please wait...
TNS-12560: TNS:protocol adapter error
F:\u01\app\oracle\product\ 11.2.0\db_ 1\BIN>
F:\u01\app\oracle\product\
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 31-AUG-2010 12:25
:36
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting tnslsnr: please wait...
TNS-12560: TNS:protocol adapter error
F:\u01\app\oracle\product\
I see you have following line in the lsnrctl status:
Connecting to (ADDRESS=(PROTOCOL=tcp)(HO ST=)(PORT= 1521))
Why the host name is not getting printed, can you post the contents of you listner.ora file?
Connecting to (ADDRESS=(PROTOCOL=tcp)(HO
Why the host name is not getting printed, can you post the contents of you listner.ora file?
ASKER
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Amun)
(ORACLE_HOME = C:\oracle\product\10.2.0\d b_1)
(SID_NAME = Amun)
)
(SID_DESC =
(GLOBAL_DBNAME = Amen)
(ORACLE_HOME = F:\u01\app\oracle\product\ 11.2.0\db_ 1)
(SID_NAME = Amen)
)
)
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Amun)
(ORACLE_HOME = C:\oracle\product\10.2.0\d
(SID_NAME = Amun)
)
(SID_DESC =
(GLOBAL_DBNAME = Amen)
(ORACLE_HOME = F:\u01\app\oracle\product\
(SID_NAME = Amen)
)
)
ASKER
C:\Documents and Settings\zozimos>telnet Amen:1521
Connecting To Amen:1521...Could not open connection to the host, on port 23: Con
nect failed
ASKER
Thanks. This:
....
(SID_DESC =
(GLOBAL_DBNAME = ORCL10G)
(ORACLE_HOME = D:\oracle\product\10.2.0\d b_1)
(SID_NAME = ORCL10G)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL11G)
(ORACLE_HOME = D:\app\product\11.2.0\dbho me_1)
(SID_NAME = ORCL11G)
)
)
....
refreshed my aged memory on how to set up the single listener for two different versions, plus i needed to put another tab or something into my windows\system32\etc\hosts file
....
(SID_DESC =
(GLOBAL_DBNAME = ORCL10G)
(ORACLE_HOME = D:\oracle\product\10.2.0\d
(SID_NAME = ORCL10G)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL11G)
(ORACLE_HOME = D:\app\product\11.2.0\dbho
(SID_NAME = ORCL11G)
)
)
....
refreshed my aged memory on how to set up the single listener for two different versions, plus i needed to put another tab or something into my windows\system32\etc\hosts