How to solve Oracle database ERROR: ORA-12541: TNS:no listener?

Executing sqlplus to connect to local database gives below error when the respective service is not running.

ERROR:
ORA-12541: TNS:no listener

To solve this issue, follow below steps:

1. Goto Services.msc

2. Start the below services:

OracleOraDB21Home1MTSRecoveryService
OracleOraDB21Home1TNSListener
OracleServiceXE

3. Then try again the sqlplus command. Enter the user-name and password if prompted.

C:\>sqlplus CTXSYS/CTXSYS@//localhost:1521/XE;

SQL*Plus: Release 21.0.0.0.0 - Production on Sun Apr 24 17:26:31 2022
Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Enter user-name: CTXSYS
Enter password:
Last Successful login time: Sun Apr 24 2022 17:28:39 +05:30

Connected to:
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

SQL>

Leave a Reply

%d bloggers like this:
Available for Amazon Prime