I supposed that the Oracle Database Software is already installed.
1- Creat the required directories
mkdir -p /OraData/drportal/CtlF
mkdir -p /OraData/drportal/DataF
mkdir -p /OraData/drportal/OnRdLog
mkdir -p /oracle/OraHome9i/drportal/bdump
mkdir -p /oracle/OraHome9i/drportal/cdump
mkdir -p /oracle/OraHome9i/drportal/udump
2- Set the instance name:
export ORACLE_SID=DRPORTAL
3- create the init file /oracle/OraHome9i/dbs/initDRPORTAL.ora
control_files = (/OraData/drportal/CtlF/control01.ctl,
/OraData/drportal/CtlF/control02.ctl,
/OraData/drportal/CtlF/control03.ctl)
undo_management = auto
db_name = DRPORTAL
instance_name = DRPORTAL
db_block_size = 8192
background_dump_dest = /oracle/OraHome9i/drportal/bdump
core_dump_dest = /oracle/OraHome9i/drportal/cdump
user_dump_dest = /oracle/OraHome9i/drportal/udump
COMPATIBLE=9.2.0
PROCESSES=150
UNDO_TABLESPACE=undotbs1
4- Start the instance
sqlplus / as sysdba
select instance_name from v$instance;
startup nomount pfile='/oracle/OraHome9i/dbs/initDRPORTAL.ora';
5- Create the database as the following:
CREATE DATABASE DRPORTAL
USER SYS IDENTIFIED BY system12
USER SYSTEM IDENTIFIED BY system12
LOGFILE GROUP 1 ('/OraData/drportal/OnRdLog/redo01.log') SIZE 10M,
GROUP 2 ('/OraData/drportal/OnRdLog/redo02.log') SIZE 10M,
GROUP 3 ('/OraData/drportal/OnRdLog/redo03.log') SIZE 10M
MAXLOGFILES 192
MAXLOGMEMBERS 5
MAXLOGHISTORY 37394
MAXDATAFILES 500
MAXINSTANCES 32
CHARACTER SET WE8ISO8859P1
DATAFILE '/OraData/drportal/DataF/system.dbf' SIZE 300M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/OraData/drportal/DataF/temp01.dbf'
SIZE 500M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/OraData/drportal/DataF/undotbs01.dbf'
SIZE 2000M REUSE AUTOEXTEND Off ;
6- Create the spfile for this database:
create spfile from pfile;
7- Post steps for the database creation are to run:
-- As sys user
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
1- Creat the required directories
mkdir -p /OraData/drportal/CtlF
mkdir -p /OraData/drportal/DataF
mkdir -p /OraData/drportal/OnRdLog
mkdir -p /oracle/OraHome9i/drportal/bdump
mkdir -p /oracle/OraHome9i/drportal/cdump
mkdir -p /oracle/OraHome9i/drportal/udump
2- Set the instance name:
export ORACLE_SID=DRPORTAL
3- create the init file /oracle/OraHome9i/dbs/initDRPORTAL.ora
control_files = (/OraData/drportal/CtlF/control01.ctl,
/OraData/drportal/CtlF/control02.ctl,
/OraData/drportal/CtlF/control03.ctl)
undo_management = auto
db_name = DRPORTAL
instance_name = DRPORTAL
db_block_size = 8192
background_dump_dest = /oracle/OraHome9i/drportal/bdump
core_dump_dest = /oracle/OraHome9i/drportal/cdump
user_dump_dest = /oracle/OraHome9i/drportal/udump
COMPATIBLE=9.2.0
PROCESSES=150
UNDO_TABLESPACE=undotbs1
4- Start the instance
sqlplus / as sysdba
select instance_name from v$instance;
startup nomount pfile='/oracle/OraHome9i/dbs/initDRPORTAL.ora';
5- Create the database as the following:
CREATE DATABASE DRPORTAL
USER SYS IDENTIFIED BY system12
USER SYSTEM IDENTIFIED BY system12
LOGFILE GROUP 1 ('/OraData/drportal/OnRdLog/redo01.log') SIZE 10M,
GROUP 2 ('/OraData/drportal/OnRdLog/redo02.log') SIZE 10M,
GROUP 3 ('/OraData/drportal/OnRdLog/redo03.log') SIZE 10M
MAXLOGFILES 192
MAXLOGMEMBERS 5
MAXLOGHISTORY 37394
MAXDATAFILES 500
MAXINSTANCES 32
CHARACTER SET WE8ISO8859P1
DATAFILE '/OraData/drportal/DataF/system.dbf' SIZE 300M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/OraData/drportal/DataF/temp01.dbf'
SIZE 500M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/OraData/drportal/DataF/undotbs01.dbf'
SIZE 2000M REUSE AUTOEXTEND Off ;
6- Create the spfile for this database:
create spfile from pfile;
7- Post steps for the database creation are to run:
-- As sys user
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
No comments:
Post a Comment