how to create users i IDCS and assigning user to roles , Groups and Assign policies to Groups in OCI

 In this post i have shared details are how to create users , Groups and policys in OCI , 

Note : we should have Goups and policy before user creation , because to create users at least one Group should be there and goups should have policy so First we need to create Goups then Policy and Users later we can add users to Pilicys .

How to create Groups In OCI :

Open the Navigation menu and click on Identity and Security , then click on Domain under identity ..

Select the root compartment and then click on default domain.

Select the / click on Group.

Click on create group and then enter the group name and description .

Now Assign Policies to Group ..

 Click on Identity & Security . then select policy under identity .

Select the compartment for which we need to give policies .. then click on create policies .

Select then name for policy and compartment  , click on show manual editor then write the policy.

You can able to see the policy after create …

Create users in IDCS … in OCI , Click on Identity & Security then click on domain

Select the compartment and then click on Default ..

Click on user on left side .

Click on Create users.

• First Name: First name of the user.

• Last Name: Last name of the user.

 • Username / Email: A valid email ID.

• Groups: Select the group that corresponds to the user you are creating. For example, if you are creating the Cloud Manager administrator, select the Cloud Manager administrators group. If you are creating the network administrator, select the network administrators group.

 • Click Create.

 • Grant the newly created user the Application Administrator role by following the steps in Assigning Users to Roles in the Oracle Cloud Infrastructure Documentation. 

Select the Group for this user and click on create .

How to Assigning Users to Roles ..

Select Identity & Security then click on Domain ,

Then select .. Default ..

Then select on security left side ..

Select administrator then click on add users .

Thanks,

Srini

How to create compartments and VCN in OCI

 In this post i have shared , how to create a compartment and VCN in OCI Cloud , for you need to login to cloud.oracle.com . then only you can able to perform below activity .

How to create compartment in OCI ..

Select identity & Security and then select compartments under identity ..

 

 

Then click on create compartment .

 

 

Provide the name and description for compartments .. default root compartment will select .. then click on create compartment .

That’s it you can able to see your compartment like below .

 

create a new Virtual Cloud Network:

select the network from the main menu and then click on Virtual Cloud network.

Click on  Create VCN .

Enter the name for VCN , select the compartment where you want to configure VCN and give the IPv4 IP .. then click on Create VCN.

To see your VCN , you have to select the compartment where you created this VCN then only you can able to see. If you select another compartment you will not be able to see the VCN .

 

Thanks,

Srini

 

DBA Handy 19c grid Cluster manage Comands with snaps.

Dear All,

In this post will share the Cluster status hands-on commands for day to day work..

oracle clusterware resources and components we can mange with CRSCTL Utility.

1. How to connect to opc instance and switch to Grid user .

sudo su - grid

2.How to  stop and start Cluster : ( run from root user) to check the cluster status you can connect grid user and and set the grid home and check it , you can connect to root user if you want to stop and start the cluster services .

Note :  we have to stop the all the running database instnace prior to Cluster stop .

$GRID_HOME/bin/crsctl stop crs

$GRID_HOME/bin/crsctl start crs

3. Enable/Disable auto restart of CRS.

$GRID_HOME/bin/crsctl disable crs

$GRID_HOME/bin/crsctl enable crs

4. we can Find the cluster name by using below commands.

$GRID_HOME/bin/cemutlo -n

or

$GRID_HOME/bin/olsnodes -c

5.how to  Find the grid version:

 $GRID_HOME/bin/crsctl query crs softwareversion 

$GRID_HOME/bin/crsctl query crs softwareversion devdb01

[grid@devdb01 grid]$ crsctl query crs softwareversion devdb01

Oracle Clusterware version on node [devdb01] is [19.0.0.0.0]

6. check cluster component status

$GRID_HOME/bin/crsctl stat res -t

$GRID_HOME/bin/crsctl check crs

$GRID_HOME/bin/crsctl check crsd

$GRID_HOME/bin/crsctl check cssd

$GRID_HOME/bin/crsctl check evmd

7. Find voting disk and OCR location

$GRID_HOME/bin/crsctl query css votedisk

$GRID_HOME/bin/ocrcheck

8. Find cluster interconnect details

$GRID_HOME/bin/oifcfg getif

select NAME,IP_ADDRESS from v$cluster_interconnects;

 9. Check CRS status of local node and staus of  all crs resourcs

crsctl check crs

$GRID_HOME/bin/crsctl stat res -t

$GRID_HOME/bin/crsctl stat res -t -init

10. Stop and start high availability service ( HAS)

crsctl stop has

crsctl start has

11. Check CRS status of remote nodes

crsctl check cluster

crsctl check cluster -all

12. Disk timeout from node to voting disk(disktimeout) and Network latency in the node interconnect (Misscount)

crsctl get css disktimeout

crsctl get css misscount

crsctl replace votedisk +OCRVD

13. Add , Delete , another voting disk:

crsctl add css votedisk

crsctl delete css votedisk

14 . Get ocr disk backup details and Check whether standard or flex ASM

ocrconfig -showbackup

crsctl get cluster mode status

15 . Check CRS /cluster configuration information:

crsctl config crs

crsctl get cluster configuration

16 .Node roles in cluster

crsctl get node role status -all

17. crsctl has commands for standalone grid infrastrcuture

crsctl check has

crsctl config has

crsctl disable has

crsctl enable has

crsctl query has releaseversion

crsctl query has softwareversion

crsctl start has

crsctl stop has

Thanks,

Srini

How to create an instance in OCI

 

Hi All,

In this post will show you how to create new instance in Oracle cloud console .

once loged to Oracle cloud , go to compute... then click on instances .

Click on instances and then click on create instnaces:

provide the instnace name or leave it default,then select the compartment  .. then select the placement  which you want.

select the shape / image .

then select the network components and upload the public key which you generated from your machine to the cloud instnace .

note : dont share the private key with any one that you can use your self ( ex. to connect linux server using putty ) .

if you dont have key you can generate from the console click on generate a key pair for me option.

select the boot volume , i am useing free tier so , i have leave it default .. you can custamize as per your requriments with in the limits .

Click on hide advanced options , update if its requried , i have leave it default.

then click on create .. with few seconds your instnace is ready to use.

in the next post will share how to access this instance from your local windows machine and how to extended the block volue .  thank you 

Thanks ,

Srini