SQLCODE"
at the beginning of the script. If a SQL error occurs, the job status is set to failed.
Run DBA Script
This job executes a Server Manager line mode script that contains DBA commands.
You can record and save SQL commands with the Log menu options and use those
saved commands as a script. When you create a DBA script, save it in the
ORACLE_HOME\sysman\scripts\dba directory to make the script easily
accessible.
Parameters:
1.
DBA Script Name. The file must be accessible from the Console. Click on the
Browse button to display the standard Windows File selection box to locate the
name of an existing file. When you click the OK button after locating a DBA
script file, the contents of the file are displayed in the Script Text box.
Note:
If you want to create a new script file, first click the Save button and enter a
file name in the File Name field of the Save As dialog box.
2.
Override Preferred Credentials. You can use the preferred credentials that have
been set up for the database, or you can enter a username and password. If you
check the box to override the credentials, then you need to enter:
a.
User Name. Username for accessing the database.
b.
Password. Password for the username.
c.
Connect As. Select the role you want to connect as from the pull-down list.
Note:
See Console User Preferences on page 1-24 for more information.
3.
Script Text. You can edit the commands in the DBA Script box. Click the Save
button to save the updates.
Note:
If you want to save the changes to a different file, you can change the name
of the DBA script file in the File Name field of the Save As dialog box.
Job Scheduling
4-17
Oracle Job Tasks
Shutdown Database
This job task shuts down an Oracle database instance.
Parameters:
1.
Mode: (Use Immediate, or Abort, to avoid suspending the job indefinitely.)
■
Normal
■
Immediate
■
Abort
2.
Role:
■
SYSDBA
■
SYSOPER
3.
Override Preferred Credentials. Check the box if you want to override the
preferred credentials that have been set up for the database. If you check the
box to override the credentials, then you need to enter:
a.
User Name. Enter the username for accessing the database.
b.
Password. Enter the password for the username.
Note:
See Console User Preferences on page 1-24 for more information.
Startup Database
This job task starts up an Oracle database instance.
Parameters:
1.
Startup State. Select the start up state from the pull-down list:
■
Startup instance, mount, and open database
■
Startup instance and mount database
■
Startup instance only
2.
Parameter File. Enter the initialization parameter filename you want to use for
the database. This file is located on the node where the agent and database
reside. For example with a database on a Unix platform:
/rdbms/oracle73/myinit.ora
If you do not enter a filename, the default platform-specific initialization file is
used.
4-18 Oracle Enterprise Manager Administrator’s Guide
Oracle Job Tasks
3.
Override Preferred Credentials. Check the box if you want to override the
preferred credentials that have been set up for the database. If you check the
box to override the credentials, then you need to enter:
a.
User Name. Enter the username for accessing the database.
b.
Password. Enter the password for the username.
Note:
See Console User Preferences on page 1-24 for more information.
4.
Mount Mode. Select the mount option from the pull-down list:
■
Exclusive
■
Normal
■
Parallel
5.
Connect As. Select the connecting role from the pull-down list:
■
SYSDBA
■
SYSOPER
6.
Restrict Connections. Check this box if you want to restrict this session of the
database.
7.
Force Startup. Check this box if you want to force the startup of a database that
is running.
Backup
This job allows you to submit a backup script that has been created with Oracle
Backup Manager. The scripts for backing up a database are generated in the Tcl