Tuesday, March 15, 2016

Oracle Database Configuration

Oracle Database Configuration

Set the .bash_profile

ORACLE_HOME=/d04/product/11.2.0/dbhome_1
export ORACLE_HOME

ORACLE_SID=DEV
export ORACLE_SID

export PATH=$PATH:$ORACLE_HOME/bin

Create pfile from spfile

CREATE PFILE = '/d04/product/11.2.0/dbhome_1/dbs/initDEV.ora'
FROM SPFILE = '/d04/product/11.2.0/dbhome_1/dbs/spfiledev.ora';

Enable archivelog mode

shutdown immediate
startup mount
alter database archivelog
alter database open

No comments:

Post a Comment