TSIM upgrade from 10.0.500 to 10.5 failed with error "Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor"

Version 1
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    TrueSight Infrastructure Management


    COMPONENT:

    TrueSight Operations Management


    APPLIES TO:

    TrueSight Infrastructure Management



    PROBLEM:

    TSIM upgrade from 10.0.500 to 10.5 failed with error:

      "Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor" 

     


    CAUSE:

    This error occurs when the ORACLE_SID does not match the Service Name supplied


    SOLUTION:

    This is an undocumented requirement and Defect TOM-27736 has been raised for this.

    In order to complete the installation, the Oracle DBA needs to set the ORACLE_SID= service name.

    The steps should be:
     
    1. alter system set service_names='..., {new_service_name}' scope=both;
    2. Add (GLOBAL_DBNAME={new_service_name}) to listener configuration (listener.ora)
    SID_LIST_LISTENER = ( SID_LIST= (SID_DESC = (ORACLE_HOME =...) (SID_NAME = ...)) ....
    i.e. include:
    (SID_DESC =
    (GLOBAL_DBNAME={new_service_name})
    (SID_NAME = {oracle_sid})
    (ORACLE_HOME ={oracle_home}))
    )
    3.  Restart listener.
    4. And try below
    sqlplus  system/bmcAdm1n@"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(host=<hostname>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=new_service_name)))"
    5.  As long as the connect is successful then try the upgrade again


    Article Number:

    000124646


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles