Server Manager HELP command
- Question: How does one write a shell script to count the number of instances on a UNIX server?
- Answer: You can do this in several ways, but I start at the oratab file to get the instance count:
cat /etc/oratab | grep -v "^\#" | grep -v "^*" | grep -v "^$" | wc -l
Server Manager and Database Administration
Server Manager is designed to replace SQL*DBA and provide administrative functionality through an easy-to-use interface.
You can use Server Manager to: Perform traditional administrative tasks, such as
- database startup,
- backup, and
Rather than manually entering the SQL commands to perform these tasks, you can use Server Manager's graphical interface to execute the commands quickly and conveniently.
Concurrently perform multiple tasks.
Because you can open multiple windows simultaneously in Server Manager, you can perform multiple administrative and non-administrative tasks concurrently.
Administer multiple databases. You can use Server Manager to administer a single database or to simultaneously administer multiple databases. Centralize database administration tasks.
You can administer both local and remote databases running on any Oracle platform at any location worldwide.
In addition, these Oracle platforms can be connected by any network protocol(s) supported by SQL*Net and the MultiProtocol Interchange. Dynamically execute SQL, PL/SQL, and Server Manager commands.
You can use Server Manager to enter, edit, and execute statements.
Server Manager also maintains a history of statements executed.
Thus, you can re-execute statements without retyping them, a particularly useful feature if you need to execute lengthy
statements repeatedly. Perform administrative tasks using Server Manager's line mode interface when a graphical user
interface is unavailable or undesirable.