I installed Oracle 8.1.7 on a Unix box, and I installed the client on my 2000 box. Now my question is what is 'Oracle Server Manager'? How is it installed? What is the use of it? How do I access it from my client box? What is the difference between OSM and DBA Studio that was installed on my client box?
Oracle Server Manager is a command line utility that is primarily used to start and stop the database. It is installed on the database box. To invoke Server Manager, issue 'svrmgrl' from the command line on your Unix box. You do not access Server Manager from your client workstation. You can use other utilities to start and stop your database, such as DBA Studio or Oracle Enterprise Manager (OEM).
Since you have never used Server Manager before, I suggest that you don't even start with it. Server Manager is seeing the end of the line with the 8.1.7 release of Oracle. It is being replaced by SQL*Plus. SQL*Plus now has all of Server Managers functionality built within it. To start SQL*Plus like Server Manager, issue the following:
sqlplus /nologAt the prompt, you can then issue:
connect / as sysdbaThis will let you start and stop the database. Of course, you can still use DBA Studio or OEM.
For More Information
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.