-
ORA-02236: invalid file name
I face wiht this issue when try to add standby file on standalone 11.2.0.1 database with ASM on AIX operating system: Symptoms: SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 size 5G; ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 size 5G * ERROR at line 1: ORA-02236: invalid file name SQL> show parameter DB_CREATE_FILE_DEST NAME… Continue reading
-
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
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- Most Common Oracle Wait Events
- Oracle Multitenant architecture at 26ai
- ORA-01555 vs ORA-01628
- RMAN in Oracle 19c vs 26ai — What Changed??
- Oracle AI Database 26ai — The Features That Will Change How You Build Applications?
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 