Site icon IT Tutorial

ORA-12519: TNS no appropriate service handler found

Hi,

Sometimes You can get “ORA-12519: TNS:no appropriate service handler found  ” error.

 

Details of error are as follows.

ORA-12519: TNS:no appropriate service handler found
Cause: The listener could not find any available service handlers that are appropriate for the client connection.
Action: Run “lsnrctl services” to ensure that the instance(s) have registered with the listener, and are accepting connections.

This error is related with out of available Oracle processes.

 

 

 

If processes parameters are insufficient, then you should increase the PROCESSES parameter as follows.

 

SQL> show parameter processes

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 1500
SQL>
SQL>
SQL> alter system set processes=2000 scope=spfile;

System altered.

SQL>

 

Restart database after this operation.

 

 

Do you want to learn more details about RMAN, then read the following articles.

https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/

 

Exit mobile version