Installation and Upgrade

How to Install Oracle Software in 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 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 an example of block […]
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. In this post, I will talk about the steps that we apply patch. Pre-Patching 1. Get the Latest OPatch Before any patching, you have to make sure your OPatch utility is the latest version in […]
Patching

How to Download Newest OPatch Utility

Posted on
Add OPatch to $PATH If you’re the first time to apply patches, you have to add OPatch to $PATH in order to apply your patches anywhere. If you have done it, you can skip this step. [oracle@test ~]$ vi .bash_profile … export PATH=$PATH:$ORACLE_HOME/OPatch [oracle@test ~]$ . .bash_profile [oracle@test ~]$ which opatch … Newest OPatch Download […]
Installation and Upgrade

How to Install Oracle Database 11.2.0.4 on Oracle Linux 7.2

Posted on
First of all, I take a short cut to prepare almost all required packages by installing oracle-rdbms-server-11gR2-preinstall. [root@db1 ~]# yum -y install oracle-rdbms-server-11gR2-preinstall Loaded plugins: ulninfo Resolving Dependencies –> Running transaction check —> Package oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-4.el7 will be installed –> Processing Dependency: gcc for package: oracle-rdbms-server-11gR2-preinstall-1.0-4.el7.x86_64 –> Processing Dependency: sysstat for package: oracle-rdbms-server-11gR2-preinstall-1.0-4.el7.x86_64 –> Processing […]