Task 7: Verifications for Connectivity, Metrics and Billing for Oracle Database@AWS
This topic explains the required steps to verify connectivity, metrics and billing for Oracle Database@AWS.
Note
The resources you create are only for testing purposes. It is crucial that these resources are deleted after testing to avoid incurring charges. If you fail to remove these resources, it may result in additional costs.
The resources you create are only for testing purposes. It is crucial that these resources are deleted after testing to avoid incurring charges. If you fail to remove these resources, it may result in additional costs.
Note
Make sure that you create the EC2 instance in the same VPC which is peered with the ODB network to avoid having invalid inputs. For additional information, see Getting Started with Amazon EC2.
Make sure that you create the EC2 instance in the same VPC which is peered with the ODB network to avoid having invalid inputs. For additional information, see Getting Started with Amazon EC2.
Verifications for Connectivity
Create AWS EC2 Instance
Learn how to create AWS EC2 Instance.
- From the Amazon Web Services dashboard, select EC2 Dashboard, and then select Launch instance.
- Follow these steps to set up an instance:
- Enter an unique Name and tags for your instance.
- From Amazon Machine Image (AMI) list, select AMI that is marked Free Tier eligible.
- For your selected Amazon Machine Image (AMI), select your Architecture from the dropdown list.
- From the Instance type dropdown list, select
t2.micro. - Before you launch the instance, select the Key pair name from the dropdown list.
Note
You must choose an existing Key pair or choose to Create new key pair. If you select to proceed without a key pair, you will not be able to connect to your instance. - From the network settings section, select your VPC, then Subnet from the dropdown list.
- For Auto-assign public IP, select the Enable option.
- For Firewall (security groups), you can either choose Create security group or choose Select existing security group.
- The Common security groups is selected by default.
Note
It is recommended that you use the default settings. - Review your instance configuration from the Summary section, and then click on the Launch instance button.
- After the provisioning process completes, from the Instances, click on the Connect button.
- From the Connect to instance section, select the SSH client and copy the command.
Update Network Security Groups (NSGs)
Note
If you want to perform a ping test, then you need to perform the following steps as described below.
If you want to perform a ping test, then you need to perform the following steps as described below.
- From the OCI console, navigate to Networking, and then select Virtual Cloud Networks.
- Click the name of the VCN where your Exadata VM Cluster is provisioned, and then select Network Security Groups to view details of it.
- Click on the Add Rules button located under the Security Rules section to create an Igress rule with ICMP type 8, which will enable Ping. For more information, see Rules to Enable Ping.
Connectivity Tests
Learn how to test the connectivity by following described methods.
- Exadata VM Cluster Scan IP Ping Test
- DNS Listener Ping Test
- Virtual Machine Private IP Ping Test
- SQLPlus Database Connectivity Test
Exadata VM Cluster Scan IP Ping Test
Note
The prerequisite for this test is to configure DNS. For more information, see Amazon Route 53 Documentation, and Creating outbound endpoints.
The prerequisite for this test is to configure DNS. For more information, see Amazon Route 53 Documentation, and Creating outbound endpoints.
- From the Amazon Web Services dashboard, select the Oracle Database@AWS.
- From the left menu, select Exadata VM Cluster.
- Select the OCI resources tab, and then from the Virtual machines section, copy your SCAN DNS name.
- From the EC2 instance, ping the SCAN DNS name.
DNS Listener Ping Test
Note
The prerequisite for this test is to enable and manage EC2 Internet Access. For more information, see Configuration for internet access , and Create an internet gateway.
The prerequisite for this test is to enable and manage EC2 Internet Access. For more information, see Configuration for internet access , and Create an internet gateway.
- From the Amazon Web Services dashboard, select the Oracle Database@AWS.
- From the left menu, select ODB networks, and then select the name of the ODB network that you are interested in.
- Select the Summary tab to get details of your DNS listener IP.
- From the EC2 instance, ping the DNS listener IP.
Virtual Machine Private IP Ping Test
Note
The prerequisite for this test is to enable and manage EC2 Internet Access. For more information, see Configuration for internet access , and Create an internet gateway.
The prerequisite for this test is to enable and manage EC2 Internet Access. For more information, see Configuration for internet access , and Create an internet gateway.
- From the OCI console, navigate to Exadata VM Cluster.
- Select the name of Exadata VM Cluster to view details of it.
- Form the Resources section, select Virtual Machines, and then copy your Private IP address and DNS name by clicking on the Copy link.
- From the EC2 instance, ping the Private IP address.
SQLPlus Database Connectivity Test
Note
The prerequisite for this test is to enable and manage EC2 Internet Access. For more information, see Configuration for internet access , and Create an internet gateway.
The prerequisite for this test is to enable and manage EC2 Internet Access. For more information, see Configuration for internet access , and Create an internet gateway.
- To install SQLPlus in the EC2 instance, see How to Install SQLplus on Linux?.
Connect to Exadata Database
Learn how to connect to Exadata Database.
- From the OCI console, select Oracle Exadata Database Service on Dedicated Infrastructure.
- Select Exadata VM Cluster, and then click the name of your Exadata VM Cluster that you are interested in.
- Select the DB connection tab and from the Database Connection window, make sure that you have the Long connection string and the password you used while creating the database.
- From the EC2 instance, run the following command.
For example:sqlplus sys/PASSWORD_GOES_HERE@'LONG_CONNECTION_STRING_GOES_HERE as sysdba'sqlplus SYS/password'(DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.27)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.172)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.123)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=smmDb_j87_iad.client.zvveulc0j.oraclevcn.com))) as sysdba' - After the connection, run the following command.
SELECT name FROM v$database; - After running the command, make sure that the name must match with the name of your database.
Verifications for Metrics
- After provisioning Exadata Database, from the Amazon Web Services dashboard, select the Oracle Database@AWS.
- From the left menu, select Exadata VM Cluster.
- Select the Summary tab, and then from the Virtual machines section, select the Monitoring tab. Make sure that you can see and track metrics.
- To see metrics using Amazon CloudWatch, navigate to the Amazon Web Services Management console, and then select CloudWatch from the left menu.
- From the navigation menu. choose Metrics.
Verifications for Billing
Note
It might take up to 24 hours for an hourly billing record sent by OCI to be reflected in the AWS Billing console of the customer. Once this update period has elapsed, we can verify the billing by following the steps described below.
It might take up to 24 hours for an hourly billing record sent by OCI to be reflected in the AWS Billing console of the customer. Once this update period has elapsed, we can verify the billing by following the steps described below.
- From the Amazon Web Services dashboard, navigate to the Billing and Payments section, and then select the Bills tab.
- You can view your bill by selecting the billing month and scrolling down to Marketplace charges or you can navigate to the Cost Explorer section, and then select your Date Range and Granularity.