In TSCO, How to fix errors ORA-12516 and ORA-12519

Version 8
    Share This:

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


    TrueSight Capacity Optimization


    Capacity Optimization


    CO all versions



    Sometimes when I Run an ETL I get errors like ORA-12516 or ORA-12519 or ORA-12520




    Legacy ID:KA350893


    This article describes how to troubleshoot the ORA-12516 and ORA-12519 errors:

    • ORA-12519: TNS: no appropriate service handler found
    • ORA-12516: TNS: listener could not find available handler with matching protocol stack
          ORA-12520: TNS:listener could not find available handler for requested type of server   

    If you find one of these errors in your BCO logs (ETL engine, Application Server or ETL execution logs), ask your DBA to perform the following actions on your Oracle database:

    1. verify that your database has free space on its disks
    3. modify two parameters to increase the number of processes and sessions

    How to modify the processes and sessions parameters


    The suggested values for a standard small or medium size installation are the following:

    • processes=280
    • sessions=300
     Higher values might be needed for larger instances, since these depend on the load of the database; contact your DBAs for suggestions.

    Applying these settings requires a restart of the Oracle DB instance; you will need to open a maintenance window and stop all BCO processes and ETLs on the BCO Application Server and ETL Engine.


    To apply the new settings, follow these steps:

    1. access the BCO Console, navigate to Administration > Scheduler > ETL tasks and verify that no ETL tasks are running; set the filters as highlighted in the figure:    
          User-added image  
    3. log in to your BCO machines (Application Server and ETL Engine) as BCO OS user and stop all BCO processes using the command $CPITBASE/cpit stop    
    5. log in to the database as sysdba via sqlplus using the command sqlplus '/as sysdba';    
      Ask your DBA to execute the necessary operations on the database, since appropriate skills and sysdba permissions are needed
      Replace CAP with your SID    
    7. apply the new settings issuing the following commands:    
      alter system set processes=280 scope=spfile; alter system set sessions=300 scope=spfile;
    9. stop the database instance using the command shutdown immediate;    
    11. restart the instance using the command startup;    
    13. exit sqlplus using the command quit;    
    15. log in to your BCO machines (Application Server and ETL Engines) as BCO OS user and restart all BCO processes using the command $CPITBASE/cpit start    
    17. wait 10 to 15 minutes for the Component status checker system task to complete its execution
    19. verify that your BCO instance was restarted correctly, checking the status of BCO components from the BCO Console, accessing the Administration > System > Status page    
            User-added image  


    Article Number:


    Article Type:

    Solutions to a Product Problem

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