[Laskey99] Section 9.4. SQLDBA

来源：百度文库 编辑：神马文学网 时间：2024/04/28 21:45:17

9.4. SQLDBA

SQLDBA is an Oracle-supplied utilityprogram that is similar in function to Server Manager. SQLDBA wassupplied with Oracle Version 6, but was made obsolete with theintroduction of Server Manager with Oracle7 Version 7.0. SQLDBA wassupplied, for compatibility purposes, through Oracle7 Version 7.2.

Functionally, SQLDBA is much like the newer Server Manager. Itprovides the ability to execute SQL statements as well as to performmonitoring of the Oracle database to which it is attached. SQLDBA isa character-mode application; there is no graphical version, althoughsome basic character-mode graphics are used where available.

There are a number of differences between SQLDBA and the newerServer Manager; some of them areoperational, but most are cosmetic. One of the most notabledifferences is the behavior of the STARTUP command. When you areusing SQLDBA to start a database, any failure in the startup processresults in all operations being backed out and the database beingshut down. When you are using Server Manager, however, failure of anystep of the startup leaves the database in its current state. Forexample, if an error occurs after mounting the database, ServerManager will leave the database mounted, while SQLDBA will dismountthe database and shut down Oracle.

For more information about differences between SQLDBA and ServerManager, see Oracle Corporation's online SQLDBA toOracle Server Manager Migration Guide.

  • Create Bookmark (Key: b)Create Bookmark
  • Create Note or Tag (Key: t)Create Note or Tag
  • Download (Key: d)Download
  • Email This Page (Key: e)Email This Page
  • PrintPrint
  • Html View (Key: h)Html View
  • Zoom Out (Key: -)Zoom Out
  • Zoom In (Key: +)Zoom In
  • Toggle to Full Screen (Key: f)
  • Previous (Key: p)Previous
  • Next (Key: n)Next

Related Content

PL/SQL
From: Oracle Application Server 10g Essentials

Case Studies: Using Open Source and Closed Source Tools
From: Penetration Tester’s Open Source Toolkit

Oracle Application Server
From: Oracle Security

What You Need to Get Started with PL/SQL
From: Learning Oracle PL/SQL

The DBA Toolkit and Security
From: Oracle Security

What's Next?
From: Oracle Application Server 10g Essentials

Oracle Database Objects
From: Oracle Security


[Laskey99] Section 9.4. SQLDBA [Laskey99] Section 11.2. Oracle Tablespaces [Laskey99] Section 11.3. Disk Allocation [Laskey99] Section 2.6. Critical Decisions [Laskey99] Section 9.2. SQL*Plus [Laskey99] Section 4.2. Database Backup [Laskey99] Section 4.3. Database Recovery [Laskey99] Section 4.4. Automated Utilities [Laskey99] Section 4.5. Practice Scenarios [Laskey99] Section 3.4. Configuring Oracle [Laskey99] Section 3.6. Tuning Oracle [Laskey99] Section 5.2. Oracle Names [Laskey99] Section 5.3. MultiProtocol Interchange [Laskey99] Section 15.2. System Privileges [Laskey99] Section 13.2.2 ALTER DATABASE ARCHIVELOG [Laskey99] Section 13.2.3 ALTER DATABASE MOUNT [Laskey99] Section 9.3. Oracle Server Manager [Laskey99] Section 9.5. Oracle Network Manager [Laskey99] Section 9.7. Oracle Enterprise Manager [Laskey99] Section 9.8. Third-Party Tools [Laskey99] Section 3.2. Achieving Maximum Performance [Laskey99] Section 3.3. Configuring the Operating System [Laskey99] Section 5.5. Oracle Network Manager [Laskey99] Section 5.6. Oracle Net8 Assistant