Oracle DBaaS 1z0-160 part 13:Changing sys/system password in Oracle cloud

[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) 1982, 2014, Oracle.  All rightsContinue reading Oracle DBaaS 1z0-160 part 13:Changing sys/system password in Oracle cloud

Oracle DBaaS 1z0-160 part 12:Clone Oracle cloud database using Snapshot

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 storage volumes for the deploymentContinue reading Oracle DBaaS 1z0-160 part 12:Clone Oracle cloud database using Snapshot

Oracle DBaaS 1z0-160 part 11: Starting and Stopping Oracle Database deployment

What happens when you stop database in Oracle cloud When you stop a Database Cloud Service database deployment, no access to it is possible and you can perform no management operations on it except to start it or to delete it. Stopping a database deployment is similar to turning off your personal computer: it hasContinue reading Oracle DBaaS 1z0-160 part 11: Starting and Stopping Oracle Database deployment

Oracle DBaaS 1z0-160 part 10 :VNC setup to connect directly to Oracle cloud database VM

1.Please install tigervnc-server using yum and create VNC user and password [root@ORCL ~]# yum install tigervnc-server xorg-x11-fonts-Type1 [root@ORCL ~]# useradd elinuxbook [root@ORCL ~]# passwd elinuxbook [root@ORCL ~]# su – elinuxbook [elinuxbook@ORCL ~]$ vncpasswd 2.Configure display to proper resolution and user “elinuxbook” [root@ORCL ~]#vi /etc/sysconfig/vncservers # VNCSERVERS=”2:myusername” # VNCSERVERARGS[2]=”-geometry 800×600 -nolisten tcp -localhost” VNCSERVERS=”1:elinuxbook” VNCSERVERARGS[1]=”-geometry 1440×900″Continue reading Oracle DBaaS 1z0-160 part 10 :VNC setup to connect directly to Oracle cloud database VM

Oracle DBaaS 1z0-160 part 9:Enabling access to compute node using access rules and directly connect using 1521 to oracle cloud instance

Enabling access to compute node using “access rules” For database deployments created in Oracle Cloud Infrastructure Classic, Oracle Database Cloud Service uses access rules to provide secure network access to database deployments. You can use the Oracle Database Cloud Service console to perform network access operations such as enabling and disabling access rules and creatingContinue reading Oracle DBaaS 1z0-160 part 9:Enabling access to compute node using access rules and directly connect using 1521 to oracle cloud instance

Oracle DBaaS 1z0-160 part 8:How to connect your oracle cloud database from 1521 port using sql developer/TOAD

SSH tunneling to access port 1521 This assumes your port 1521 is not open.First you need to Load the putty session you saved in previous case(to enable SSH access).In the Category tree, click Tunnels. The Tunnels panel is displayed.   In the Source Port box, enter the number of an available port on your system.Continue reading Oracle DBaaS 1z0-160 part 8:How to connect your oracle cloud database from 1521 port using sql developer/TOAD

Oracle DBaaS 1z0-160 part 7:Connecting you Oracle cloud database server using SSH

Please identify public IP Configure SSH connectivity: In Host Name (or IP address) box, enter the IP address of the target compute node. Confirm that the Connection type option is set to SSH. In the Category tree, expand SSH and then click Auth. The Auth panel is displayed. Click the Browse button next to theContinue reading Oracle DBaaS 1z0-160 part 7:Connecting you Oracle cloud database server using SSH

Oracle DBaaS 1z0-160 part 6:Creating you first single instance database in Oracle cloud

1.You will get following dashboard once you login to oracle cloud 2.Please select Database option as below 3.Please select option “Custom” 4.Please provide below details 4.a Instance Name:- The name for the new database deployment. The name: Must not exceed 50 characters. Must start with a letter. Must contain only letters, numbers, or hyphens. MustContinue reading Oracle DBaaS 1z0-160 part 6:Creating you first single instance database in Oracle cloud

Oracle DBaaS 1z0-160 part 5:-OS account in cloud ( OPC,ORACLE,GRID,ROOT)

Different OS user account details User Description OPC The system administrator account you use to connect to the compute node using SSH. This user can use the sudo command to perform operations that require root-user access. ORACLE The Oracle Database administrator account you use to access the system and perform non-root database administration tasks. AContinue reading Oracle DBaaS 1z0-160 part 5:-OS account in cloud ( OPC,ORACLE,GRID,ROOT)

Oracle DBaaS 1z0-160 part 4:-Creating Cloud service roles and users and assign new roles

The DBaaS Database Administrator role is created for Oracle Database Cloud Service.When the Database Cloud Service account is first set up, the service administrator is given this role. User accounts with this role must be added before anyone else can access and use Database Cloud Service. The identity domain administrator can create more Database CloudContinue reading Oracle DBaaS 1z0-160 part 4:-Creating Cloud service roles and users and assign new roles