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

Oracle DBaaS 1z0-160 part 3:-Best Practise to be followed for cloud deployment

Do not create additional installations of Oracle Database software.Each deployment comes with Oracle Database software already installed. Do not create additional Oracle databases. Do not change fundamental characteristics of the database, such as the DB name (SID). Use only cloud tooling to update the password of the SYS and SYSTEM database users. Apply only patchesContinue reading Oracle DBaaS 1z0-160 part 3:-Best Practise to be followed for cloud deployment

Oracle DBaaS 1z0-160 part 2:-How to subscribe to Oracle cloud free

Register for free subscriptions 1.Please type url to your favorite browser https://cloud.oracle.com/home 2.Click on green button 3.Please click on “Create a Free Account” 4.Please fill all details along with your credit card information   Note:-Please select among following region(Default Data Region).If you select EMEA or NA you will get more options like RAC with DataguardContinue reading Oracle DBaaS 1z0-160 part 2:-How to subscribe to Oracle cloud free

Oracle DBaaS 1z0-160 part 1:-Oracle DBaaS cloud services overview

Oracle DBaaS cloud services overview A.Oracle DBaaS cloud services level A.1 The Oracle Database Cloud Service – Virtual Image —You have to install this software yourself, and you are responsible for all maintenance operations for this software. You have root privilege, so you can load and run software in the compute environment. You have fullContinue reading Oracle DBaaS 1z0-160 part 1:-Oracle DBaaS cloud services overview

KBHS-00712: ORA-29024 received from local HTTP service during backup in RAC Oracle cloud

KBHS-00712: ORA-29024 received from local HTTP service during backup in RAC Oracle cloud The backup of Oracle RAC DBaaS may fail during manual as well automatic backup. If you manually invoke following command,The backup may not get successful. Login to opc. [opc@pocracdemo1 ~]$ raccli describe job 17 {   “requestStatus” : “SUCCESS”,   “jobStatus” :Continue reading KBHS-00712: ORA-29024 received from local HTTP service during backup in RAC Oracle cloud