Finally Oracle Database 12cR2 (12.2) On-Prem is available. Previously it was available only on cloud services. You can download it from eDelivery or OTN. Good Thing is that , now only zip file for Database Home as well as Grid Home. Prior to 12.2, There are 2 zip files for each of them. We can […]
All posts by Skant Gupta
Restore and Backup the current OLR
Backup current OLR and all available OLR backups # ocrconfig -local -manualbackup rac1 2017/03/01 20:52:12 /u01/app/grid/cdata/rac1/backup_20170301_205212.olr Verify available backups # ocrconfig -local -showbackup rac1 2017/03/01 20:52:12 /u01/app/grid/cdata/rac1/backup_20170301_205212.olr Verify available backups from OS # ls -l /u01/app/grid/cdata/rac1/* -rw——-. 1 root root 6803456 Feb 12 13:04 /u01/app/grid/cdata/rac1/backup_20170212_130457.olr -rw——-. 1 root root 7016448 Mar 01 09:08 /u01/app/grid/cdata/rac1/backup_20170301_090842.olr […]
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. […]
Relocate Voting Disk to a different ASM diskgroup in 11gR2
Check current status : $GRID_HOME/bin/crsctl query css votedisk ## STATE File Universal Id File Name Disk group — —– —————– ——— ——— 1. ONLINE 7dgdhsgijfgy7gsuugeydcbo0qoeijll (/dev/asm1_sdb1) [DATA] 2. ONLINE 6590ede5237e4f37bfe6aa3d196fe972 (/dev/asm2_sdc1) [DATA] 3. ONLINE 3a7c7b334faf4fdcbf05a246eddf5404 (/dev/asm3_sdd1) [DATA] Located 3 voting disk(s). Relocate Voting Disks $GRID_HOME/bin/crsctl replace votedisk +OCR Successful addition of voting disk 4f789813cef6d5d6f965cbef6de2ef6d. Successful […]
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 $ asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED NORMAL N 512 4096 1048576 40944 25698 10236 7731 0 Y DATA/ MOUNTED NORMAL N 512 […]
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
Shows differences in table structures
select a.column_name, a.data_type, a.data_length, a.data_scale,a.data_precision, b.column_name, b.data_type, b.data_length, b.data_scale,b.data_precision from user_tab_columns a, user_tab_columns b where a.table_name = upper(‘&table1’) and b.table_name = upper(‘&table2’) and a.column_name = b.column_name and ( a.data_type b.data_type or a.data_length b.data_length or a.data_scale b.data_scale or a.data_precision b.data_precision );
Query shows clients connected to all the Flex ASM instances
col client_instance_name format a21 col host_name format a9 col status format a9 select distinct i.host_name, i.instance_name asm_instance_name, c.instance_name client_instance_name, c.db_name, c.status from gv$instance i, gv$asm_client c where i.inst_id=c.inst_id;
Displays contents of the registry history
SELECT TO_CHAR(action_time, ‘DD-MON-YYYY’) AS TIME, action, namespace, version, id, comments, bundle_series FROM sys.registry$history ORDER by 1;
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 […]