debasis maity

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… Continue Reading Oracle DBaaS 1z0-160 part 11: Starting and Stopping Oracle Database deployment

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… Continue Reading Oracle DBaaS 1z0-160 part 9:Enabling access to compute node using access rules and directly connect using 1521 to oracle cloud instance

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… Continue Reading Oracle DBaaS 1z0-160 part 8:How to connect your oracle cloud database from 1521 port using sql developer/TOAD

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… Continue Reading Oracle DBaaS 1z0-160 part 7:Connecting you Oracle cloud database server using SSH

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… Continue Reading Oracle DBaaS 1z0-160 part 6:Creating you first single instance database in Oracle cloud

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… Continue Reading Oracle DBaaS 1z0-160 part 5:-OS account in cloud ( OPC,ORACLE,GRID,ROOT)

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… Continue Reading Oracle DBaaS 1z0-160 part 4:-Creating Cloud service roles and users and assign new roles