Where to Change Redo Logs in DBCA or OUIby Ed ChenMay 7, 2017January 19, 2023The default size of redo log files is 50MB or 200MB during database creation. It could be too small for databases with high volume transactions… Read More »Where to Change Redo Logs in DBCA or OUI
How to Move 11.2.0.2 Database to 11.2.0.4 Environment and Upgradeby Ed ChenNovember 27, 2016September 7, 2023Knowing all related directories on the source database Form the bottom, we would like to know the location of spfile, control_file, recovery area, trace dumps,… Read More »How to Move 11.2.0.2 Database to 11.2.0.4 Environment and Upgrade
How to Upgrade 11.2.0.2 Database to 11.2.0.4 by DBUAby Ed ChenNovember 27, 2016January 17, 2021If you would like to upgrade the database via CLI interface, you may refer to this post: How to Move 11.2.0.2 Database to 11.2.0.4 Environment… Read More »How to Upgrade 11.2.0.2 Database to 11.2.0.4 by DBUA
How to Install Oracle Database 11.2.0.4 on Oracle Linux 7.2by Ed ChenNovember 6, 2016June 23, 2023Please download Oracle Database 11.2.0.4 (Patchset 13390677) for your platform, which is actually a full installer of Oracle database. First of all, I take a… Read More »How to Install Oracle Database 11.2.0.4 on Oracle Linux 7.2
How to Resolve Error in invoking target 'agent_nmhs' of makefile ins_emagent.mkby Ed ChenOctober 31, 2016December 11, 202228 Commentsins_emagent.mk During the installation of Oracle 11.2.0.4 on Enterprise Linux 7.2, I met this error about ins_emagent.mk below: In the installation log, we saw a… Read More »How to Resolve Error in invoking target 'agent_nmhs' of makefile ins_emagent.mk
How to Build 12c RAC (6/6) - Post-Installation Verificationby Ed ChenSeptember 24, 2015January 17, 2021How to Build 12c RAC (5/6) - Installing RAC Database Finally, we have installed 1 NAS for shared storage, 1 DNS for SCAN round robin,… Read More »How to Build 12c RAC (6/6) - Post-Installation Verification
How to Build 12c RAC (5/6) - Installing RAC Databaseby Ed ChenSeptember 23, 2015February 13, 2023How to Build 12c RAC (4/6) - Installing Grid Infrastructure Run Universal Installer as oracle. [oracle@primary01 ~]$ cd /tmp/database/ [oracle@primary01 database]$ ./runInstaller Starting Oracle Universal… Read More »How to Build 12c RAC (5/6) - Installing RAC Database
How to Build 12c RAC (4/6) - Installing Grid Infrastructureby Ed ChenSeptember 22, 2015February 13, 20232 CommentsHow to Build 12c RAC (3/6) - Preparing for Installations of Grid and RAC If the preparation work is done well, the following grid or… Read More »How to Build 12c RAC (4/6) - Installing Grid Infrastructure
How to Build 12c RAC (3/6) - Preparing for Installations of Grid and RACby Ed ChenSeptember 21, 2015June 22, 20234 CommentsHow to Build 12c RAC (2/6) - Building Two Servers for RAC Before we can actually install grid infrastructure and RAC database, there's a long… Read More »How to Build 12c RAC (3/6) - Preparing for Installations of Grid and RAC
How to Build 12c RAC (2/6) - Building Two Servers for RACby Ed ChenSeptember 20, 2015February 13, 20232 CommentsHow to Build 12c RAC (1/6) - Building a NAS for Shared Storage of RAC Two nodes cluster database for RAC is a very typical… Read More »How to Build 12c RAC (2/6) - Building Two Servers for RAC