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 on non-default port

550749Dec 30 2007 — edited Jan 2 2008
Hello,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 30 2008
Added on Dec 30 2007
11 comments
1,222 views