Common Oracle errors in TSCO: how detect and debug

Version 1
    Share This:

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


    PRODUCT:

    TrueSight Capacity Optimization


    COMPONENT:

    Capacity Optimization


    APPLIES TO:

    TrueSight Capacity Optimization all versions



    PROBLEM:

    When trying to log into the TrueSight Capacity Optimization (TSCO) console an error was generated and, looking at the log, an Oracle error ORA-XXXX is being reported in the logs.


    SOLUTION:

     

    In order to verify if it is really an Oracle error you can check TrueSight Capacity Optimization (TSCO) database functionality in one of the following ways:

    From CO 10.5: use Database Credentials Tool
    Search in the official documentation about Validating database connection page.

    All Version: how check DB connectivity for long time
    If you have random problem in DB connection and want investigate on it, you can use the tool suggested here
    https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=000031771

    All Version: use command line (TNSPING and SQL Plus)

    Access via ssh to the Application Server, then:  
       
    1. Verify Tnsping
      . /opt/cpit/env.sh
      tnsping $ORACLE_SID
    2.  
    3. Test DB name resolution from AS (to see oracle server hostname execute cat /opt/cpit/env.sh | grep ORACLE_SERVER)
      nslookup $ORACLE_SERVER
    4.  
    5. Test DB ping from AS (see ip from nslookup)
      ping DB_IP
    6.  
    7. Test connection from AS using SQL Plus
      . /opt/cpit/env.sh
      sqlplus $DBUSR/INSERTHEREYOURDBPASSWORD@$ORACLE_SID
    If one of the tests above fails:  
       
    • verify your DB is up and the network functionality
    •  
    • verify your $CPITBASE/env.sh contains the right DB hostname, then check the DNS name resolution on the As and network functionality
    •  
    • verify your $TNS_ADMIN/tnsnames.ora file to be coherent with your $CPITBASE/env.sh
    •  
    • check the correctness of the parameters you inserted during setup: $DBUSR, $ORACLE_SID
    •  
    • check you inserted the right credentials (user/pass) for CO DB
      

    Common Oracle Errors that trigger the BCO web UI to be unavailable

                                                                                                                                                                                                                                                                                                                                                                                                    
    Error messageMeaningCheck and repair strategies
    ORA-12505:  TNS:listener does not currently know of SID given in connect descriptor
    ORA-12541: TNS:no listener
    ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
     
    TSCO cannot connect to the database due to network issues or misconfiguration (client or server side).Verify the tnsnames.ora file
    Verify the SID and/or the service name
    Ask to DBA to check if listener is running
    Verify if the Database instance is up and running
    ORA-12519: TNS: no appropriate service handler found
    ORA-12516: TNS: listener could not find available handler with matching protocol stack
    Problem in configuration in limits on sessions/processes DB sideHow to fix errors ORA-12516 and ORA-12519
    ORA-00018: maximum number of sessions exceededThe Oracle server is configured to support a limited number of direct sessions, defined in the Oracle configuration parameter sessions.Verify the configuration of connection pools and check ETL parallelism.
    If none of the above can be safely reduced, ask the DBA team to increase the sessions parameter; this action requires a restart of the Oracle instance
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    ORA-01033: ORACLE initialization or shutdown in progress
    The database instance is down.Contact the DBA team and verify if this might be due to a scheduled activity, such as a planned shutdown.
    ORA-03114: not connected to ORACLEThe DB is not reachable: or is down or there is a network issueContact DBA and network team to restore connectivity between TSCO servers and DB server
    ORA-00257: archiver error. Connect internal only, until freed.The database instance has saturated the configured archive space.Contact the DBA team and ask to perform an archive of redo log and check rman backup scheduling. Investigate extraordinary activities such as historical imports. The error could also happen if there is not enough space on the file system to write new or enhance the existing Archive logs.
    ORA-01017: invalid username/password; logon deniedWrong username or passwordAsk to DBA the right credentials.
    Check TSCO configuration.
    ORA-28000: the account is lockedThe account is locked.Ask to DBA to unlock the account.
    Verify if the DBA changed the password and if a TSCO reconfiguration is needed
    ORA-28001: the password has expiredThe user's account has expired and the password needs to be changedChange the password (TSCO reconfiguration) or contact the DBA
    ORA-28002 The Password Will Expire in x Days

    ORA-28011: The account will expire soon; Change your password

    The password for the account or the account is going to expire.
    Please contact DBA to fix it
    ORA-01688: unable to extend table XXXXOne (or more) of the tablespace is saturatedWorks with DBA in order to fix the space allocated for the tablespace.
    ORA-12170: “TNS: Connect Timeout Occurred” The error can be for many reasons, firewall issue, database down, listener down, bad sqlnet.ora parm, network troubleWork with DBA or Network Admin to understand what causes the problem in communication between TSCO and Database.
    ORA-04031 unable to allocate XXX bytes of shared memory There is an issue in memory allocation on the DB serverLook to the official documentation at the page Database requirements. In detail, in Oracle section, there is a set of parameters: verify with DBA if the ones under Memory Management are set as per recomendation 
    ORA-16000: database or pluggable database open for read-only accessThis error is generated when the database has been opened for read-only access. Attempts to modify the database generates this error.Work with DBA to shutdown and re-open the database for read-write access.
    ORA-03179: NOCACHE or ORDER sequences cannot be accessed from Active Data Guard standbyNOCACHE or ORDER sequences were not supported for Active Data Guard standby.Work with DBA to fix the issue 
      

    If DBA changed the password, you need to reconfigure CO (How do I reconfigure CO version 9.x and 10.x to change the BCO database user passwords or update the database instance configuration information?)

    Once an Oracle error has been identified and addressed, it is typically best to stop and restart TSCO in the environment to allow it to reinitialize against a clean database.

     


    Article Number:

    000096715


    Article Type:

    Solutions to a Product Problem



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