Configuring Listener with other name
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