Oracle Update Statement- To understand what is happening internally

We asume that we update or select data from one table in oracle database. We just type some sql and see data on our screen. But what is happening internally?

Here is the answer:

SQL>select * from emp;
SQL>update emp set sallary=30000 where empid=10;
SQL>commit;

So Let us see, what is happening internally.. Here is the steps

Read the rest of this entry »

Oracle Database Block corruption

There are many possible causes of a block corruption including:

– Bad IO hardware / firmware
– OS problems
– Oracle problems
– Recovering through “UNRECOVERABLE” or “NOLOGGING” database actions (in which case ORA-01578&ORA-01110 is expected behavior)

Before start to post, there are 2 types corruptions. Data corruption can manifest itself as a physical or a logical corruptions:

Read the rest of this entry »

ERROR 1033 RECEIVED LOGGING ON TO THE STANDBY

I got email from our OEM such as ” PROD EM Event: Critical:XXXDG – The database status is UNKNOWN.” This standby db is belong to of our 11.2.0.4 RAC database which is running on AIX 7.1.

While I checked node1&2 alert log, there are some message such as:

ARC0: Archive log rejected (thread 1 sequence 5253) at host ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1527))(CONNECT_DATA=(SERVICE_NAME=xxxDG)(SERVER=DEDICATED)))’
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance XXX – Archival Error. Archiver continuing.
Error 1033 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1527))(CONNECT_DATA=(SERVICE_NAME=xxxDG)(SERVER=DEDICATED)))’. Error is 1033.

Read the rest of this entry »

The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog.

Here’s an excerpt:

The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 140,000 times in 2015. If it were an exhibit at the Louvre Museum, it would take about 6 days for that many people to see it.

Click here to see the complete report.

When our developers run their code on Our db( version is 11.2.0.4,OS AIX 7.1.), they hit ORA-29538&ORA-06512 errors.

Here is the error messages:

ORA-29538:Java not installed
ORA-06512:at_konum “XXX.UNZIPPER_PKG”, line 2
ORA-06512:at “XXX.UNZIPPER_PKG”, line 12
ORA-06512:at “XXX.UNZIP”, line 4

Here is the code samples:

Read the rest of this entry »

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 specified value is invalid
ORA-00068: invalid value 6360 for parameter parallel_max_servers, must be between 0 and 3600
CKPT (ospid: 22135): terminating the instance due to error 2097

Read the rest of this entry »

With smart phones(android+ios) lots of people want to use apps on their business. Steven Chan published one nice post at his blog…
Enjoy it

 

Mobile Apps for Oracle E-Business Suite

As a DBA We are using export/import utulity many times during our daily process.
I have face this error trying to import only one table from full export.

ORA-39002: invalid operation
ORA-39166: ObjectUSER1.TABLE was not found.

Read the rest of this entry »

We face with this error while We are making 2 node RAC installation

Db version : 11.2.0.4
Os : AIX 7.1

We run root.sh on node 1 without any issue. While we run root.sh node 2 we face this message:

Adding Clusterware entries to inittab
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node Node1, number 1, and is terminating
An active cluster was found during exclusive start-up, restarting to join the cluster
Configure Oracle Grid Infrastructure for a Cluster … succeeded

Read the rest of this entry »

WAIT FOR EMON PROCESS NTFNS

We face this event on our 10.2.0.4.0 database. This is 2 node RAC system which is running on AIX 6.1

Read the rest of this entry »

Follow

Get every new post delivered to your Inbox.

Join 27 other followers