Restore and Backup the current OLR

Backup current OLR and all available OLR backups

Verify available backups

Verify available backups from OS

Restore  OLR from Current Backup. Shutdown CRS and check that ohasd.bin process is not running and restore OLR

Read More

Generating an SSH Key Pair on Windows

The PuTTYgen program is part of PuTTY, an open source networking client for the Windows platform. To generate an SSH key pair on Windows using the PuTTYgen program: Download and install PuTTY or PuTTYgen. To download PuTTY or PuTTYgen, go to http://www.putty.org/ and click the You can download PuTTY here link. Run the PuTTYgen program. […]

Read More

Relocate Voting Disk to a different ASM diskgroup in 11gR2

Check current status :

Relocate Voting Disks

Check current status :

Read More

Relocate OCR to a different ASM diskgroup in 11gR2

Create a new diskgroup for OCR Use ascma and create new Data group named OCR and verify that this datagroup is mounted

  Check the current OCR location

Add +OCR datagroup as new OCR location and verify status

Delete the old OCR location

Check the current OCR location

Read More

Buying Metered Oracle Cloud Services

You can buy metered subscriptions to Oracle Public Cloud Services in different currency denominations and payment models. The following payment models are applicable to Oracle Public Cloud Services: Pre-Paid Subscription Pay as you Go Subscription   For More Detail : https://cloud.oracle.com/en_US/database/pricing

Read More

Shows differences in table structures

Read More

Query shows clients connected to all the Flex ASM instances

Read More

Displays contents of the registry history

Read More

Connect to Oracle Cloud Database with SQL Developer using SSH

Let’s turn off the 1521 port if we can already open so that to make sure our connection using SSH works. It will confirm us that SSH is enabled. Moreover SSH connection is more secure. In SQL Developer menu, click on View –> SSH. Then right click and choose “Create New SSH Host”. Provide the […]

Read More

Connect to Oracle Cloud Database using SQL Developer

By default, the Oracle DBaaS Cloud Service blocks access port 1521 used by tnsping. You have to open the port before you can connect using SQL Developer or Connecting to another instance via sqlplus. Log in to the Oracle Database Cloud Service and click on the service name which you already created. Note down the […]

Read More