Site icon IT Tutorial

TNS-12542: TNS:address already in use

Hi,

Sometimes You can get ” TNS-12542: TNS:address already in use ” error.

 

Details of error are as follows.

TNS-12542: TNS:address already in use
Cause: Specified listener address is already being used.
Action: Start your listener with a unique address.

 

 

To solve this error, decrease the value for TIME_WAIT state.

 

Or you should use of IPC protocol, If the application or failing connection is local to the Database, use IPC for connectivity, instead of TCP.

 

 

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