============================== Creating database in 10g ============================== export ORACLE_HOME=/usr/local/opt/oracle/product/10.2.0.3.0 export ORACLE_BASE=/usr/local/opt/oracle mkdir -p $ORACLE_HOME/cfgtoollogs/dbca/gesstg10 mkdir -p $ORACLE_HOME/dbs mkdir -p $ORACLE_BASE/admin/gesstg10/adump mkdir -p $ORACLE_BASE/admin/gesstg10/bdump mkdir -p $ORACLE_BASE/admin/gesstg10/cdump mkdir -p $ORACLE_BASE/admin/gesstg10/dpdump mkdir -p $ORACLE_BASE/admin/gesstg10/pfile mkdir -p $ORACLE_BASE/admin/gesstg10/udump mkdir -p $ORACLE_BASE/flash_recovery_area mkdir -p $ORACLE_BASE/oradata/gesstg10 ORACLE_SID=gesstg10; export ORACLE_SID echo You should Add this entry in the /etc/oratab: gesstg10:$ORACLE_HOME:Y $ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapwgesstg10 password=sys force=y entries=10 Note !!!: Check undotablespace name specified in pfile and create database command, they should match. ----------------------------------------------------- CreateDB ----------------------------------------------------- sqlplus /nolog connect SYS/sys as SYSDBA set echo on spool CreateDB.log startup nomount pfile="$ORACLE_HOME/dbs/initgesstg10.ora"; CREATE DATABASE gesstg10 MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/u06/oradata/gesstg10/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/u06/oradata/gesstg10/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u06/oradata/gesstg10/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u06/oradata/gesstg10/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED CHARACTER SET WE8ISO8859P1 NATIONAL CHARACTER SET AL16UTF16 LOGFILE GROUP 1 ('/u06/oradata/gesstg10/redo01.log') SIZE 51200K, GROUP 2 ('/u06/oradata/gesstg10/redo02.log') SIZE 51200K, GROUP 3 ('/u06/oradata/gesstg10/redo03.log') SIZE 51200K USER SYS IDENTIFIED BY sys USER SYSTEM IDENTIFIED BY manager; spool off ----------------------------------------------------- CreateDBFiles ----------------------------------------------------- connect SYS/sys as SYSDBA set echo on spool CreateDBFiles.log CREATE TABLESPACE "USERS" LOGGING DATAFILE '/u06/oradata/gesstg10/users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; ALTER DATABASE DEFAULT TABLESPACE "USERS"; spool off ----------------------------------------------------- CreateDBCatalog ----------------------------------------------------- connect SYS/sys as SYSDBA set echo on spool CreateDBCatalog.log @$ORACLE_HOME/rdbms/admin/catalog.sql; @$ORACLE_HOME/rdbms/admin/catblock.sql; @$ORACLE_HOME/rdbms/admin/catproc.sql; @$ORACLE_HOME/rdbms/admin/catoctk.sql; @$ORACLE_HOME/rdbms/admin/owminst.plb; connect SYSTEM/manager @$ORACLE_HOME/sqlplus/admin/pupbld.sql; connect SYSTEM/manager set echo on spool off spool sqlPlusHelp.log @$ORACLE_HOME/sqlplus/admin/help/hlpbld.sql helpus.sql; spool off ---------------------------------------------------------------------------------------------------------------- To Install Other Options like JServer,odm,context,xdb_protocol,ordinst,interMedia,cwmlite,spatial,emRepository ---------------------------------------------------------------------------------------------------------------- ----------------------------------------------------- JServer ----------------------------------------------------- connect SYS/sys as SYSDBA set echo on spool JServer.log @$ORACLE_HOME/javavm/install/initjvm.sql; @$ORACLE_HOME/xdk/admin/initxml.sql; @$ORACLE_HOME/xdk/admin/xmlja.sql; @$ORACLE_HOME/rdbms/admin/catjava.sql; @$ORACLE_HOME/rdbms/admin/catexf.sql; spool off ----------------------------------------------------- odm ----------------------------------------------------- connect SYS/sys as SYSDBA set echo on spool odm.log @$ORACLE_HOME/rdbms/admin/dminst.sql SYSAUX TEMP; spool off ----------------------------------------------------- context ----------------------------------------------------- connect SYS/sys as SYSDBA set echo on spool context.log @$ORACLE_HOME/ctx/admin/catctx change_on_install SYSAUX TEMP NOLOCK; connect "CTXSYS"/"change_on_install" @$ORACLE_HOME/ctx/admin/defaults/dr0defin.sql "AMERICAN"; spool off ----------------------------------------------------- xdb_protocol ----------------------------------------------------- connect SYS/sys as SYSDBA set echo on spool xdb_protocol.log @$ORACLE_HOME/rdbms/admin/catqm.sql change_on_install SYSAUX TEMP; connect SYS/sys as SYSDBA @$ORACLE_HOME/rdbms/admin/catxdbj.sql; @$ORACLE_HOME/rdbms/admin/catrul.sql; spool off ----------------------------------------------------- ordinst ----------------------------------------------------- connect SYS/sys as SYSDBA set echo on spool ordinst.log @$ORACLE_HOME/ord/admin/ordinst.sql SYSAUX SYSAUX; spool off ----------------------------------------------------- interMedia ----------------------------------------------------- connect SYS/sys as SYSDBA set echo on spool interMedia.log @$ORACLE_HOME/ord/im/admin/iminst.sql; spool off ----------------------------------------------------- cwmlite ----------------------------------------------------- set echo on spool cwmlite.log connect SYS/sys as SYSDBA @$ORACLE_HOME/olap/admin/olap.sql SYSAUX TEMP; spool off ----------------------------------------------------- spatial ----------------------------------------------------- connect SYS/sys as SYSDBA set echo on spool spatial.log @$ORACLE_HOME/md/admin/mdinst.sql; spool off ----------------------------------------------------- emRepository ----------------------------------------------------- connect SYS/sys as SYSDBA set echo off spool emRepository.log @$ORACLE_HOME/sysman/admin/emdrep/sql/emreposcre $ORACLE_HOME SYSMAN manager TEMP ON; WHENEVER SQLERROR CONTINUE; spool off ----------------------------------------------------- postDBCreation ----------------------------------------------------- connect SYS/sys as SYSDBA set echo on spool postDBCreation.log connect SYS/sys as SYSDBA set echo on create spfile='$ORACLE_HOME/dbs/spfilegesstg10.ora' FROM pfile='$ORACLE_HOME/dbs/initgesstg10.ora'; shutdown immediate; connect SYS/sys as SYSDBA startup ; alter user SYSMAN identified by manager account unlock; alter user DBSNMP identified by dbsnmp account unlock; select 'utl_recomp_begin: ' || to_char(sysdate, 'HH:MI:SS') from dual; execute utl_recomp.recomp_serial(); select 'utl_recomp_end: ' || to_char(sysdate, 'HH:MI:SS') from dual; REM Note : Provide appropriate hostname for below HOST parameter host $ORACLE_HOME/bin/emca -config dbcontrol db -silent -DB_UNIQUE_NAME gesstg10 -PORT 1521 -EM_HOME $ORACLE_HOME -LISTENER LISTENER -SERVICE_NAME gesstg10 -SYS_PWD sys -SID gesstg10 -ORACLE_HOME $ORACLE_HOME -DBSNMP_PWD dbsnmp -HOST oraserv -LISTENER_OH $ORACLE_HOME -LOG_FILE emConfig.log -SYSMAN_PWD manager; spool off exit;