Oracle tips

Checking from with group is runinnig instance
ORACLE_HOME\lib\config.c

Creating pfile from spfile
from sqlplus connected
create pfile from spfile

Creating instance - prepare spfile and may run database to nomount

Repair database though RMAN:
LIST FAILURE;
ADVISE FAILURE;
REPAIR FAILURE;

RMAN command
report schema
list copy of database;

catalog start with '/u01/oradata'; - changing database location


Recompiling oracle binareies without rack option
make -f $ORACLE_HOME/rdbms/ins_rdbms.mk rac_off ioracle

Relinking database
from $ORACLE_HOME/rdbms relink all

Editor from sqlplus
SQL> define _Editor=vim
SQL> ed