I faced with XML-20108: (Fatal Error) message during 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 oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:461)
INFO: Stderr Read: at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:402)
INFO: Stderr Read: at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:244)
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiOracleHomeInfoXMLReader.updateHomeProperties(OiiiOracleHomeInfoXMLReader.java:86)
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallInventory.updateOracleHomesProperties(OiiiInstallInventory.java:796)
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallInventory.updateOracleHomesProperties(OiiiInstallInventory.java:779)
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallInventory.readHomes(OiiiInstallInventory.java:735)
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallAreaControl.loadPartialInstallInv(OiiiInstallAreaControl.java:782)
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallAreaControl.initInstallInv(OiiiInstallAreaControl.java:827)
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallAreaControl.loadInstallInventory(OiiiInstallAreaControl.java:598)
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallAreaControl.initAreaControl(OiiiInstallAreaControl.java:1991)
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallAreaControl.initAreaControl(OiiiInstallAreaControl.java:1944)

This server is already serve 3 different databases versions. Those ares:
– Oracle
– Oracle
– Oracle

After investigate issue, I canceled installation and perform below steps and start instllation again wihtout any errors.

– Rename the existing oraInventory folder.
– Execute the installer.

ATS upgrade installer on linux error : Start of root element expected (Doc ID 1988220.1)

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.


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 server process from a shared pool of server processes picks up a request from the queue. This means a small pool of server processes can serve a large number of clients.

Related views:

select * from v$dispatcher
select * from v$dispatcher_config
select * from v$dispatcher_rate
select * from v$queue

Read the rest of this entry »

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.

Read the rest of this entry »

I face with this error message during export,import process in scheduled crontab job.

Source and Target DB versions are both and OS are AIX 7.1

After investigate issue We noticed, you can face this error because of 2 reasons.

Read the rest of this entry »

I face with this error message while I am doing import process on 11g database.

My source db version is 10g( ) and OS is AIX 6.1 and my target db version is 11g RAC( ) and OS is AIX 7.1.

The errors:
ORA-39083: Object type PASSWORD_HISTORY failed to create with error:
ORA-01861: literal does not match format string

Read the rest of this entry »

If you are using RAC system (doesnt matter how many nodes you have) You need to know where log files are located.

In this post, I share those log files locations.

Here We go;

The Cluster Ready Services Daemon (crsd) Log Files

Log files for the CRSD process (crsd) can be found in the following directories:

                 CRS home/log/hostname/crsd

Oracle Cluster Registry (OCR) Log Files

The Oracle Cluster Registry (OCR) records log information in the following location:

                CRS Home/log/hostname/client

Cluster Synchronization Services (CSS) Log Files

You can find CSS information that the OCSSD generates in log files in the following locations:

                CRS Home/log/hostname/cssd

Read the rest of this entry »

Physical Standby Switchover_status Showing Not Allowed

We try to make some switchover test on our RAC db(2 nodes setup) which has Physical Standby. Do not forget, before start your switchover test, you need to close one of the member of the rac instance.

After close one of instance We checked below query result;

Read the rest of this entry »

In this post, I want to share Switchover process on Dataguard Setup.

Db version is 11.2  2 node RAC and standby db is standalone

Operation system is  AIX 7.1

Data Guard Physical Standby Switchover Best Practices using SQL*Plus

Read the rest of this entry »

For some reasons, you may need to change your existing IP or hostname after installation.

In this case We need to change our current IP on standalone GI.

Operation System –> AIX 7.1
Oracle GI Version –>

Please perform the next steps after the hostname and/or IP address was updated/changed/modified in the Oracle Restart configuration: Read the rest of this entry »


Get every new post delivered to your Inbox.

Join 28 other followers