Oracle single instance database startup fails due to ORA-09925 after changing audit_file_dest.

FINDINGS login as: oracleoracle@192.168.1.101’s password:Last login: Fri Sep 10 03:22:27 2021[oracle@lovetech ~]$[oracle@lovetech ~]$[oracle@lovetech ~]$ . oraenvORACLE_SID = [dbatest] ? dbaprodThe Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle[oracle@lovetech ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 10 03:24:34 2021 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startupORA-09925: Unable to create audit trail

Read More

DataPump schema export Job Fails Due to ORA-3900,ORA-39000,ORA-31640,ORA-27037

oracle Database – Enterprise EditionInformation in this document applies to any platform. Evidence[oracle@lovetech exp_dir]$ impdp system/xxxxxx directory=datapump dumpfile=scottss.dmp logfile=imp_schema.log remap_schema=’SCOTT:SCOTT’ Import: Release 11.2.0.1.0 – Production on Thu Sep 9 00:23:14 2021 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real

Read More

Datapump schema export Job Fails Due to ORA-39002,ORA-39070,ORA-39087

Oracle Database – Enterprise EditionInformation in this document applies to any platform. EvidenceDatapump export schema job fails with errors:[oracle@lovetech exp_dir]$ expdp scott/xxxxx@dbaprod schemas=SCOTT directory=datapump dumpfile=SCOTTSC.dmp logfile=expdpSCOTT.log Export: Release 11.2.0.1.0 – Production on Wed Sep 8 23:58:24 2021 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit ProductionWith the

Read More

Starting oracle 11g database instance fails due to ORA-00845

ORA-00845: MEMORY_TARGET not supported on this system Oracle Database – Enterprise EditionInformation in this document applies to any platform. [oracle@lovetech dbs]$ . oraenvORACLE_SID = [dbaprood] ? dbaprodThe Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle[oracle@lovetech dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 5 12:23:52 2021 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance.

Read More