Tag: CLI
Oracle’s SRVCTL: Enable an Instance. Make an Instance Preferred. Check a Service’s Status.
How to use the Oracle Server Control (srvctl) to enable instances, and see configurations and statuses.
Continue Reading...Oracle srvctl Basics – Listener and Database Commands
When a database is getting started, generally the listener control service (lsnrctl) is started and the database is started by logging into the database and executing the startup command. If you’re in a RAC configuration, you should be using srvctl; this command knows your configuration and works on the entire RAC environment instead of just […]
Continue Reading...Change Oracle’s SQLPLUS EDitor
Not everyone wants to use sqlplus’ built in editor. It is a bit of a pain and not at all WYSIWYG. Thankfully, changing sqlplus to use another editor is an easy process where you change the _editor session variable to another value. For a more permanent change, you can alternatively change the setting in the […]
Continue Reading...SQL Server’s oSQL – How to Create a Date-Stamped Log
Use oSQL to run a query and save the output to a file that includes the date in the filename.
Continue Reading...