Installation and Upgrade

How to Install Oracle 19c Software Only with Silent Mode

Posted on
With Response File First of all, let’s take a look at the content of the response file. [oracle@primary-19c ~]$ ll db-19c-software-only-installation.rsp -rwx—— 1 oracle oinstall 605 Aug  1 10:24 db-19c-software-only-installation.rsp [oracle@primary-19c ~]$ cat db-19c-software-only-installation.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0 oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory ORACLE_BASE=/u01/app/oracle oracle.install.db.InstallEdition=EE oracle.install.db.OSDBA_GROUP=dba oracle.install.db.OSOPER_GROUP=oper oracle.install.db.OSBACKUPDBA_GROUP=backupdba oracle.install.db.OSDGDBA_GROUP=dgdba oracle.install.db.OSKMDBA_GROUP=kmdba oracle.install.db.OSRACDBA_GROUP=racdba oracle.install.db.rootconfig.executeRootScript=true oracle.install.db.rootconfig.configMethod=ROOT Next, install Oracle 19c software with silent […]
Installation and Upgrade

How to Install Oracle 11g Software Only with Silent Mode

Posted on
With a Response File First of all, we have prepared a response file for installing Oracle software only as following. Let’s see the effective content of the response file. [oracle@ora11g ~]$ egrep -v “(^(#|$)|=$)” install-software-only-for-11g.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 oracle.install.option=INSTALL_DB_SWONLY ORACLE_HOSTNAME=ora11g UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory SELECTED_LANGUAGES=en,zh_TW ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 ORACLE_BASE=/u01/app/oracle oracle.install.db.InstallEdition=EE oracle.install.db.EEOptionsSelection=false oracle.install.db.DBA_GROUP=dba oracle.install.db.isRACOneInstall=false oracle.install.db.config.starterdb.type=GENERAL_PURPOSE oracle.install.db.config.starterdb.memoryOption=false oracle.install.db.config.starterdb.installExampleSchemas=false oracle.install.db.config.starterdb.enableSecuritySettings=true oracle.install.db.config.starterdb.control=DB_CONTROL oracle.install.db.config.starterdb.automatedBackup.enable=false SECURITY_UPDATES_VIA_MYORACLESUPPORT=false DECLINE_SECURITY_UPDATES=true […]
Central Inventory

How to Move Central Inventory

Posted on
Move Central Inventory Once you decided to move ORACLE HOME to a new place, you should consider to move the central inventory to another place before moving ORACLE HOME. Our plan is to move the central inventory from /u01/app/oraInventory to /home/oracle/oraInventory. In addition, we then abandon the old place for good. To move Oracle central […]
ASM

How to Resolve Grid Installation OUI Discovers No Disk

Posted on
Requirements for Disk Discovery There’re several requirements for disks to be discovered: 1. Right Device Type For 11g or later, only block devices leading by letter b in permission notation are acceptable, any others device types, such as character devices, symbolic links (leading by letter l) and pseudo devices are not ASM candidates. Please see […]
ASM

How to Resolve ASMLib Fails to Open Disk Candidates

Posted on
ASMLib Seems Good In my grid installation plan for 18c database, I use ASMLib to make device path persistent for ASM candidate disks. As a result, oracleasm should be able to recognize those disks as expected. [root@primary01 ~]# oracleasm listdisks ASMDISK01 ASMDISK02 [root@primary01 ~]# oracleasm-discover Using ASMLib from /opt/oracle/extapi/64/asm/orcl/1/libasm.so [ASM Library – Generic Linux, version […]
Patching

How to Apply Patch in Oracle Database

Posted on
Keeping your database running with the newest release of Oracle software might be a critical job for DBA to implement, especially for production environments. Although I’ll talk about the steps that we apply patch, you should read readme.txt in patch files before taking any actions. Pre-Patching 1. Get the Latest OPatch Before any patching, you […]