Oracle

Oracle

Startup / Shutdown

Login to SQL prompt:

sqlplus / as sysdba

Startup normally

SQL> startup;

Startup without actually mounting

SQL> startup nomount;

Use additional initialization file:

SQL> startup nomount pfile='/path/to/init.ora';

Shutdown:

SQL> shutdown;

Shutdown and terminate existing connections

SQL> shutdown immediate;

Shutdown and abort everything (last resort):

SQL> shutdown abort;

RMAN

Segmentation Fault while running sbttest

Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.