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 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. 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 […]