The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog. Here’s an excerpt: A New York City subway train holds 1,200 people. This blog was viewed about 4,400 times in 2014. If it were a NYC subway train, it would take about 4 trips to carry that […]
Some day before while performing import operation using IMPDP using network_link parameter, I came across this issue. My IMPDP command was as given below: impdp directory=UAT_DIR network_link=MIGRATION_DB_LINK parallel=8 full=y logfile=migration_UATDB_27nov.log exclude=SCHEMA:”in (‘SCOTT’,’ORACLE_OCM’,’XS$NULL’,’MDDATA’,’DIP’,’APEX_PUBLIC_USER’,’SPATIAL_CSW_ADMIN_USR’,’SPATIAL_WFS_ADMIN_USR’,’DMSYS’,’DBSNMP’,’FLOWS_FILES’,’MDSYS’,’ORDSYS’,’EXFSYS’,’WMSYS’,’APPQOSSYS’,’APEX_030200′,’OWBSYS_AUDIT’,’ORDDATA’,’CTXSYS’,’ANONYMOUS’,’XDB’,’ORDPLUGINS’,’OWBSYS’,’SI_INFORMTN_SCHEMA’,’OLAPSYS’,’SYS’,’SYSTEM’,’OUTLN’)” I got following error, before it got terminated due to fatal error: Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA ORA-39127: unexpected error […]
We got issue in one of the production environment, RMAN archivelog backup was failing with following errors: kgefec: fatal error 0 kgepop: no error frame to pop to for error 603 We were using following command in rcv file to backup archivelogs: BACKUP archivelog all delete input; After searching on […]
A couple of days ago, I got request from one of the user for oracle client installation on his new application server. When I started client installtion, I got following error: A screeshot with just a message : <hostname>:<hostname> as given below: After searching in error logs for all possible […]
Yesterday I got request from one of the user saying his job failed giving following error: Severity Timestamp Node Thread Message Code Message ERROR 2014/10/24 02:59:32 PM node-uat-informatika READER_1_1_1 RR_4035 SQL Error [ ORA-12801: error signaled in parallel query server P178, instance rmb-uat-db-gik1:DBGIK1 (1) ORA-12853: insufficient memory for PX buffers: […]
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 […]
Adityanath's Oracle Blog 