1. Create the pfile and sample parameter file is below
DUMMY.__db_cache_size=109051904
DUMMY.__java_pool_size=4194304
DUMMY.__large_pool_size=4194304
DUMMY.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
DUMMY.__pga_aggregate_target=167772160
DUMMY.__sga_target=251658240
DUMMY.__shared_io_pool_size=0
DUMMY.__shared_pool_size=125829120
DUMMY.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/DUMMY/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/ORADATA/DUMMY/fra/DUMMY/controlfile/control_01_.ctl','/ORADATA/DUMMY/fra2/DUMMY/controlfile/control_02_.ctl'
*.db_block_size=8192
*.db_create_file_dest='/ORADATA/DUMMY/data' ------ comment out if not using OMF
*.db_create_online_log_dest_1='/ORADATA/DUMMY/fra' ------ comment out if not using OMF
*.db_create_online_log_dest_2='/ORADATA/DUMMY/fra2' ------ comment out if not using OMF
*.db_domain='localdomain'
*.db_name='DUMMY'
*.db_recovery_file_dest_size=10737418240
*.db_recovery_file_dest='/REC_DATA/DUMMY/flash_recovery_area'
*.db_unique_name='DUMMY'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=DUMMYXDB)'
*.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.XXX.XXX)(PORT=1530)))'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_format='DUMMY_%t_%s_%r.dbf'
*.log_archive_max_processes=30
*.memory_target=419430400
*.open_cursors=300
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=335
*.undo_tablespace='UNDOTBS1'
2. create the listener and tns entry and set the local_listener in parameter file
3. Set the environment like ORACLE_HOME , PATH and ORACLE_SID
4. startup nomount the instance
5. Run the script to create the DB, metadata and some usefull pacakges. ---
a.
The below script use is used for creation of db with OMF enabled
and to create the OMF enabled database we must need set the parameters and for normal database creation use the step b script
db_create_file_dest=/u02/abcd/oradata
db_create_online_log_dest_1=/u02/dabcd/oradata
db_create_online_log_dest_2=/u02/abcd/oradata
spool /var/tmp/CreateDB_ABCD.log
set echo on
WHENEVER OSERROR EXIT 1
WHENEVER SQLERROR EXIT 1
connect sys as sysdba
startup nomount
CREATE DATABASE ABCD
USER SYS IDENTIFIED BY changeonlogin
USER SYSTEM IDENTIFIED BY changeonlogin
MAXDATAFILES 5000
MAXINSTANCES 20
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
MAXLOGMEMBERS 3
MAXLOGHISTORY 500
MAXLOGFILES 200
EXTENT MANAGEMENT LOCAL
DATAFILE SIZE 300M AUTOEXTEND ON NEXT 100M MAXSIZE 8G
SYSAUX DATAFILE SIZE 300M AUTOEXTEND ON NEXT 100M MAXSIZE 8G
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE SIZE 100M
AUTOEXTEND ON NEXT 100M MAXSIZE 8G
DEFAULT TABLESPACE USERS DATAFILE SIZE 20M
AUTOEXTEND ON NEXT 100M MAXSIZE 8G EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
UNDO TABLESPACE "UNDOTBS1" DATAFILE SIZE 100M
AUTOEXTEND ON NEXT 100M MAXSIZE 8G
LOGFILE
GROUP 11 SIZE 100M,
GROUP 12 SIZE 100M,
GROUP 13 SIZE 100M
;
REM **** Various SQL packages ***************
WHENEVER SQLERROR CONTINUE
set termout off
@$ORACLE_HOME/rdbms/admin/catalog.sql;
@$ORACLE_HOME/rdbms/admin/catproc.sql;
@$ORACLE_HOME/rdbms/admin/catblock.sql;
@$ORACLE_HOME/rdbms/admin/catoctk.sql;
@$ORACLE_HOME/rdbms/admin/owminst.plb;
REM **** End various SQL packages ***************
REM **** Various SQLPLUS packages ***************
connect system/changeonlogin
@$ORACLE_HOME/sqlplus/admin/pupbld.sql;
connect system/changeonlogin
@$ORACLE_HOME/sqlplus/admin/help/hlpbld.sql helpus.sql;
REM **** End various SQLPLUS packages ***************
set termout on
spool off
b.
spool /var/tmp/CreateDB_ABCD.log
set echo on
WHENEVER OSERROR EXIT 1
WHENEVER SQLERROR EXIT 1
connect sys as sysdba
startup nomount
CREATE DATABASE ABCD
USER SYS IDENTIFIED BY changeonlogin
USER SYSTEM IDENTIFIED BY changeonlogin
MAXDATAFILES 2000
MAXINSTANCES 20
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
MAXLOGMEMBERS 3
MAXLOGHISTORY 500
MAXLOGFILES 200
EXTENT MANAGEMENT LOCAL
DATAFILE '/u02/oradata/ABCD/datafile/system_01.dbf' SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE 8G
SYSAUX DATAFILE '/u02/oradata/ABCD/datafile/sysaux_01.dbf' SIZE 700M AUTOEXTEND ON NEXT 100M MAXSIZE 8G
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u02/oradata/ABCD/datafile/temp_01.dbf' SIZE 1024M
AUTOEXTEND ON NEXT 100M MAXSIZE 8G
DEFAULT TABLESPACE USERS DATAFILE '/u02/oradata/ABCD/datafile/users_01.dbf' SIZE 20M
AUTOEXTEND ON NEXT 100M MAXSIZE 8G EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u02/oradata/ABCD/datafile/undotbs1_01.dbf' SIZE 300M
AUTOEXTEND ON NEXT 100M MAXSIZE 8G
LOGFILE
GROUP 11 ('/u02/oradata/ABCD/onlinelog/redoT01G01M01.rdo','/u03/PSAM/oradata/PSAMS/onlinelog/redoT01G01M02.rdo') SIZE 100M,
GROUP 12 ('/u02/oradata/ABCD/onlinelog/redoT01G02M01.rdo','/u03/PSAM/oradata/PSAMS/onlinelog/redoT01G02M02.rdo') SIZE 100M,
GROUP 13 ('/u02/oradata/ABCD/onlinelog/redoT01G03M01.rdo','/u03/PSAM/oradata/PSAMS/onlinelog/redoT01G03M02.rdo') SIZE 100M
;
REM **** Various SQL packages ***************
WHENEVER SQLERROR CONTINUE
set termout off
@$ORACLE_HOME/rdbms/admin/catalog.sql;
@$ORACLE_HOME/rdbms/admin/catproc.sql;
@$ORACLE_HOME/rdbms/admin/catblock.sql;
@$ORACLE_HOME/rdbms/admin/catoctk.sql;
@$ORACLE_HOME/rdbms/admin/owminst.plb;
REM **** End various SQL packages ***************
REM **** Various SQLPLUS packages ***************
connect system/changeonlogin
@$ORACLE_HOME/sqlplus/admin/pupbld.sql;
connect system/changeonlogin
@$ORACLE_HOME/sqlplus/admin/help/hlpbld.sql helpus.sql;
REM **** End various SQLPLUS packages ***************
set termout on
spool off
6. The Database is created in no archive log mode. If to setup in archive log mode
shut immediate
startup mount
alter database archivelog;
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 240
Next log sequence to archive 242
Current log sequence 242
- In 11g by default the archive og location is flash recovery area
alter database open;
To know about the SQL packages http://docs.oracle.com/cd/E11882_01/server.112/e25513/scripts.htm
No comments:
Post a Comment