As a DBA, many time We need to make some tests on our databases(such as performance, load test etc… ) Many times its very hard to create same setup to get correct result for our tests.

For this purpose Oracle database can support Guaranteed Restore points feature . And now If you have dataguard system than you can use also snapshot standby database feature for your test purposes.

We can convert existing physical standby database to snapshot standby database which is as close as to the production database.  Snapshot standby database can  be open in write/open mode.

After related tests have been done,We can  convert snapshot standby database to physical standby database easily in minutes.

Read the rest of this entry »

I face with that issue during to database upgrade. My os is : SUN-Sparc x86-64

Here is the steps:

1. Set 11R2 Oracle_home

2. Open database

Read the rest of this entry »

I faced with that issue on db which is running on Exadata machine.

RMAN backup to disk failed with below error messages:

ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 2144337920 bytes disk space from 3221225472000 limit
RMAN-03009: failure of backup command on t4 channel at time_here

Read the rest of this entry »

We had SMON recovery crash with ORA-00607&ORA-00600: internal error code, arguments: [kdBlkCheckError]on db on linux system.

Here is the all related error messages and solution:

Read the rest of this entry »

I faced with that error on db on AIX 6.1 system.

During export an error message EXP-113 is raised:
EXP-00113: Feature New Composite Partitioning Method is unsupported. Table MYTABLE could not be exported
But the export would still complete and also there are some addition error messages are raised:
EXP-00006: internal inconsistency error
EXP-00000: Export terminated unsuccessfully

Read the rest of this entry »

As a DBA We always need to know backup informations for our databases.So I just prepared quick list for some important list backup commands.


Read the rest of this entry »

I faced with that error message during restore our db on AIX 6.1

My restore database command is simple as follow:

allocate channel restore01 type ‘SB_TAPE’ ;
allocate channel restore02 type ‘SBT_TAPE’ ;
RELEASE channel restore01;
RELEASE channel restore02;

Read the rest of this entry »

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(
INFO: Stderr Read: at oracle.xml.parser.v2.XMLError.flushErrors1(
INFO: Stderr Read: at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(
INFO: Stderr Read: at oracle.xml.parser.v2.NonValidatingParser.parseDocument(
INFO: Stderr Read: at oracle.xml.parser.v2.XMLParser.parse(
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiOracleHomeInfoXMLReader.updateHomeProperties(
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallInventory.updateOracleHomesProperties(
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallInventory.updateOracleHomesProperties(
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallInventory.readHomes(
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallAreaControl.loadPartialInstallInv(
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallAreaControl.initInstallInv(
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallAreaControl.loadInstallInventory(
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallAreaControl.initAreaControl(
INFO: Stderr Read: at oracle.sysman.oii.oiii.OiiiInstallAreaControl.initAreaControl(

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 »