To stop enterprise manager 12c you need to follow the below steps : 1. Stop the Oracle Management Service: Run the below command from $OMS_HOME emctl stop oms -all 2. Stop the Management Agent: Run the below command from $AGENT_HOME emctl stop agent 3. Stop Oracle Management Repository For this […]
Today there was request from application team to import one of the schema from dev environment to uat one. I took schema level expdp backup & copied dumpfile to target environment. When I started import using datapump I got ORA-64307 😦 ORA-39083: Object type TABLE:”FTC”.”TDS_TRD” failed to create with error: […]
Today I came across an error ORA-00600: internal error code, arguments: [kqlidchg0] while importing one of the schema from UAT database to DEV database using IMPDP. IMPDP was failing after after importing TABLE_EXPORT/TABLE/TABLE_DATA with error : Job “SYS”.”SYS_IMPORT_FULL_01″ stopped due to fatal error at 10:28:53. After having quick check in […]
From Oracle 11g, there is a new security enhancement that has potential of creating huge performance issues due to failed login attempts through multiple sessions. Yesterday we faced this issue on production database, all application users were complaining about slow performance especially while making new connections with database. After having quick check […]
Many of the times we DBA get requests from AUDITORS to apply security policies or DB hardening checklists on databases so that all schemas/users will be with least required privileges/roles. Now here we will discuss about one of the most critical – UNILIMITED TABLESPACE privilege – is the one which […]
This post will provide u steps to deploy Oracle E-Business Suite plug-in into ORACLE OEM 12C which is also known as Oracle Application Management Pack for Oracle E-Business Suite. The Oracle Application Management Pack for Oracle E-Business Suite extends Oracle Enterprise Manager 12c Cloud Control to help monitor and manage […]
Today one of our developer accidentally dropped some of application base tables from development instance instead of uat environment. So there was a request re-clone development database from one month old backup which was used for cloning earlier. Simple!! everything was in proper place including datafile backups, archivelog backups, controlfile […]
From version 11g Oracle has come with new enhancement – Flashback Data Archive also known as Oracle Total Recall. With the “Oracle Total Recall” option, Oracle database 11g has been specifically enhanced to track history with minimal performance impact and to store historical data in compressed form to minimize storage […]
Today while creating database on ASM using DBCA I got following error exactly after reaching 4%. After searching on net I found, a workaround of using “custom database” tempalate instead of “general purpos or transaction processing” in dbca. I was not sure about this workaround, and as expected it failed […]
Today I faced very funny issue related to FRA – Flash Recovery Area. Linux guys informed us to clear old files as one of the mount point on database server had reached to its threshold free space. After investigating we found that one of database ORACLE_HOME was 192GB is size. […]
Adityanath's Oracle Blog 