-
RMAN-03002: RMAN-06561: Error during restore database
I faced with that error message during restore our 10.2.0.5 db on AIX 6.1 My restore database command is simple as follow: RUN { allocate channel restore01 type ‘SB_TAPE’ ; allocate channel restore02 type ‘SBT_TAPE’ ; RESTORE DATABASE ; RELEASE channel restore01; RELEASE channel restore02; } Continue reading
-
MRP0: Background Media Recovery terminated with error 1111
I have dataguard configuration such as 2 node rac(11.2.0.2) on aix 6.1 as primary, standalone standby database. I noticed that Primary can transport archive log to standby but standby can not apply archive log and giving errors at standby alert.log such as: MRP0: Background Media Recovery terminated with error 1111 and MRP0: Background Media Recovery… Continue reading
-
ORA-02097&ORA-00068
As you know sometimes we need to change CPU count dynamically on our prod systems. Our Unix team change our 2 node RAC system (11.2.0.3 version) server’s CPU from 20 to 30 on AIX 7.1 After that change one of the instance(node 2) goes down with below error messages: ORA-02097: parameter cannot be modified because… Continue reading
-
RMAN catalog and Tivoli Storage Manager (TSM) is not in sync.
I face this issue when my tivoli admin friends warn me about old backup which could be listed on Tivoli Storage even I delete my all old RMAN backups wiht RMAN commands on our 11.2.0.1 database Continue reading
-
XML-20108: (Fatal Error)
I faced with XML-20108: (Fatal Error) message during 11.2.0.4 installation on RHEL Linux X86-64 platform. Installation screen hangs and installation log has below error messages: INFO: Stderr Read: org.xml.sax.SAXParseException: <Line 1, Column 1>: XML-20108: (Fatal Error) Start of root element expected. INFO: Stderr Read: at oracle.xml.parser.v2.XMLError.flushErrorHandler(XMLError.java:422) INFO: Stderr Read: at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:287) INFO: Stderr Read: at… Continue reading
-
Step By Step Oracle Database Upgrade from 9i to 11g and 10g to 11g
Oracle Database Upgrade process is the one of the main job for DBAs. I just prepared Manuel Upgrade doc which covers Oracle 9i to Oracle 11g upgrade steps. Please do not forget, Oracle recommend to use DBUA utility for upgrade process. Please click here to download pdf. Continue reading
-
How to Restart Dead Dispatchers Manually
The shared server architecture enables a database server to allow many user processes to share very few server processes, so the number of users that can be supported is increased. With shared server, many user processes connect to a dispatcher. The dispatcher directs multiple incoming network session requests to a common queue. An idle shared… Continue reading
-
Automatic SQL Tuning in Oracle Database 10g&11g
As a DBA, We need to tune many sql for performans issue. Its very good option to use SQL Tuning Advisor(also SQL repair advisor) from OEM. In this post, We will use sqlplus for SQL Tuning Here is the steps. Continue reading
-
How to find tablespace size and monitor growth
I want to share some useful sql queries in blog which we use many times in a day. I see many post in OTN site which is mention how the poster see information about their tablepsace on database. Here is the some queries which i use 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 