###################################################################################################
!/bin/bash
#dirname='ccc'
#echo'Plssetthedatabaselocation='$1
#dirname=$1
#echo'Plssetthedatabaselocation='$dirname
#OLD_UMASK=`umask`
#umask0027
mkdir -p /u01/app/oracle/admin/dba33/bdump
mkdir -p /u01/app/oracle/admin/dba33/udump
mkdir -p /u01/app/oracle/admin/dba33/adump
mkdir -p /u01/app/oracle/admin/dba33/dpdump
#mkdir -p /u01/app/oracle/admin/dba33/pfile
#mkdir -p /u01/app/oracle/cfgtoollogs/dbca/dba33
mkdir -p /u01/app/oracle/flash_recovery_area
mkdir -p /u01/app/oracle/flash_recovery_area/dba33
mkdir -p /u01/app/oracle/oradata/dba33
mkdir -p /u01/app/oracle/admin/dba33
#umask${OLD_UMASK}
ORACLE_SID=dba33; export ORACLE_SID
#PATH=$ORACLE_HOME/bin:$PATH;exportPATH
echo "YoushouldAddthisentryinthe/etc/oratab:dba33:/u01/app/oracle/product/11.2.0/db_1:Y"
/u01/app/oracle/product/11.2.0/db_1/bin/orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapwdba33 force=y
cat >> /u01/app/oracle/product/11.2.0/db_1/dbs/initdba33.ora << EOF
db_block_size=8192
open_cursors=300
db_name=dba33
control_files="/u01/app/oracle/oradata/dba33/control01.ctl"
db_recovery_file_dest=/u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size=4070572032
compatible=11.2.0.0.0
diagnostic_dest=/u01/app/oracle
memory_target=729808896
processes=150
audit_file_dest=/u01/app/oracle/admin/dba33/adump
#audit_trail=db
remote_login_passwordfile=EXCLUSIVE
dispatchers="(PROTOCOL=TCP)(SERVICE=dba33XDB)"
undo_tablespace=undotbs1
EOF
/u01/app/oracle/product/11.2.0/db_1/bin/sqlplus "SYS/&&sysPassword as SYSDBA" <<EOF
set verify off
ACCEPT SidNmae CHAR PROMPT 'Enter new Instance Name : ' HIDE
ACCEPT sysPassword CHAR PROMPT 'Enter new password for SYS: ' HIDE
ACCEPT systemPassword CHAR PROMPT 'Enter new password for SYSTEM: ' HIDE
SET VERIFY OFF
# connect "SYS"/"&&sysPassword" as SYSDBA
set echo on
spool /u01/app/oracle/admin/dba33/createdatabaselog.log append
startup nomount pfile="/u01/app/oracle/product/11.2.0/db_1/dbs/initdba33.ora";
CREATE DATABASE kamran
LOGFILE
GROUP 1 (‘/u01/app/oracle/oradata/dba33/redo01.log’) SIZE 50M,
GROUP 2 (‘/u01/app/oracle/oradata/dba33/redo02.log’) SIZE 50M,
GROUP 3 (‘/u01/app/oracle/oradata/dba33/redo03.log’) SIZE 50M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET us7ascii
NATIONAL CHARACTER SET al16utf16
DATAFILE ‘/u01/app/oracle/oradata/dba33/system01.dbf’ SIZE 500 M REUSE EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE ‘/u01/app/oracle/oradata/dba33/sysaux.dbf’ SIZE 400 M REUSE
DEFAULT TABLESPACE tbs_1 DATAFILE ‘/u01/app/oracle/oradata/dba33/users.dbf’ SIZE 200 M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE ‘/u01/app/oracle/oradata/dba33/temp_tbs.dbf’ SIZE 100 M REUSE
undo TABLESPACE undotbs DATAFILE ‘/u01/app/oracle/oradata/dba33/undo01.dbf’ SIZE 200 M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
spool off
alter user sys account unlock identified by "&&sysPassword";
alter user system account unlock identified by "&&systemPassword";
@/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/catalog.sql;
@/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/catproc.sql;
create spfile FROM pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initdba33.ora';
shutdown immediate;
# connect "SYS"/"&&sysPassword" as SYSDBA
startup ;
connect "SYS"/"&&systemPassword"
@/u01/app/oracle/product/11.2.0/db_1/sqlplus/admin/pupbld.sql;
EOF
exit
echo ".......... Database have been creared ............."
#########################################################################################################