Listener on non-default port
550749Dec 30 2007 — edited Jan 2 2008Hello,
I'm learning about listeners and I have problem doing such thing:
I wanna the default listener (LISTENER) listen on a port different from 1521. I chose 1522.
I have Oracle 10g Release2 running on WindowsXP.
I changed the listening port using netmgr.
Then I checked listener.ora file. It looked like this:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
)
)
Then I changed an entry in tnsnames.ora into:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Then I restarted Windows. All of the services have started and are running.
CMD>'lsnrctl status' said that LISTENER is listening on port 1522. And I can connect to the database using sqlplus.
But Enterprise Manager Database Console says everything is down (agent, database, listener). I can't use iSQLPlus either (can't connect to the orcl).
I can't use Enterprise Manager Console either. I have Oracle 10g client installed on the same machine and its tnsnames.ora is also changed (orcl on port 1522).
What is wrong? What should I do to repair it?
Thanks in advance.
Aliq.