IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
Sometimes You can get “TNS-00508: No such protocol adapter ” error.
Details of error are as follows.
TNS-00508: No such protocol adapterCause: The protocol adapter requested for this connection does not exist.
Action: Install the protocol adapter or use one that is available.
Be sure that the correct protocols are listed in the configuration files.
When I run lsnrctl status, lsnrctl start or lsnrctl stop, I got the following error.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=msdbadm01)(PORT=1521)))
TNS-12538: TNS:no such protocol adapter
TNS-12560: TNS:protocol adapter error
TNS-00508: No such protocol adapter..
To solve this error, run the relink all as follows.
$ORACLE_HOME/bin relink all
Then try to start again. It will work fine.
Sometimes you may run the lsnrctl status command with different OS user instead of Oracle, in this time you can get this error.
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/
