Hi,
Sometimes You can get “TNS-12518: TNS:listener could not hand off client connection ” error.
Details of error are as follows.
TNS-12518: TNS:listener could not hand off client connection
This error is related with out of available Oracle processes.
To solve this error, 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.
Or you should check ‘max user processes’ etc. with ‘ulimit -a‘ command, and if it is insufficient, then increase it.
For windows environment.
set logging_listener_name=on in the listener.ora and reload the listener.
Or restart all Oracle services, it will be fine.
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/
1,593 views last month, 1 views today