Forum Stats

  • 3,873,307 Users
  • 2,266,532 Discussions
  • 7,911,501 Comments

Discussions

not able to set tns and listner for cloning in aux database

Chetan Yadav
Chetan Yadav Member Posts: 168 Bronze Badge

hi Guru's not able to set the listner or tns in my target db .

[[email protected] ~]$ lsnrctl start LISTENER_MPSIT


LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 13-JUL-2021 22:04:07


Copyright (c) 1991, 2014, Oracle. All rights reserved.


Starting /sproddb/SIT12C/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...


TNSLSNR for Linux: Version 12.1.0.2.0 - Production

System parameter file is /sproddb/SIT12C/product/12.1.0/dbhome_1/network/admin/MPSIT1_ebssitdb1/listener.ora

Log messages written to /sproddb/SIT12C/diag/tnslsnr/ebssitdb1/listener_mpsit/alert/log.xml

TNS-01151: Missing listener name, LISTENER_MPSIT, in LISTENER.ORA


Listener failed to start. See the error message(s) above...

Tagged:

Answers

  • Chetan Yadav
    Chetan Yadav Member Posts: 168 Bronze Badge

    my listner

    MPSIT=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=MPSIT)))) # line added by Agent

    # $Header: adlsnr10RAC.ora 120.3.12010000.2 2009/09/03 16:51:27 schagant ship $

    #

    # ###############################################################

    # This file is automatically generated by AutoConfig. It will be read and

    # overwritten. If you were instructed to edit this file, or if you are not

    # able to use the settings created by AutoConfig, refer to Metalink Note

    # 387859.1 for assistance.

    # ###############################################################


    #


    #

    # Definition for RAC Database listener

    #


    LISTENER_ebssitdb1 =

     (DESCRIPTION_LIST =

      (DESCRIPTION =

       (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = ebssitdb1-vip.mpezerp.com)(PORT = 1531)(IP = FIRST)))

       (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = ebssitdb1)(PORT = 1531)(IP = FIRST)))

      )

     )


    SID_LIST_LISTENER_ebssitdb1 =

     (SID_LIST =

      (SID_DESC = (ORACLE_HOME = /sproddb/SIT12C/product/12.1.0/dbhome_1)(SID_NAME = MPSIT1))

     )


    LISTENER_MPSIT =

    (DESCRIPTION_LIST =

    (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = ebssitdb1-vip.mpezerp.com)(PORT = 1538))

    ))



    SID_LIST_LISTENER_MPSIT =

    (SID_LIST =

    (SID_DESC =

    (GLOBAL_DBNAME = MPSIT )

    (ORACLE_HOME = /sproddb/SIT12C/product/12.1.0/dbhome_1)

    (SID_NAME = MPSIT )

    ))



    STARTUP_WAIT_TIME_LISTENER_ebssitdb1 = 0

    CONNECT_TIMEOUT_LISTENER_ebssitdb1 = 10

    TRACE_LEVEL_LISTENER_ebssitdb1 = OFF


    LOG_DIRECTORY_LISTENER_ebssitdb1 = /sproddb/SIT12C/product/12.1.0/dbhome_1/network/admin

    LOG_FILE_LISTENER_ebssitdb1 = MPSIT1

    TRACE_DIRECTORY_LISTENER_ebssitdb1 = /sproddb/SIT12C/product/12.1.0/dbhome_1/network/admin

    TRACE_FILE_LISTENER_ebssitdb1 = MPSIT1

    ADMIN_RESTRICTIONS_LISTENER_ebssitdb1 = ON

    SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER_ebssitdb1 = OFF



    IFILE=/sproddb/SIT12C/product/12.1.0/dbhome_1/network/admin/MPSIT1_ebssitdb1/listener_ifile.ora

    ENABLE_GLOBAL_DYNAMIC_ENDPOINT_MPSIT=ON # line added by Agent

    VALID_NODE_CHECKING_REGISTRATION_MPSIT=SUBNET # line added by Agent

    ----------------------------------------------------------------------------------------------------------------

    ----------------------------------------------------------------------------------------------------------------------


    and my TNs

    MPSIT=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=MPSIT)))) # line added by Agent

    # $Header: adlsnr10RAC.ora 120.3.12010000.2 2009/09/03 16:51:27 schagant ship $

    #

    # ###############################################################

    # This file is automatically generated by AutoConfig. It will be read and

    # overwritten. If you were instructed to edit this file, or if you are not

    # able to use the settings created by AutoConfig, refer to Metalink Note

    # 387859.1 for assistance.

    # ###############################################################


    #


    #

    # Definition for RAC Database listener

    #


    LISTENER_ebssitdb1 =

     (DESCRIPTION_LIST =

      (DESCRIPTION =

       (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = ebssitdb1-vip.mpezerp.com)(PORT = 1531)(IP = FIRST)))

       (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = ebssitdb1)(PORT = 1531)(IP = FIRST)))

      )

     )


    SID_LIST_LISTENER_ebssitdb1 =

     (SID_LIST =

      (SID_DESC = (ORACLE_HOME = /sproddb/SIT12C/product/12.1.0/dbhome_1)(SID_NAME = MPSIT1))

     )


    LISTENER_MPSIT =

    (DESCRIPTION_LIST =

    (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = ebssitdb1-vip.mpezerp.com)(PORT = 1538))

    ))



    SID_LIST_LISTENER_MPSIT =

    (SID_LIST =

    (SID_DESC =

    (GLOBAL_DBNAME = MPSIT )

    (ORACLE_HOME = /sproddb/SIT12C/product/12.1.0/dbhome_1)

    (SID_NAME = MPSIT )

    ))



    STARTUP_WAIT_TIME_LISTENER_ebssitdb1 = 0

    CONNECT_TIMEOUT_LISTENER_ebssitdb1 = 10

    TRACE_LEVEL_LISTENER_ebssitdb1 = OFF


    LOG_DIRECTORY_LISTENER_ebssitdb1 = /sproddb/SIT12C/product/12.1.0/dbhome_1/network/admin

    LOG_FILE_LISTENER_ebssitdb1 = MPSIT1

    TRACE_DIRECTORY_LISTENER_ebssitdb1 = /sproddb/SIT12C/product/12.1.0/dbhome_1/network/admin

    TRACE_FILE_LISTENER_ebssitdb1 = MPSIT1

    ADMIN_RESTRICTIONS_LISTENER_ebssitdb1 = ON

    SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER_ebssitdb1 = OFF



    IFILE=/sproddb/SIT12C/product/12.1.0/dbhome_1/network/admin/MPSIT1_ebssitdb1/listener_ifile.ora

    ENABLE_GLOBAL_DYNAMIC_ENDPOINT_MPSIT=ON # line added by Agent

    VALID_NODE_CHECKING_REGISTRATION_MPSIT=SUBNET # line added by Agent

    ----------------------------------------------------------------------

    -------------------------------------------------------------------------

  • Chetan Yadav
    Chetan Yadav Member Posts: 168 Bronze Badge

    [[email protected] bin]$ lsnrctl start


    LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 13-JUL-2021 23:00:07


    Copyright (c) 1991, 2014, Oracle. All rights reserved.


    Starting /sproddb/SIT12C/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...


    TNSLSNR for Linux: Version 12.1.0.2.0 - Production

    System parameter file is /sproddb/SIT12C/product/12.1.0/dbhome_1/network/admin/MPSIT1_ebssitdb1/listener.ora

    Log messages written to /sproddb/SIT12C/diag/tnslsnr/ebssitdb1/listener/alert/log.xml

    Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

    TNS-12542: TNS:address already in use

     TNS-12560: TNS:protocol adapter error

     TNS-00512: Address already in use

      Linux Error: 98: Address already in use