1- Create a pfile for parameters database (below are the contents of the initDB11ora.ora file)
*.audit_file_dest='/apps/ora11/admin/db11/adump'
*.audit_sys_operations=TRUE
*.audit_syslog_level='local1.warning'
*.audit_trail='OS'
*.compatible='11.2.0.0.0'
*.control_files='/oracle11/db11/control01.ctl','/oracle11/db11/control02.ctl','/oracle11/db11/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='db11'
*.deferred_segment_creation=FALSE
*.diagnostic_dest='/apps/ora11'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ebXDB)'
*.log_archive_dest_1='LOCATION=/arch11/DB11'
*.log_archive_format='%t_%s_%r.dbf'
*.memory_target=3221225472
*.open_cursors=300
*.parallel_max_servers=5
*.processes=200
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=225
*.undo_tablespace='UNDOTBS1'
2- Set Environment Variables:
set ORACLE_SID=db11
set ORACLE_HOME=/apps/ora11/product
3- Create a password file under $ORACLE_HOME/dbs
orapwd file=pwdDB11.ora password=sys1234 entries=5
4- Create the database.
sqlplus / as sysdba
SQL> startup nomount pfile="/apps/ora11/product/dbs/initDB11.ora"
CREATE DATABASE DB11
USER SYS IDENTIFIED BY ORACLE
USER SYSTEM IDENTIFIED BY ORACLE
DATAFILE '/oracle11/db11/SYSTEM01.DBF' SIZE 325M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SYSAUX DATAFILE '/oracle11/db11/\SYSAUX01.DAT' SIZE 120M REUSE AUTOEXTEND ON NEXT 5M MAXSIZE 2048M
DEFAULT TABLESPACE USERS DATAFILE '/oracle11/db11/USERS01.DBF' SIZE 50M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oracle11/db11/TEMP01.DBF' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE 1024M
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/oracle11/db11/UNDOTBS01.DBF'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
LOGFILE '/oracle11/db11/REDO01.LOG' SIZE 100M REUSE,
'/oracle11/db11/REDO02.LOG' SIZE 100M REUSE,
'/oracle11/db11/REDO03.LOG' SIZE 100MREUSE
EXTENT MANAGEMENT LOCAL
MAXLOGFILES 32
MAXLOGMEMBERS 4
MAXLOGHISTORY 100
MAXDATAFILES 254
MAXINSTANCES 1;
5- After database creation, run the post scripts as sysdba
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
@$ORACLE_HOME/rdbms/admin/utlrp.sql
6- Make a daatbase bounce just un case
shutdown immediate
startup
7- Force an archive log generation and check alert log for any error.
SQL> alter system switch logfile;
Comments