RMAN Clonning Active duplication
RMAN CLONNING WITH ACTIVEDUPLICATION: Steps in source database: STEP1:verify whether the database is up with pfile or spfile if started with spfile create a pfile from spfile and transfer the…
Read MoreIntroduction to Oracle Dataguard
In the following posts we will discuss about Oracle Dataguard concepts and implementation. Introduction to Oracle Dataguard 1. Oracle Data Guard ensures high availability, data protection,and disaster recovery for enterprise…
Read MoreTransportable Database from Linux to Windows
Transportable Database from Linux to Windows Overview : – TDB requires that data files be converted to the target platform format. The data file conversion can occur on either the…
Read More[Infographic] What Makes Oracle Storage the Best Choice for Oracle Database?
The solutions provided by Oracle Storage, which is co-engineered with Oracle Database, rise above the offerings supplied by traditional storage and help to make the application and database run quicker.…
Read MoreMigration from Windows to linux Oracle 12c database to 19c database
MIGRATION FROM WINDOWS TO LINUX(12.1.0.1 TO 19.0.0) INSTALLED A DATABASE IN WINDOWS AND CHECKED THE PLATFORM NAME AND ENDIAN FORMAT CREATED A USER AND CREATED A TABLE IN…
Read MoreDisable worklist on the R12 home page
When you login in R12, you could see the workflow notifications listed in the home page. This is an new feature in R12 so that users will get notified whenever…
Read MoreORA-01403: no data found while activating SOURCE CONFIG in shareplex
While activating the config in SOURCE, received below error in event_log Warning 2020-01-12 01:13:51.386794 24843 2012734928 Activation: 13007 – No unique keys or primary key for object id 22581 …
Read MoreDatabase crash with error ORA-03113: end-of-file on communication channel
RAC DATABASE Crash with ORA-03113 error Sometimes, RAC database after clone failed to start with ORA-03113 error. This is because of log_archive_config is not same across all instances of the…
Read MoreORA-19808: recovery destination parameter mismatch
When 2 rac node database started, it throws ORA-19808 error as below. SQL> startup pfile=’/tmp/pfile.ora’; ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated ORACLE instance started. Total System Global…
Read MoreHow to Audit particular table in database?
To set audit: AUDIT [option] [BY user|SESSION|ACCESS] [WHENEVER {NOT} SUCCESSFUL] For example: SQL > audit select on dba_users by access whenever not successful; Audit Succeeded. How to check what object…
Read More