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>
