Showing posts with label Oracle RAC. Show all posts
Showing posts with label Oracle RAC. Show all posts

Thursday, September 29, 2022

How to Create Additional SCAN

Note: This demo bases on the environment in previous post. You can check here.

1. Get current information
 
[grid@saigon-01 ~]$ oifcfg getif
enp0s3  192.168.56.0  global  public
enp0s8  192.168.89.0  global  cluster_interconnect,asm
 
[grid@saigon-01 ~]$ srvctl config network
Network 1 exists
Subnet IPv4: 192.168.56.0/255.255.255.0/enp0s3, static
Subnet IPv6:
Ping Targets:
Network is enabled
Network is individually enabled on nodes:
Network is individually disabled on nodes:
 
[grid@saigon-01 ~]$ srvctl config scan -all
SCAN name: saigon-scan, Network: 1
Subnet IPv4: 192.168.56.0/255.255.255.0/enp0s3, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 192.168.56.55
SCAN VIP is enabled.
SCAN 2 IPv4 VIP: 192.168.56.66
SCAN VIP is enabled.
SCAN 3 IPv4 VIP: 192.168.56.77
SCAN VIP is enabled.
 
[grid@saigon-01 ~]$ srvctl config scan_listener -all
SCAN Listeners for network 1:
Registration invited nodes:
Registration invited subnets:
Endpoints: TCP:1521
SCAN Listener LISTENER_SCAN1 exists
SCAN Listener is enabled.
SCAN Listener LISTENER_SCAN2 exists
SCAN Listener is enabled.
SCAN Listener LISTENER_SCAN3 exists
SCAN Listener is enabled.
 
[grid@saigon-01 ~]$ srvctl config listener -all
Name: LISTENER
Type: Database Listener
Network: 1, Owner: grid
Home: <CRS home>
  /u01/app/21.0.0/grid on node(s) saigon-02,saigon-01
End points: TCP:1521
Listener is enabled.
Listener is individually enabled on nodes:
Listener is individually disabled on nodes:
 

Friday, September 23, 2022

Oracle RAC 21c Installation on VirtualBox

1. Preparation


2. Install packages (on 2 nodes)

# dnf -y install oracle-database-preinstall-21c
# cd /etc/sysctl.d/
# ls -ltr

-rw-r--r--. 1 root root  449 Sep 16 12:26 99-initial-sysctl.conf
-rw-r--r--. 1 root root 1966 Sep 16 12:26 99-oracle-database-preinstall-21c-sysctl.conf

3. Config /etc/hosts on 2 nodes 

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
 
192.168.56.11   saigon-01.south.com     saigon-01
192.168.56.22   saigon-02.south.com     saigon-02
 
192.168.56.33   saigon-01-vip.south.com     saigon-01-vip
192.168.56.44   saigon-02-vip.south.com     saigon-02-vip
 
192.168.89.11   saigon-01-priv.south.com     saigon-01-priv
192.168.89.22   saigon-02-priv.south.com     saigon-02-priv
 
 192.168.56.55   saigon-scan.south.com      saigon-scan
192.168.56.66   saigon-scan.south.com      saigon-scan
192.168.56.77   saigon-scan.south.com      saigon-scan

4. Disable SELINUX on 2 nodes

# vi /etc/selinux/config


SELINUX=disabled