


That being said, it is not necessary to be familiar with all of the command line interface utilities that we use for ongoing issues. For example, when you have to recover the production database, you will not have time to look at manuals for database recovery commands.

It is good to have a knowledge of some of the most frequently used commands for these interfaces, to troubleshoot any production issues when you do not have the luxury of extra time to look at the manuals or online knowledge base. Oracle has command line interface tools for all of it components, such as ASMCMD for Automatic Storage Management (ASM). Moreover, command line interfaces are easy and certain. As a Production or Development DBA, we’d better know all the syntax of the command line interface (CLI) utilities whether it is sqlplus or old srvrmgr, which Oracle no longer supports.
