The Quest Backup Reporter is a windows client application. It can connect too many databases at a time and reports directly from oracle data dictionary views and RMAN catalog. It does not make any modification to either database as well as RMAN configuration. It is just a read only reporting tools. Quest Backup Reporter tools […]
All posts by Skant Gupta
Migrate On-Premises Database to Oracle Cloud Database Using Remote Cloning
This article shows how to use the remote cloning method to copy a pluggable database (PDB) from your on-premises Oracle Database 12c database to a PDB in a database-as-a-service (DBaaS) container database (CDB) in an Oracle Database Cloud Service deployment. This article was written by Skant Gupta and Joel Perez in Oracle OTN Note: You […]
Upgrade to Oracle 12.2 with dbupgrade utility
Oracle Database 12c release 1 (12.1) introduced the Parallel Upgrade Utility, catctl.pl. This utility reduces the total amount of time it takes to perform an upgrade by loading the database dictionary in parallel, and by using multiple SQL processes to upgrade the database. Performing parallel upgrades of components enables you to take advantage of your […]
Configure Data Redaction on Oracle
In previous article we provide the brief introduction about Data Redaction on Oracle. Now in this post, we are going to configure different type of Data Redaction in Oracle 12c. Full Data Redaction Partial Data Redaction Random Data Redaction Data Redaction with REGEXP For the demonstration on this I have a table that holds credit […]
Oracle Data Redaction
Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by applications. You can redact column data by using one of the following methods: Full redaction. You redact all of the contents of the column data. The redacted value returned to the querying application user depends on the data type of […]
Oracle Proxy Users
If you have required privileges, it’s possible to connect as a user account without knowing or changing his password. This is called proxy connection. To authorize a user account to connect using a proxy account, use the GRANT CONNECT THROUGH clause of the ALTER USER statement. Consider, we have a Application User called ‘APPUSR‘ and […]
Steps to change SCAN IP address in RAC
To Change the SCAN IP address it must be available and need to changes on the DNS by the network admin. So we have SCAN IP address available. Steps: 1. To check the current status SCN IP address on DNS $nslookup <scan-name> $nslookup testrac-scan.abc.com Server: 160.34.11.20 Address: 160.34.11.21#40 Name: testrac-scan.abc.com Address: 160.34.11.88 Name: testrac-scan.abc.com Address: […]
Change Listener ports RAC with MGMTDB
In this post, you will know how to change the Listener Port In Oracle RAC. We can change some listener ports from 1521 to 1525 on a RAC. 1. Check the listener status [oracle@node1 ~]$ srvctl status listener -l LISTENER Listener LISTENER is enabled Listener LISTENER is running on node(s): node1,node2 2. Modify the listener […]
ORA-00600: internal error code, arguments: [kwqitnmphe:ltbagi]
Recently started seeing this error on few of the RAC environments. Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl01/trace/orcl01_q002_5570998.trc: ORA-00600: internal error code, arguments: [kwqitnmphe:ltbagi], [1], [0], [], [], [], [], [], [], [], [], [] As per metalink this is a known Bug 20987661 – Doc ID 20987661.8 DECLARE po dbms_aqadm.aq$_purge_options_t; BEGIN po.block := FALSE; DBMS_AQADM.PURGE_QUEUE_TABLE( queue_table => […]
ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver]
On an Oracle 11204 restart environment, ASM spfile creation failed with error ora-600 create spfile=’+DATA5′ from pfile=’/u03/asmpfile.ora’ * ERROR at line 1: ORA-01078: failure in processing system parameters ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver],[0x0A2435D48], [3], [0x7F710EE38000], [512], [], [], [], [], [], [], [] This was caused due to a ASM disk with UNKNOWN HEADER_STATUS. […]