Author Archives: Ugurcan

About Ugurcan

Exadata Engineer

Management Server(MS) running on database nodes.

From exadata database machine administration guide: “Starting with Oracle Exadata Database Machine 12.1.2.1.0 The database nodes now run the Management Server (MS). Previously MS ran only on the storage nodes. The database nodes now run a new service called Database … Continue reading

Posted in Oracle Database | Leave a comment

PRVG-10603 : Clusterware version consistency failed

I got this error while upgrading my grid version from 11.2.0.3 to 11.2.0.4 on Linux box. ./cluvfy stage -pre crsinst -upgrade -n node01,node02-rolling  -src_crshome /optware/grid/11.2.0.3 -dest_crshome /optware/grid/11.2.0.4 -dest_version 11.2.0.4.0 -fixup -fixupdir /orabase/grid/fixup -verbose Here is the error: PRVF-4038 : CRS … Continue reading

Posted in Oracle Database | Leave a comment

How to move execution plan to another database using SQLHC/SQLT

One of my  query has different execution plan on both databases. One is running faster but the other is not.So I decided to move faster execution plan to slow database. On faster database, SQL> @sqlt/utl/coe_xfr_sql_profile.sql  SQL_ID PLAN_HASH_VALUE This will create … Continue reading

Posted in Oracle Database | Leave a comment

Why my tablespace report is slow on one of my databases ?

Application team started complain about getting table space report is too slow.When I checked it, It took 20 min to get report. But I can get the same report in a sec. from other databases. I executed SQL script and get … Continue reading

Posted in Oracle Database | Leave a comment

To Index or Not to Index on Exadata System

I started reading Expert Oracle Exadata 2nd Edition yesterday,I read 1 st edition before. I can say if you like working with Exadata ,you should read this book. When the topic comes to Exadata, one of the popular discussion is … Continue reading

Posted in Oracle Database | Leave a comment

ORA-4030 Error during SQL Loader –mmap(offset=207343616, len=8192) failed with errno=12 for the file oracle***

I got these error during sqlldr process. In the trace file, I’m seeing lot of mmap error. This process using tons of map entries. mmap(offset=207343616, len=8192) failed with errno=12 for the file oracle***1B mmap(offset=207343616, len=8192) failed with errno=12 for the … Continue reading

Posted in ORA-4030 | Leave a comment

is Http service enabled on Web ILOM Url ?

What if your https:///iPages/i_login.asp doesn’t work ? connnect ILOM IP with ssh connection, set /SP/services/http servicestate=enabled Set ’servicestate’ to ’enabled’ and then invoke your address again https:///iPages/i_login.asp

Posted in exadata | Leave a comment