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

How to Add Static Service Registered in Listener

Posted on
Static Service Registration Dynamic service is a representative which is registered with the listener when the instance is up and running on the server, whereas static service can be used to service external connections with or without a running instance on the server. According to Oracle 18c Advanced Features of Oracle Net Services, the use […]
Oracle Client

TNS_ADMIN, How and Why

Posted on
TNS_ADMIN in Oracle Software Registry For those Windows platform which are running Oracle server or client(s), you should know some facts of Oracle important parameters, 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 […]
Startup and Shutdown

How to Resolve ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener

Posted on
ORACLE_HOME_LISTNER is not SET Got this error when I used dbstart to startup all required instances: ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener. This is because dbstart takes the first argument of this command as the database home path for listener to startup. Which means, this command will start both database and […]
Administration

How to Know Everything about an Unfamiliar Database

Posted on
In an unfamiliar environment, if there’s only oracle or grid account is available for DBA to use, how can he to know everything about the database in a short time?StandaloneFor a standalone, you can do this:Oracle Home[oracle@test ~]$ echo $ORACLE_HOME/u01/app/oracle/product/11.2.0Oracle SID (Instance Name)[oracle@test ~]$ echo $ORACLE_SIDORCLIf there’s no $ORACLE_SID, you may check smon, the background process […]
Database

What Symbols are Used in Oracle Database

Posted on
Several symbols that are used in Oracle might represent different meanings in different place. Question mark ? ORACLE HOME ? (a Question Mark) in a path string represents the environmental variable of ORACLE_HOME. It’s usually $ORACLE_HOME in UNIX or Linux, %ORACLE_HOME% in Windows. SQL> alter tablespace temp add datafile ‘?/dbs/temp02.dbf’ size 200M; You may also […]
Oracle Home

How to Resolve Message 3511 not found

Posted on
Message 3511 not found Recently, I upgraded my PC from Windows XP to Windows 7 at my working place. For reusing installed Oracle Client 9.2.0, a pretty old Java application, I took several steps to recover it, but I got Message 3511 not found eventually. First, I set an environment variable Path for Oracle Client […]