User`s guide

5
Administering Oracle Database 5-1
5 Administering Oracle Database
This chapter describes how to administer Oracle Database 11g Release 2 for
BS2000/OSD.
Common administration tasks are described in the following sections:
■ Using the SQL*Plus Utility
■ Startup and Parameter Files
■ Remote Startup of a Database Instance
■ Automatic Diagnostic Repository
■ Checking the Integrity of the Physical Data Structure
5.1 Using the SQL*Plus Utility
The following topics are described in this section:
■ Starting the SQL*Plus Utility in BS2000
■ Calling SQL*Plus from a Procedure
■ Using SQL*Plus in the POSIX shell
■ Running System Commands from SQL*Plus
■ Using an Editor in SQL*Plus
■ Customizing SQL*Plus Profiles
5.1.1 Starting the SQL*Plus Utility in BS2000
To start SQL*Plus, enter the following:
/START-PROGRAM $ORAC1120.SQLPLUS
When you are prompted for parameters, enter /NOLOG :
* /NOLOG
This prevents SQL*Plus from prompting you for user name and password. Later you
can explicitly connect to the database. For example:
SQL> CONNECT / AS SYSDBA
For more ways to start SQL*Plus, refer to "Running SQL*Plus" in Oracle Database User's
Guide for Fujitsu BS2000/OSD.