Wednesday, September 7, 2022

Silent Installation- Oracle 19c Database

    Install Database Software only

    1. Install preinstall package for Oracle 19c
    2. yum install -y oracle-database-preinstall-19c
    3. If you using RHEL8, then retreive RPM's from repository as follows
    4. curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
      
      yum -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
    5. Download oracle 19c database software
    6. https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html
    7. Copy downloaded file to the server and unzip under oracle_home
    8. cd /u01/app/oracle/product/19.0.0/dbhome_1
      cp ~/V982063-01.zip .
      unzip V982063-01.zip
    9. Backup existing response file
    10. cd /u01/app/oracle/product/19.0.0/db_1/install/response
      cp db_install.rsp db_install.rsp_bkp
    11. Modify Response file as below
    12. [oracle@ip-10-82-109-39 ~]$ cat /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_install.rsp
      
      oracle.install.option=INSTALL_DB_SWONLY
      UNIX_GROUP_NAME=dba
      INVENTORY_LOCATION=/u01/app/oraInventory
      ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
      ORACLE_BASE=/u01/app/oracle
      oracle.install.db.InstallEdition=EE
      oracle.install.db.OSDBA_GROUP=dba
      oracle.install.db.OSOPER_GROUP=dba
      oracle.install.db.OSBACKUPDBA_GROUP=dba
      oracle.install.db.OSDGDBA_GROUP=dba
      oracle.install.db.OSKMDBA_GROUP=dba
      oracle.install.db.OSRACDBA_GROUP=dba
      oracle.install.db.rootconfig.executeRootScript=false
    13. To avoid bug '[INS-08101] Unexpected error while executing the action at state: 'supportedOSCheck'' in Oracle 19c on RHEL8
    14. export CV_ASSUME_DISTID=OEL7.8
    15. Install Pre-requisites to check any errors
    16. [oracle@ip-10-82-109-14 dbhome_1]$ ./runInstaller -executePrereqs -silent -responseFile /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_install.rsp
    17. Install DB software as silent mode
    18. [oracle@ip-10-82-109-14 dbhome_1]$ ./runInstaller -silent -responseFile /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_install.rsp
    19. Execute root.sh from root user
    20. [root@ip-10-82-109-14 dbhome_1]$ /u01/app/oraInventory/orainstRoot.sh
      [root@ip-10-82-109-14 dbhome_1]$ /u01/app/oracle/product/19.0.0/dbhome_1/root.sh
    21. Verify the Installation

    Create Database

    1. Modify Response file accordingly
    2. vi /u01/app/oracle/product/19.0.0/dbhome_1/assistants/dbca/dbca.rsp
    3. Modify template file as per the requirement
    4. vi /u01/app/oracle/product/19.0.0/dbhome_1/assistants/dbca/templates/New_Database.dbt
    5. Create Database using response and template (template file use within response file)
    6.  cd /u01/app/oracle/product/19.0.0/dbhome_1/assistants/dbca
       dbca -createDatabase -silent -responseFile ./dbca.rsp
    7. Configure Listener (listener and tns entries) after the DB creation
    8.  cd /u01/app/oracle/product/19.0.0/dbhome_1/network/admin
       vi tnsnames.ora
       vi listener.ora

No comments:

Post a Comment