Public IP

How to Add a Public IP Address to Grid

Posted on
Strictly speaking, adding a public IP to server at OS-level is no problem, but you can’t add any public IP to join any node of RAC at grid-level, because the clusterware must determine the public IP by resolving hostname of its node at startup-time. You can only replace it. There’re two possible scenarios of changing […]
SCAN IP

How to Add a SCAN VIP to Grid

Posted on
Looking up SCAN name on DNS before adding a SCAN VIP[root@primary01 ~]# nslookup primary-cluster-scanServer:         10.0.0.199Address:        10.0.0.199#53Name:   primary-cluster-scan.example.comAddress: 10.0.0.82Name:   primary-cluster-scan.example.comAddress: 10.0.0.81Name:   primary-cluster-scan.example.comAddress: 10.0.0.83There’re 3 SCAN VIPs for this name.Adding a SCAN VIP to DNS[root@dns ~]# cd /var/named/[root@dns named]# vi example.com.zone[root@dns named]# vi 0.10.zone[root@dns named]# systemctl restart […]
Listener

How to Resolve TNS-01106: Listener using listener name listener has already been started

Posted on
TNS-01106 I setup multiple listeners to listen different databases in listener.ora, but when I tried to start the LISTENER2, I got TNS-01106 like this: [grid@primary01 ~]$ lsnrctl start listener2 … TNS-01106: Listener using listener name listener has already been started Rationale: Key Name Collision I know LISTENER is running, but how could it be relavent […]
Public IP

How to Change Public IP within Same Subnet of Grid

Posted on
Identify which interface that you should modify[grid@oda0 ~]$ oifcfg getif -globalbond0  10.0.18.0  global  publicibbond0  192.168.2.0  global  cluster_interconnect,asmOK, we found bond0 is the public IP interface.Modify /etc/sysconfig/network-scripts/ifcfg-bond0[root@oda0 ~]$ vi /etc/sysconfig/network-scripts/ifcfg-bond0…IPADDR=10.0.18.5#IPADDR=10.0.18.218…Modify /etc/hosts and DNS[root@oda0 ~]$ vi /etc/hosts…10.0.18.5    oda0 oda0.example.com#10.0.18.218    oda0 oda0.example.comRestart network[root@oda0 ~]$ service network restartYou may lost connection to the console.Restart clusterware stack by […]
Listener

How to Resolve The listener supports no services

Posted on
The Listener Supports Services
The listener supports no services I newly created a database called SMALLDB, but I can’t see any service registered with the new LISTENER2 which is listening to incoming connections from port 1522. The listener showed “The listener supports no services”. This message tells us that the listener is working fine, but no service registers with […]
Oracle Instant Client

How to Install Oracle Instant Client

Posted on
The term “install” may be a little improper for Oracle Instant Client, because the packages are all zipped and portable, there’s no need to actually install on OS-level. Let’s see what the official document says about the steps:Download the appropriate Instant Client packages for your platform. All installations require the Basic or Basic Lite package.That […]
Database

What Symbols are Used in Oracle Database

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

How to Change Subnet of Grid

Posted on
Oracle 12c uses 4 types of IP addresses to configure network of RAC:Public IPPrivate IPVirtual IPSCAN IPIn which, Public IP, Virtual IP and SCAN IP are in the same subnet. Up to 4 pairs of Private IP can be set in RAC, which should be in another subnet and used for interconnect redundancy to secure […]