For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Hi , Please advise why TRIMSPOOL is removing Page header (RIGHT) in the spool output. DB Version: 19c sqlplus version: 19.3 -> Not working as expected DB : 19c ( Same DB) sqlplus version: 18.4 -> Expected Result Regards, Veera
That indicates you should have an installation of Oracle Database on your personal machine. Do you?
"lsnrtl" is not recognized as an internal or external command, program or executable batch file. You mistyped lsnrctl here.
upsss! I'm sorry, I made a mistake in writing. I typed the correct command, I typed: lsnrctl
Yes, I also believe that I should have installed an Oracle Database! Thanks in advance! @thatjeffsmith-oracle and @cormaco
So, when you typed the correct command, what was the result? If it was still "is not recognized as an internal or external command, program or executable batch file.",
Then just like any other command that returns that error, it is because the executable ('lsnrctl' in this case) is not located in any directory that is part of your system PATH. Either you have not installed Oracle database on this machine (the one where you issued 'lsnrctl'), or you have failed to set the system environment variable PATH. Actually, that should have been done by the installation, if on Windows. You said, "I also believe that I should have installed an Oracle Database". Well either you did or you didn't. And it's not something trivial that you would have done without knowing for sure. If you are relying on the installation of SQL Dev, then no you have not installed an Oracle database. SQL Dev is just an IDE - a client. It is not a database, and does not have a database bundled in with it.
Thanks for your answer. Yes, I installed Oracle Database 19c @edstevens1 Now, the error I get when I try to create the connection is: Status: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor (CONNECTION_ID=/7ii3DHaT2Gz+eJN44XCEQ==)
I
If I type >lsnrctl status The message I am receiving is: listener is already started but it does not support any services . and if I type >oraenv it Tells me: "oraenv is not recognized as an internal or external command, program or executable batch file"
If I type >lsnrctl status The message I am receiving is: listener is already started but it does not support any services . That means your database is not started. and if I type >oraenv it Tells me: "oraenv is not recognized as an internal or external command, program or executable batch file" 'oraenv' exists only on *nix systems, not on Windows. what were you expecting by trying to execute it?
DB : 19c ( Same DB)
Regards,