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
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