This discussion is archived
12 Replies Latest reply: Nov 16, 2012 8:59 AM by Osama_Mustafa RSS

Configuring Listener with other name

j_DBA_sourav Newbie
Currently Being Moderated
Hello Friends,

I am trying to configure a listener which will run at any port ( could be 1521 also) but with a name other than default ( LISTENER). The database is in 11gR2. I have created listener.ora file and modified the init.ora file with LOCAL_LISTENER=MYLISTENER. Whenever I am trying to connect to the database by TCP It is giving me error ORA-12514:..

Also when I am trying to boot my database with pfile It is giving me following error :

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'MYLISTENER'

Then Listener.ora file is like below:

MYLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = TESTDB)
(ORACLE_HOME = /u01/oracle/oraapp)
)
)
ADR_BASE_LISTENER = /u01/oracle


TNSNAMES.ora file is like below:


$ cat /u01/oracle/oraapp/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/oracle/oraapp/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
TESTDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTDB)
)
)


Please help me with proper solution.

-Regards,
Saha

Edited by: j_DBA_saha on Nov 16, 2012 7:58 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points