-
Import from full export through ORA-39002 & ORA-39166 errors
As a DBA, We are using export/import utility many times during our daily process. I have face this error trying to import only one table from full export. Error message is ORA-39002: invalid operation ORA-39166: Object USER1.TABLE was not found. Continue reading
-
ex: 0602-101 Out of memory saving lines for undo.
While you are trying to open alert_SID.log file or some other large files with vi editor you may hit ex: 0602-101 Out of memory saving lines for undo error message, # cd /u01/app/oracle/admin/DB_NAME/bdump # vi alert_SID.log ex: 0602-101 Out of memory saving lines for undo. So you can use below syntax to can set EXINIT value,then… Continue reading
-
ORA-19606 during Rman backup
I faced with ORA-19606 error on 11.2.0.4 database. I am using below rman script to take full backup for my database. Here is my script: rman target / run { ALLOCATE CHANNEL C1 device type ‘sbt_tape’ ; ALLOCATE CHANNEL C2 device type ‘sbt_tape’ ; backup database plus archivelog delete input format= ‘DB_SID_DB_%d_%t_%s_%p’; backup archivelog all… Continue reading
-
ORA-29702: error occurred in Cluster Group Service operation
I faced with that error on r12.1.3 EBS system. My db version is 11.2&2 node RAC system. My first node is goes down by below errors: opiodr aborting process unknown ospid (11075852) as a result of ORA-28 LMON (ospid: 63767522) detects hung instances during IMR reconfiguration LMON (ospid: 63767522) tries to kill the instance 2.… Continue reading
-
PMON terminating with error 481
On my 11.2&2 node RAC system, one of the node has been rebooted. While I was investigating issue I noticed LMDO process terminating the instance. We have below in alert.log on victim node: LMS2 (ospid: 28770960) received an instance eviction notification from instance 2 [2] LMON received an instance eviction notification from instance 2 The… Continue reading
-
ORA-01578 & ORA-01110 at alertlog
You can hit this error on your alert.log. Error could be similar as: ORA-01578: ORACLE data block corrupted (file # 12, block # 4207) ORA-01110: data file 11: ‘/xx/sytem.dbf’ There are many possible causes of a block corruption including: – Bad IO hardware / firmware – OS problems – Oracle problems – Recovering through “UNRECOVERABLE”… Continue reading
-
ksh: /usr/bin/rm: arg list too long While deleting files on linux
You can face with this error message while you are deleting some xxx.trc -c-dump files or some other files which fill up your disk you may hit ksh: /usr/bin/rm: arg list too long error message, Continue reading
-
High CPU usage on EMON PROCESS
In Our RAC databases I noticed EMON process consuming CPU. OEM graph like below: Continue reading
-
“SYS”.”ORA$AT_SA_SPC_SY_ is failing
I faced with this error message on 18c RAC database. Error message is: ORA-12012: error on auto execute of job “SYS”.”ORA$AT_SA_SPC_SY_10909″ ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at “SYS.DBMS_ADVISOR”, line 201 ORA-06512: at “SYS.DBMS_SPACE”, line 2563 ORA-06512: at “SYS.DBMS_SPACE”, line 2643 Continue reading
-
How to Relocate SCAN_LISTENER
I have 12.0.1.2 node RAC system on Linux 64 bit. I had some e-mails from our developer team about database connection problems. They got “ORA-12541: TNS:no listener” error message. I started to investigate issue by checking current status of services by using below command: crsctl stat res -t I noticed that SCAN_LISTENER service status were… Continue reading
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- Oracle CDB vs Non-CDB: A Future-Ready Database Architecture
- Hot Cloning of a PDB in Oracle Database
- Oracle + Artificial Intelligence = Smarter Database Management
- Understanding UNDO Tablespace in Oracle Database: Importance and Best Practices
- Fortifying Your Cloud: Understanding the OCI Zero Trust Landing Zone
CATEGORIES
- Cloud Computing Tutorials
- My Presentations
- Oracle Cloud Journey
- Oracle Database&EBS General
- Oracle E-Business Suite Release 11
- Oracle E-Business Suite Release 12
- Scripts for Oracle E-Business Suite
- Some other Oracle Products Installation
- Step by Step Oracle E-Business Suite Installation
- Video Tutorials
HELIOS BLOG 