Creating Cloud Trail in AWS Cloud and sending logs to CloudWatch amazing !

1.. Login to AWS Cloud Account and in AWS Management Console search for CloudTrail 2.. Once selected on CloudTrail and Trails, click on the Create Trail 3.. For your Trail give information as given below Trail Name = DEMO_TRAIL Apply trail to all regions = YES or NO 4.. Management events For Management events select … Continue reading Creating Cloud Trail in AWS Cloud and sending logs to CloudWatch amazing !

Create a CloudWatch Alarm Based on a CloudWatch Metric in AWS

1.. Login to amazon cloud console and in Service Dashboard search for Alarm or directly click on CloudWatch down below the service dashboard. 2.. Select Alarm at the Left Navigation pane window and click on Create Alarm. 3.. Under Metric Tab click on Select Metric. 4.. Choose the service namespace that contains the metric you … Continue reading Create a CloudWatch Alarm Based on a CloudWatch Metric in AWS

Querying files on the Oracle Cloud Infrastructure Object Storage (OCI) directly without loading them to your database aka querying Data in External Files

1.. Create External Tables with DBMS_CLOUD :- Connect with SQL Developer and use given below scripts to create external table. In this case we will use the create_external_table procedure of the DBMS_CLOUD package to create external tables on the files staged in object store. Given below credential are same as we did it for OCI_OBJECT_UPLOAD … Continue reading Querying files on the Oracle Cloud Infrastructure Object Storage (OCI) directly without loading them to your database aka querying Data in External Files

Create Load Balancer in Oracle Cloud Infrastructure !!!

1.. Login with Oracle Cloud account and Create Virtual Cloud Network VCN: - LB_VCN CIDR Block: 10.0.0.0/16 Compartment: - DEMO1 2.. Creating Two Web Servers :- Go to Compute Tab and create two Instances for eg. Webserver1 and Webserver2 While creating instance select different AD as given below for high Availability For Webserver1 :- Availability … Continue reading Create Load Balancer in Oracle Cloud Infrastructure !!!

Roll Back Applied patch in Oracle Cloud Database as Service #interesting

Here in given below screen shot. Now available patch is only one ie. 27338049-EE. To roll back patch either only particular patch can be rollback or entire patch can be rollback. To roll back particular patch, you can enter that particular patch number in dbpatchm.cfg file Syntax to Roll back Patch:- After rolling back applied … Continue reading Roll Back Applied patch in Oracle Cloud Database as Service #interesting

Patching Oracle Cloud Database as Service with dbaascli Utility #awesome

In Oracle Database as Cloud Service, For Oracle Database Patching can be done in two ways.Either from front end or backend using command line interface as OPatch utility but not same as it is. In Oracle Database as cloud Service, you have utility called dbaascli and dbpatchm (subcommand). With this utility you can precheck patch, … Continue reading Patching Oracle Cloud Database as Service with dbaascli Utility #awesome

ORA-12154: TNS:could not resolve the connect identifier specified

In Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 , when you try to login any PDB (pluggable database) then you may face as given below error. Error:- SQL> conn gg2/gg2@PDBGG2; (gg2 is user created for PDB,PDBGG2) ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Solution:- 1.. Make sure your pluggable databse is open if … Continue reading ORA-12154: TNS:could not resolve the connect identifier specified

ORA-00333: redo log read error block count

SQL> startup ORACLE instance started. Total System Global Area ***** bytes Fixed Size ***** bytes Variable Size ***** bytes Database Buffers ***** bytes Redo Buffers ***** bytes Database mounted. ORA-00333: redo log read error block *Number* count *Number* Step 1: As the Database is in mount mode, query v$log & v$logfile to identify the status … Continue reading ORA-00333: redo log read error block count

Oracle Database scripts to check health of Oracle Database. Scripts can be crontab schedule !!!!

#!/bin/bash #===================================================================================================================================# #BELOW STATMENTS CHECKING Prod HRMS DATABASE SERVER BASED ON CONDITION OF SMON #=====================================================================================================================================# #echo $ORACLE_SID #export ORACLE_SID=PROD SID=PROD smonchk=ora_smon ps -ef | grep -v 'grep' | grep ${smonchk}_$SID if [ $? -eq 0 ]; then echo "$SID Oracle HRMS Database Server is up and running !! " | mail -s "Status of Production … Continue reading Oracle Database scripts to check health of Oracle Database. Scripts can be crontab schedule !!!!