debasis maity

12+ years of rich experience on Database Administrations and on Infrastructure Solution Architect. AWS Certified Solution Architect and Senior Oracle DBA
158

debasis maity 's Posts

Please check pre-requisites first You need to run the following command to check latest available patch dbaascli dbpatchm –run -list patches You may patch to be applied from dataguard side as well Please go to database console and check the Administration section Please run the prereq now for checking all… Continue Reading Oracle DBaaS 1z0-160 part 21 :- Patching in dataguard oracle cloud

Please select the “Single Instance with Data Guard Standby” as Database Type in drop down. –> High Availability—The standby database is placed in a different availability domain from the primary database, thus providing isolation at the infrastructure level. –> Disaster Recovery—The standby database is placed in a different data center from the primary… Continue Reading Oracle DBaaS 1z0-160 part 20 :- Dataguard Setup for Single Instance in oracle cloud

Patching from DB console 1.Please select highlighted option for checking availability patches using DB Console 2.Please check using “Precheck” option 3.PreCheck result may fail due to below errors 4.Upgrade the DBPATCHM version from server to make precheck successful [root@ORCL dbpatchm]# rpm -qa|grep -i dbaastools dbaastools-1.0-1+18.1.4.0.0_180123.1336.x86_64 [root@ORCL dbpatchm]# dbaascli dbpatchm –run… Continue Reading Oracle DBaaS 1z0-160 part 18:- Patching single instance in oracle cloud

The following points need to be considered when you add new storage volume. A compute node can have a maximum of ten storage volumes attached to it. You can create a storage volume from 1 GB to 2048 GB in size, in increments of 1 GB. If the database deployment… Continue Reading Oracle DBaaS 1z0-160 part 16 :-Attach storage volume to the node from compute classic

You also have option to Extend Data Storage volume without creating new volume Once the extend operations complete,you can see your existing storage mount point will be increase.

Scale up storage consideration When creating a database deployment on Oracle Database Cloud Service, you choose the amount of usable data storage you want for your database. You can create a database of up to 1200 GB with backups to both cloud and local storage or up to 2048 GB… Continue Reading Oracle DBaaS 1z0-160 part 14: Adding temporary storage/Scale up storage

[oracle@ORCL admin]$ dbaascli database changepassword DBAAS CLI version 1.0.0 Executing command database changepassword Enter username whose password change is required: system Enter new  password: Re-enter new password: Successfully changed the password for user system [oracle@ORCL admin]$ sqlplus system/Bppimt#123@orcl SQL*Plus: Release 12.1.0.2.0 Production on Tue Mar 27 12:03:55 2018 Copyright (c)… Continue Reading Oracle DBaaS 1z0-160 part 13:Changing sys/system password in Oracle cloud

On database deployments hosting a single-instance database, Oracle Database Cloud Service supports the creation of storage snapshots, which you can then use to create new database deployments called linked clones. When you create a storage snapshot, the database deployment is put into maintenance status and a snapshot of all the… Continue Reading Oracle DBaaS 1z0-160 part 12:Clone Oracle cloud database using Snapshot