Please try the below steps for the command. But before that, kindly let me know whether you are able to connect to DB using the username and password configured for PRPC via SQLPLUS ? Also using SID with that ? ( Refer my above comment item #2 & #3)
Open a command window.
You will get a prompt the reads LSNRCTL>
If you see the xe* listeners in READY your database is up and running
If you can´t see the listeners on READY. You need to start the database.
The following steps explain how to startup the database (be adviced this is an Oracle course configuration with no password).
Open a command window
Type sqlplus /nolog. You´ll get a SQLPLUS> prompt.
I have requested you to refer above comment #2 and #3 but you have referred the same post item #2 and #3.
This command is to verify the username and password configured for PRPC is valid and able to connect to database. Also, with the configured SID.But i could see that SQLPLUS is showing not recognized command. You need to export your environmental variable to use SQLPLUS command.
What is the versions of DB and application server you are using? Can you please share the complete log file as well?
Posted: 3 years ago
Updated: 3 years ago
Posted: 10 Feb 2018 11:03 EST Updated: 12 Feb 2018 6:13 EST
Oracle Listener control command need to be executed from the command prompt as shown in the attachment.
You can make sure your Oracle TNS Listener is being started or not from the Services in Windows using services.msc and check the status of Oracle related TNS listener status in the list of services as shown in attachment.