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

ora-errors and solutionsWritten by September 10, 2021

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

ora-errors and solutionsWritten by September 9, 2021

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

ora-errors and solutionsWritten by September 9, 2021

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

Drop Oracle single instance Database Manually

Oracle database AdministrationWritten by September 6, 2021

Drop Oracle single instance Database Manually Hostname : lovetechOS : Red Hat Enterprise Linux Server release 7.9 (Maipo)DB Name : DBADEVVersion : 11.2.0.1Filesystem : NormalDatabase type : Single InstanceOracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Set env to DBADEV database [oracle@lovetech ~]$ . oraenvORACLE_SID = [dbadev] ? dbadevThe 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

Read More

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

ora-errors and solutionsWritten by September 5, 2021

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

AWS Launches Amazon MemoryDB For Redis

Software, TechnologyWritten by May 4, 2020

Amazon Web Services’ launch today of Amazon MemoryDB for Redis, a new fully managed database, answers customers’ calls for an easier way to build modern applications with microservices without compromising on extreme performance and durability, according to the cloud provider. Now generally available, Amazon MemoryDB for Redis is a Redis-compatible, in-memory database designed to deliver ultra-fast performance with sub-millisecond latency. “With

Read More

“Why cloud computing?” Always a good question

Design, SoftwareWritten by May 4, 2020

Recently, some people have asked, “Why is it the cloud?” Often they are treated as witty. People who act as Devil’s advocates are often set aside when offensive questions force others to justify the use of the cloud (or, for that matter, new technologies). Results are better when some people question why they are moving to the cloud. The reason is

Read More

Getting the Best Out of Oracle Enterprise Manager

Software, TechnologyWritten by May 4, 2020

During Quest Forum Digital Event: Database & Technol­ogy Week, Kurt Engeleiter, product manager of database manageability at Oracle, presented on database optimization and how to get the best out of Oracle Enterprise Manager. Accord­ing to Engeleiter, you should follow these five steps to maximize performance of Oracle Enterprise Manager: Understand database management solutions. Know why database performance can change. Determine where

Read More

@ 2021 Lovetech Consulting LLC. All rights reserved. Crafted by Codestrat Designers

 
Required 'Candidate' login to applying this job. Click here to logout And try again
 
 

Answers

 

Account Activation

Before you can login, you must activate your account with the code sent to your email address. If you did not receive this email, please check your junk/spam folder. Click here to resend the activation email. If you entered an incorrect email address, you will need to re-register with the correct email address.