12 Replies Latest reply: Nov 16, 2012 8:59 AM by Osama_Mustafa RSS

    Configuring Listener with other name

    j_DBA_sourav
      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