We had SMON recovery crash with ORA-00607&ORA-00600: internal error code, arguments: [kdBlkCheckError]on 11.2.0.3.0 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 11.2.0.2 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.

– LIST ARCHIVELOG ALL;
– LIST BACKUP OF ARCHIVELOG ALL;
– LIST BACKUP;
– LIST BACKUP OF DATABASE;
– LIST BACKUP SUMMARY;
– LIST BACKUP BY FILE;

Read the rest of this entry »

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;
}

Read the rest of this entry »

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 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 9.2.0.8
– Oracle 10.2.0.5
– Oracle 11.1.0.0

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.

Referance:
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 11.2.0.4.6 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( 10.2.0.4.3 ) and OS is AIX 6.1 and my target db version is 11g RAC( 11.2.0.4.6 ) 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 »