This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
TrueSight Capacity Optimization
TrueSight Capacity Optimization all versions
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.
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 How can I validate that the BCO Oracle Java Database Connection String URL (JDBC) that I'm using is valid for my environment?
All Version: use command line (TNSPING and SQL Plus)
- Verify Tnsping
- Test DB name resolution from AS (to see oracle server hostname execute cat /opt/cpit/env.sh | grep ORACLE_SERVER)
- Test DB ping from AS (see ip from nslookup)
- Test connection from AS using SQL Plus
- 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 message||Meaning||Check and repair strategies|
ORA-12541: TNS:no listener
|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
|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 side||How to fix errors ORA-12516 and ORA-12519|
|ORA-00018: maximum number of sessions exceeded||The 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-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.|
|Wrong username or password||Ask to DBA the right credentials.|
Check TSCO configuration.
|ORA-28000: the account is locked||The 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 expired||The user's account has expired and the password needs to be changed||Change the password (TSCO reconfiguration) or contact the DBA|
|ORA-01688: unable to extend table XXXX||One (or more) of the tablespace is saturated||Works with DBA in order to fix the space allocated for the tablespace.|
|ORA-12170: “TNS: Connect Timeout Occurred”||error can be for many reasons, firewall issue, database down, listener down, bad sqlnet.ora parm, network trouble||Work 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 server||Look 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 reccomentation|
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.