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/