Oracle Database&EBS General
-
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
-
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
HELIOS BLOG 