Oracle Home

How to Move ORACLE HOME

Posted on
Allow me to ask you a question before going further: why would you like to move ORACLE HOME to another place? You may leave your comment below this post, I am curious about it. As for me, it’s because my client like old-fashioned file structure and don’t like Optimal Flexible Architecture (OFA) to be used, […]
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 […]
Linux

How to Change Primary Group of a User in Linux

Posted on
Change Primary Group In our case, there’s a user called oracle who has identification like following: [root@test ~]# id oracle uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba) I would like to change the primary group to dba and let oinstall join the secondary group. That is to say, my purpose is to switch the places of dba and oinstall. […]
WebLogic

How to Patch WebLogic Server

Posted on
Patch WebLogic Server First of all, you have to update OPatch to the newest one for Fusion Middleware, then start to patch your WebLogic server. Here are the steps: Check Current Version before Patching WebLogic Server Several ways that can check current version of WebLogic server. The first way is to use WebLogic Scripting Tool […]
WebLogic

How to Update Opatch in Oracle Fusion Middleware

Posted on
Update OPtach of Weblogic In order to patch Weblogic server 12.2.1.3 and later on, we have to upgrade OPatch utility first. Specifically, upgrade OPatch from 13.9.2.0.0 to 13.9.4.0.0. New Replacing Process Historically, OPatch was updated by unzipping and replacing ORACLE_HOME/OPatch directory. For versions greater than or equal to 13.6, it now uses the OUI installation […]
Data Dictionary View

How to Find Largest Segments in Oracle

Posted on
Find Largest Segments A segment in Oracle database is a set of extents that contains all the data for a specific logical storage structure within a tablespace. Which means segments contain not only metadata but real data. Normally, segments include tables, indexes and large objects, etc. Let’s see what largest segments are in our database. […]
WebLogic

How to Install WebLogic Server 12c

Posted on
Install WebLogic Server 12.2.1.3 Create Necessary User and Group [root@weblogic ~]# groupadd -g 54321 oinstall [root@weblogic ~]# useradd -u 54321 -g oinstall oracle [root@weblogic ~]# passwd oracle Changing password for user oracle. New password: Retype new password: passwd: all authentication tokens updated successfully. [root@weblogic ~]# id oracle uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall) Create Oracle Home for Middleware […]
RAC

How to Build 18c RAC – 4 of 4 – Creating a RAC Database

Posted on
How to Build 18c RAC – 3 of 4 – Installing Database Software on All Nodes Create a RAC Database Check All Grid Services Make sure everything is ready on grid-level. [grid@primary01 ~]$ crsctl status resource -t ——————————————————————————– Name           Target  State        Server              […]
RAC

How to Build 18c RAC – 3 of 4 – Installing Database Software on All Nodes

Posted on
How to Build 18c RAC – 2 of 4 – Installing Grid Infrastructure Install Database Software Upload and Unzip Source on Node 1 Please note that, you should upload and unzip the software source in ORACLE_HOME because Oracle database starts to use image-based installation since 18c. > cd d:/oracle > sftp oracle@192.168.10.11:/u01/app/oracle/product/18.0.0/db_1 Connected to 192.168.10.11. […]