Query to find audit information about dropped users
Find audit information about dropped users “DROP USER” is audited by default from Oracle 12c onwards. Use the below query to take information if you have not turned off standard…
Read MoreORA-28017: The password file is in the legacy format.
SQL> alter user sys identified by iossKfGHsdsdUVu93xxswQ; alter user sys identified by iossKfGHsdsdUVu93xxswQ * ERROR at line 1: ORA-28017: The password file is in the legacy format. Cause: There are…
Read MoreORA-39165: Schema SYS was not found ORA-39166: Object AUD$ was not found.
When trying to backup the SYS.AUD$ table using datapump getting below error expdp directory=EXPDR dumpfile=SYS_AUD_table.dmp logfile=exp_SYS_AUD_table.log tables=AUD$ exclude=statistics Export: Release 11.2.0.4.0 – Production on Fri Jan 6 15:31:15 2018 Copyright…
Read MoreRMAN-06820: WARNING: failed to archive current log at primary database
CAUSE: From 11.2.0.4 onward as per ‘unpublished’ Bug 8740124, We include the current standby redo log as part of an RMAN archivelog backup at the standby site. This is achieved…
Read MoreORA-01031: insufficient privileges
Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating…
Read MoreORA-00257: archiver error. Connect internal only, until freed.
Cause: The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely…
Read MoreORA-07445 – exception encountered: core dump
ORA-07445 – exception encountered: core dump Cause : An operating system exception occurred which should result in the creation of a core file. This is an internal error. Action :…
Read MoreORA-00245: control file backup failed; target is likely on a local file system
ORA-00245: control file backup failed; target is likely on a local file system $ cat rman_ORA-DATA_full-02Aug2017.log Starting backup at 02-AUG-17 channel c1: starting full datafile backup set channel c1: specifying…
Read MoreRMAN failed to connect target database with ORA-00020: maximum number of processes (150) exceeded
Solution: Here, we can see in error as maximum number of processes has exceeded. So, we need to Increase the number of processes from sys user with sysdba privilege which…
Read MoreORA-00609: could not attach to incoming connection ORA-609: opiodr aborting process unknown ospid ORA-609: opiodr aborting process unknown ospid Cause and Solution
ORA-00609: could not attach to incoming connection This error is usually a secondary error. This means that the actual cause of the issue is another error in the stack trace…
Read More