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:
 

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

1z0-1072-21 | Oracle Cloud Infrastructure 2021 Architect Associate - Part 6

 Q250. What is the default performance level when block volume is created in OCI?  

A.       Archive

B.       Balanced

C.       Higher Performance

D.       Ultra-High Performance 

Answer: B

 

Q251. Which statements are CORRECT about OCI Object Storage? (Choose TWO) 

A.       They are not tied to any specific compute instance and are regional service

B.       Private access is supported via service gateway for OCI resources

C.       Default tier is archive

D.       Data is not durable 

Answer: A, B

 

Q252. In OCI File Storage, which FOUR layers of access control are used? 

A.       OCI Policy

B.       Network Security

C.       Key Management

D.       NFS v.3 Unix Security

E.       NFS export option 

Answer: A, B, D, E

 

Q253. A company wants to run OLTP and OLAP workloads directly from MySQL database without any changes to the applications wo that there is no need for separate analytics database. 

Which MySQL database future will help you to achieve this? 

A.       Heatwave

B.       Redis

C.       Memcached

D.       Oracle Exalogic 

Answer: A

 

Q254. A company has 2 objects in OCI bucket: Object A and Object B. Object A was modified 17 months ago and Object B was modified 5 months ago. As a Solution Architect, you created a retention rule for 12 months. Which TWO statements are TRUE 

A.       Object A can be deleted or modified immediately

B.       Object A cannot be deleted or modified for next 5 months

C.       Object B can be deleted or modified immediately

D.       Object B cannot be deleted or modified for next 7 months 

Answer: A, D

 

Q255. Select the CORRECT statements about Oracle Vulnerability Scanning which it can identify. Select THREE correct answers 

A.       Potential OS configuration which hackers might exploit

B.       Ports which are left open

C.       SQL injection

D.       OS packages that require patches to tackle vulnerabilities 

Answer: A, B, D

 

1z0-1072-21 | Oracle Cloud Infrastructure 2021 Architect Associate - Part 5

Q200. You are a network architect and have designed the network infrastructure of a three-tier application on Oracle Cloud Infrastructure (OCI). In the architecture, back-end DB servers are in a private subnet. One of your DB administrators requests to have access to OCI object storage service. 

How can you meet this requirement? 

A.       Create a service gateway, add a new route rule to the private subnet route table that uses object storage as your service gateway target type

B.       Create a dynamic routing gateway (DRG) and attach it to your virtual cloud network (VCN). Add a default route rule to the private subnets route table and set the target as DRG

C.       Attach a public IP address to the instances in the private subnet, and then add a new route rule to the private subnet route table to route default traffic to the internet gateway

D.       Add a new route rule to the private subnet route table to route default traffic to the internet gateway 

Answer: A

 

Q201. You are about to deploy an E-Business application on Oracle Cloud Infrastructure and one of the requirements is to use a shared file system that supports the NFS protocol. 

Which storage service would meet this requirement? 

A.       object storage

B.       block volume

C.       data transfer appliance

D.       file storage 

Answer: D

 

Q202. You have just created an Autonomous Data Warehouse (ADW) and you want to connect to the ADW using SQL Developer. What three items are needed to connect to the ADW using SQL Developer? (Choose three.) 

A.       the keystore password

B.       a security list with an ingress rule for TCP port 1521

C.       the client credentials file

D.       the public IP address of the ADW server

E.       the admin password 

Answer: A, C, E

 

Q203. You are planning to deploy a multi-region web application in Oracle Cloud Infrastructure (OCI). You have customers in North America, Asia and Europe who will access the application. 

What service is available in OCI to help you choose the regions with the lowest latency to these markets? 

A.       Internet Intelligence

B.       FastConnect

C.       IPsec VPN

D.       DNS Zone Management 

Answer: A

 

Q204. Which two options are valid for loading data directly into Autonomous Data Warehouse (ADW)? (Choose two.) 

A.       Data Integrator

B.       Data Pump

C.       Data Transfer Service

D.       SQL*Loader 

Answer: B, D

 

Q205. Your company is developing a new database application in Oracle Cloud Infrastructure. You need to test application functionality including a hardware failure scenario. Since the application is still in the development phase, you want to minimize infrastructure costs. 

Which database service deployment option meets this requirement? 

A.       two node real application cluster (RAC) system

B.       Autonomous Data Warehouse (ADW) system as it provides auto fail over functionality

C.       two node bare metal system with data guard enabled

D.       single node bare metal system 

Answer: B

 

1z0-1072-21 | Oracle Cloud Infrastructure 2021 Architect Associate - Part 4

 Q150. What does Terraform use to create, manage, and manipulate infrastructure resources? 

A.       Resources

B.       Provisioner

C.       Instances

D.       Provider 

Answer: D

 

Q151. Which statement is true regarding Autonomous Transaction Processing (ATP)? 

A.       A database name cannot be used concurrently for both an Autonomous Data Warehouse (ADW) and an ATP database

B.       A maximum of 2 TB of storage can be enabled for an ATP database

C.       After terminating a database, the database name is available for immediate reuse

D.       A maximum of 8 cores can be enabled for an ATP database 

Answer: A

 

Q152. Where do you find the tnsnames.ora for your Autonomous Data Warehouse (ADW) database? 

A.       You can download tnsnames.ora from Oracle Cloud Infrastructure web console under ADW details page

B.       The tnsnames.ora file is included in credentials.zip file that you download from service console of ADW

C.       The ADW database will place the tnsnames.ora file in an object storage bucket

D.       You are automatically prompted to download the tnsnames.ora file upon creation of the ADW database

Answer: B

 

Q153. You have a shared file system between two web servers using File Storage Service (FSS) and you were tasked to create a backup plan for this environment to protect the data placed into the shared file system. 

What is the recommended approach to create this backup using FSS features? 

A.       Implement a backup policy to execute a snapshot of the shared volume.

B.       Implement a backup policy to copy data from the shared volume to object storage.

C.       Compress the data that is in the shared volume and copy it into a different folder on the boot volume disk.

D.       Use the rsync tool to send data from the shared volume to a boot volume disk.

E.       Use the rsync tool to send data from the shared volume to a block volume. 

Answer: A 

Q154. Which two parameters are required in a back end set's HTTP health check? (Choose two.) 

A.       response body

B.       URL path

C.       timeout

D.       port

E.       status code 

Answer: B, D

 

Q155. Which two configuration formats does Terraform support? (Choose two.) 

A.       YAML

B.       JSON

C.       HCL

D.       XML 

Answer: B, C 

1z0-1072-21 | Oracle Cloud Infrastructure 2021 Architect Associate - Part 3

 Q100. Which statement is true about cloning a volume?

A.       You need to detach a volume before cloning from it.

B.       A cloned volume is the same as a snapshot that has a dependency on the source volume.

C.       You can change the block volume size when cloning a volume.

D.       You can create a clone for a volume across regions.

Answer: C

Q101. Which two actions will occur when a back-end server that is registered with a backend set is marked to drain connections? (Choose two.)

A.       It disallows new connections to that backend server.

B.       It keeps the connections to that instance open and attempts to complete any in-flight requests.

C.       It redirects the requests to a user-defined error page.

D.       It immediately closes all existing connections to that instance.

E.       It forcibly closes all connections to that instance after a timeout period.

Answer: A, B

Q102. Which two statements are true about subnets within a VCN? (Choose two.)

A.       You can have multiple subnets in an Availability Domain for a given VCN.

B.       Private and Public subnets cannot reside in the same Availability Domain for a given VCN.

C.       Subnets can have their IP addresses overlap with other subnets in another network for a given VCN.

D.       Instances obtain their private IP and the associated security list from their subnets.

Answer: A, D

Q103. Your on-premises hosted application uses Oracle database server. Your database administrator must have access to the database server for managing the application. Your database server is sized for seasonal peak workloads, which results in high licensing costs. You want to move your application to Oracle Cloud Infrastructure (OCI) to take advantage of CPU scaling options.

Which database offering on OCI would you select?

A.       bare metal DB systems

B.       VM DB systems

C.       Autonomous Transactions Processing (ATP)

D.       Autonomous Data Warehouse (ADW)

Answer: A

Q104. Which three actions are required to configure a highly available and secure hybrid network between Oracle Cloud and your data center? (Choose three.)

A.       Define a non-overlapping IP Address Space between the data center and the cloud.

B.       Configure each of the CPEs to leverage each of the IPSec Tunnels created by the connection process.

C.       Create two or more CPEs that map to the private IP addresses of the customer routers used in the IPSec VPN Tunnel.

D.       Define a default route table entry for the VCN that directs all traffic to the data center network to a single DRG.

E.       Create dynamic routing gateways in more than one AD within your region.

Answer: A, B, C

Q105. Which two statements are true about Database Cloud Service (DBCS)? (Choose two.)

A.       Data Guard as a Service is offered among regions.

B.       You have full control over backup schedule and retention.

C.       You can manage Oracle parameters at a global system level.

D.       You cannot manage the database as sys/sysdba.

Answer: B, C