DisplayAdd1

TechnoTechDB is a platform, which will help to grow your carrier in Information sector. Having 15 years of Experience in Oracle/MongoDB/Postgres/Mysql databases, along with having good expertise level of knowledge in Scripting to automate database task. Our goal to start with zero to hero level expertise in Database. You can access/refer my some blogs on https://mrorcldba.blogspot.com link and post your comments and your suggestion to motive us.

Tuesday, 4 July 2023

Silent Mode - Oracle Database Installation and DB creation.

Steps to install oracle 11g and Database silent mode  .


============================================

--- Silent DB Binary Installation  on File System.

============================================


cat /tmp/db_install.rsp


oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=instance-20230630-1255

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/ora11g/oracle/oraInventory

SELECTED_LANGUAGES=en

ORACLE_HOME=/ora11g/oracle/product/11g/dbhome_1

ORACLE_BASE=/ora11g/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.DBA_GROUP=dba

oracle.install.db.BACKUPDBA_GROUP=dba

oracle.install.db.DGDBA_GROUP=dba

oracle.install.db.KMDBA_GROUP=dba

oracle.install.db.OSRACDBA_GROUP=dba

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

DECLINE_SECURITY_UPDATES=true

oracle.installer.autoupdates.option=SKIP_UPDATES


./runInstaller -silent -responseFile /tmp/db_install.rsp



============================================

--- Silent DB creation on File System.

============================================


export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_BASE=/opt/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11g/dbhome_1

export ORA_INVENTORY=/u01/app/oraInventory

export PATH=/usr/sbin:/usr/local/bin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export ORACLE_SID=ORCL11G

export DATA_DIR=/u01/app/oracle/oradata/ORCL11G

dbca -silent -createDatabase                                                   \

     -templateName $ORACLE_BASE/product/11g/dbhome_1/assistants/dbca/templates/General_Purpose.dbc                                        \

     -gdbname ${ORACLE_SID} -sid  ${ORACLE_SID} -responseFile NO_VALUE         \

     -characterSet AL32UTF8                                                    \

     -sysPassword SysPassword                                                 \

     -systemPassword SysPassword                                              \

     -databaseType MULTIPURPOSE                                                \

     -totalMemory 4096 -automaticMemoryManagement true \

     -storageType FS                                                           \

     -datafileDestination "${DATA_DIR}"                                        \

     -redoLogFileSize 50                                                       \

     -emConfiguration NONE                                                     



============================================

--- Silent DB creation on File System with 11g EM.

============================================


dbca -silent -createDatabase -templateName /ora11g/oracle/product/11g/dbhome_3/assistants/dbca/templates/General_Purpose.dbc -gdbname oratdb -sid oratdb -responseFile NO_VALUE -characterSet AL32UTF8 -totalMemory 4096 -automaticMemoryManagement true  -emConfiguration LOCAL -datafiledestination /u01/app/oracle/oradata/ora11g -sysPassword Oracle123 -systemPassword Oracle123 -dbsnmpPassword Oracle123 -sysmanPassword Oracle123


No comments:

Post a Comment

Steps to Rename Host in Oracle RESTART (ASM) in Linux

  oracle@localhost ] asmcmd ASMCMD> lsdg State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_...