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, […]
Linux

How to Build 18c RAC – 1 of 4 – Preparing Two Database Servers

Posted on
Network Design for RAC Let’s see the network design of our cluster database. [root@primary01 ~]# vi /etc/hosts # Public 192.168.10.11 primary01 primary01.example.com 192.168.10.12 primary02 primary02.example.com # Private 192.168.24.11 primary01-priv primary01-priv.example.com 192.168.24.12 primary02-priv primary02-priv.example.com # VIP 192.168.10.111 primary01-vip primary01-vip.example.com 192.168.10.112 primary02-vip primary02-vip.example.com # SCAN # 192.168.10.81 primary-cluster-scan primary-cluster-scan.example.com # 192.168.10.82 primary-cluster-scan primary-cluster-scan.example.com # 192.168.10.83 primary-cluster-scan primary-cluster-scan.example.com […]
Oracle Client

TNS_ADMIN, How and Why

Posted on
Oracle Software Registry For those Windows platform which are running Oracle, ORACLE_HOME, ORACLE_BASE and TNS_ADMIN are not set as environment variables. That is, you can find them nowhere in Environment Variables editor. In fact, they are registry parameters. You can call regedit to open a Registry Editor and then seek for the following path: Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME […]