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 MoreWhen 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 MoreCAUSE: 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 MoreCause: 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 MoreCause: 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 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 $ cat rman_ORA-DATA_full-02Aug2017.log Starting backup at 02-AUG-17 channel c1: starting full datafile backup set channel c1: specifying…
Read MoreSolution: 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 This error is usually a secondary error. This means that the actual cause of the issue is another error in the stack trace…
Read MoreORA-02304: invalid object identifier literal Cause: An attempt was made to enter an object identifier literal for CREATE TYPEthat is either: – not a string of 32 hexadecimal characters –…
Read More