Database Blog

[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 More

Migration 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 More

Disable 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 More

ORA-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 More

Database 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 More

ORA-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 More

How 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

Useful information about Database audit

Database auditing is the process of recording, monitoring and reporting of the actions performed on a database. It allows the security auditors to observe whether the database users are using…

Read More

How to find latest recommended patches or patchset in E-business suite?

There are many ways to find latest recommended patch collection or patchset for particual modules in E-business suite.  The best way for me is using patchsets.sh tool. Just download from…

Read More

How to upload Large files in Oracle Support?

Usually, any Service Request created in Oracle requires supported log files and trace files to be uploaded. The usual way of uploading from your desktop to My oracle Support (MOS)…

Read More