Fuad's Everything Oracle related Weblog

Oracle Openworld 2011 afterthoughts

noreply@blogger.com (Fuad Arshad) — Wed, 26 Oct 2011 18:56:00 +0000

Oracle OpenWorld Came to a close Oct 7. Unfortunately too many issues prevented me from posting anything to this blog.
This year was the Year of the Cloud at Oracle Openworld. Oracle released many products including Exalytics, The Oracle Database Appliance, The Big Data Appliance, Oracle R Enterprise , Oracle Enterprise Manager 12C (Cloud Control) and Oracle in the Cloud. These were just the big announcements but there was alot of fun and learning this year. The RAC Attack OTN Lounge was the best place to hangout since there were so many people to learn from . It is always interesting to meet people from All Aorund the world with a variety of experiences and exposure to so many technologies.

The Bloggers meetup was the culmination and the meeting of all the minds from all over the Oracle Community . Sponsored by the Good old folks at Pythian . This was a very well done and fun event.
My takeaways and the most exciting thing for me has been EM 12C . I plan on playing around with it and understanding how it can benefit me and my team.
It was very sad to be in CA when Steve Jobs died and hearing about it during Larry's big keynote. Truly an inspirational person.
Some funny some Sad pictures from my Days at Openworld .

Oracle Openworld day 1

noreply@blogger.com (Fuad Arshad) — Mon, 03 Oct 2011 13:30:00 +0000

Day 1 here was IOUG Day.
There were a lot of good sessions .

One of my Favorite for the Day was Arup Nanda's Exadata for DBA's . It was very well presented and Arup has already posted the details at his blog.
The RAC Expert Panel SIG was very well done and it seems like most of the questions were related to 11.2.0.3 which was just released Last Week.
The Announcement of the Day was the new member of the Exa family #Exalytics. Exalytics is a BI optimized Server. Larry Ellison announced the new addition to the Family along with his familiar Next Slide Please.
Since BI has not been my area. I'll defer to the pros like Alex Gorbachev to explain and the details are on Alex's Blog.
It Seems Like there will be a flurry of announcement this weeks and stay tuned on this Blog and My twitter Feed as well #oow11.
Some Pics of Day 1 are below for #oow11

Oracle Openworld 2011 My Schedule

noreply@blogger.com (Fuad Arshad) — Sun, 02 Oct 2011 00:07:00 +0000

Below is some of the sessions i intend to attend this Openworld 2011

Oracle openworld day 0

noreply@blogger.com (Fuad Arshad) — Sun, 02 Oct 2011 00:05:00 +0000

Day 0 of oracle openworld is here . Tomorrow the fun begins . Got my registration done and got to see Eddie Awad , Chris muir, Tim Hall , Arup Nanda.
Hoping to meet up with more fellow bloggers soon.
I will mostly be in RAC related sessions tomorrow.
Here are some pics of the registrations.

Oracle openworld 2011

noreply@blogger.com (Fuad Arshad) — Fri, 30 Sep 2011 02:26:00 +0000

Oracle openworld 2011 is almost here . Starting Sunday I will be very active in tweeting as @fuadar an blogging via this blog . This is an exciting year to be at openworld and hopefully there will much to report see and publish

Compatibility parameter and testing

noreply@blogger.com (Fuad Arshad) — Sun, 25 Sep 2011 20:05:00 +0000

As with any upgrade it is very important to have as proper test plan to test your application prior to a database upgrade. DBA's try to work with their application teams to ensure that the test are fair and balanced and go thru many weeks of planning before actually upgrading a major system.
One thing many DBA's do as a precautionary measure is to ensure that a backout plan is in place. For most it might includes backup, flashback or both. Once other medium of protecting your self is the compatibility parameters. After an upgrade the compatibility parameter is most often not changed till the application is stable. The compatibility parameter to a lower value allows for potentially downgrading your database.
But what if your application testing was done with the compatibility parameter not set to the right version. This can cause a lot of headaches for the DBA's and the Application teams that are testing/
Compatibility parameters not only change the redo logs and the control file structure but also allow for oracle to take new code paths. Something that was very painfully evident to us when we migrated from 10.2.0.4 to 11.2.0.2 RAC. The compatibility changed actually caused us a lot of instability due to some new processes that oracle introduced. This change caused us to go from a fully stable system to crashing down every couple of hours.
Unfortunately there is no easy remedy for changing the compatible parameter and we had to work thru the issues. A lesson well learned for us. Testing needs to be done with compatibility changes done on dev and test to ensure process behaviour does not change

GTX Processes in Oracle 11.2.X

noreply@blogger.com (Fuad Arshad) — Sun, 25 Sep 2011 19:54:00 +0000

Oracle Has introduced new processes in Oracle 11 and above to handle XA type processes.
The Parameter global_txn_processes control is you want GTX processes to spawn or not.
If global_txn_processes >0 oracle will autotune in 11.2.0 the amount of gtx processes it needs per node.
these processes are normally used for distributed transactions and for XA based transactions. if you are using the OracleXA dataclass in your jdbc driver. you are probably using DTP or distributed transaction processing.

RAC Attack at Oracle Openworld

noreply@blogger.com (Fuad Arshad) — Sun, 25 Sep 2011 19:45:00 +0000

This year among many things the OTM Lounge will be host to IOUG RAC Attack
Jeremy has information on this wonderful event at this blog. Also if you have experience in RAC installation . please hit up the Rac Attack webpage for more info.
Hope to see everyone there.

The Arrival of #OOW11 and Festivties galore

noreply@blogger.com (Fuad Arshad) — Wed, 14 Sep 2011 14:32:00 +0000

Its that time of the year. Oracle OpenWorld 2011 starts in a few weeks.
Oracle Openworld is host to an insanely massive amount of DBA's architects , developers and vendors. It is a massive Opportunity not only to learn from peers but network with experts, Oracle ACE's and ACE directors.
While i will be posting the sessions i will be attending in a separate post i just thought I'd point out to some of the festivities Like the Bloggers Meetup that is probably the best place to meet the greatest minds that have a real job working on Oracle related Technologies . The Details are on the Pythian Blog and can be read in detail on pythian's blog . An excerpt from the pythian blog is below

"What: Oracle Bloggers Meetup 2011

When: Wed, 5-Oct-2011, 5:00pm

Where: Main Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA 94103"

The Other Festivities include the OTN night Details on the OTN Blog. But one thing is good OTN Lounge is going to be in Howard Street which is awesome again.

One Cool Thing on the OTN Lounge will be RAC SIG stuff

"(Special treat for Oracle RAC fans: Kick back at the OTN Lounge between 9am and 1pm each day of the show with experts from the IOUG RAC SIG, and work together to get an Oracle RAC cluster database running inside virtual machines on your own laptops.)" --From OTN Blog

I' am also hoping Oracle Closed World returns since i was unable to attend any #ocw sessions last year. Thati s a festive geek fest in itself.

Come Join us at Oracle Openworld for lots of fun and learning. and do introduce yourself.

i'm @fuadar on twitter and #OOW11 is the official tag of Oracle OpenWorld 2011

AIX Bug with 64K Memory Pages

noreply@blogger.com (Fuad Arshad) — Thu, 01 Sep 2011 13:17:00 +0000

After our Production Upgrade to 11.2.0.2 on AIX. we hit an AIX Bug relating to AIX starving Oracle from memory pages and thus grinding the system to a halt.. Metalink Doc 1088074.1 talk about this but there was conflicting information thru Doc ID 282036.1 which stops at AIX 6.1 TL5 for this particular bug.
It is the Bug is actually fixed in TL6 SP4 .
We were on TL6 SP2 and thus had a system outage.
Moral of the story is it always pays to ensure to look at future TL's and SP's for AIX to ensure the bug was actually fixed.

Book Review: Expert Oracle Goldengate

noreply@blogger.com (Fuad Arshad) — Sun, 07 Aug 2011 06:55:00 +0000

I was recently provided a copy of Expert Oracle Goldengate for review. The Title Written by Ben Prusinski . Ace Director. Steve Phillips and Richard Chung.
The Book starts with a very well written introduction discussing replication technologies , Their Application and their evolution from Oracle Basic replication to Oracle Streams. This is a very good refresher for people who want to get into replication technologies to understand and seethe different options available in Oracle . I did feel that the authors could have added more to the introduction section but seeing that it was just an intro chapter the length was ok.
Chapter 2 deals with mostly how to download and install the software. The problem with such chapters is that they get dated pretty quickly not only becuase Oracle likes to switch their OTN links on people. The Software updates can cause the chapter to become obsolete fairly quickly but never the less it provided detailed screenshots on the download as well as example configurations and complete installation steps for various platforms.
Chapter 3 is where you start getting absolute value from this book. This Chapter is very well written and goes into a lot of details on how the golden gate architecture . The Authors have tried their best to explain the architecture in excruciating detail.
The Other chapters that makes this book a must have for any goldengate administrator or user include The Chapter on Tuning, Disaster Recovery options and Zero Downtime migration replication.
I'm Planning on keeping this book as a reference on my book Shelf and would recommend this book to anyone using Goldengate.

Kfed saved the Day =ASM Disk Header recovery

noreply@blogger.com (Fuad Arshad) — Thu, 21 Jul 2011 01:37:00 +0000

I just wanted to start this Blogpost as a quick note to myself to investigate and learn about kfed.
I was hit with a situation this morning where during a system migration the ASM headers were overwritten/blanked out in AIX. this was done with a process that is used to provision new ASM Luns in our environment
In AIX you can use
lquerypv -h to see the header of the disk which tells you that it is an ASM disk and what Diskgroup is attached to . if the pvid is cleared from such a disk after the header is written it will clear the header thus allowing for reuse of the disk.
we were stuck with such a situation with my database backup on the same disk and no metadata backup at all. ( Shame on me for not setting up these vital components early enough). This caused panic and chaos . A colleague googled thru and found references to kfed Here , Here and Here.
We looked at all the disk headers using lquerypv and then were able to use kfed repair on each disk to get the headers back.
There aredetails about kfed in the links above and it is still and undocumented oracle utility so use with care. All i can say is kfed saved the day for us in a situation where we were in no hope of recovery.
A nice tool to have and learn about

Small Changes can Break Stuff i.e 11.2 ASMCMD

noreply@blogger.com (Fuad Arshad) — Mon, 28 Mar 2011 20:42:00 +0000

This is a going to be a small post justo to reiterate the fact that Oracle Keeps changing things on us to keep us moving .

In Oracle 11 ASMCMD introduced md_backup and md_restore to help with managing ASM Metadata.

To script around this and make our scripts universal we used

asmcmd -v to detect version and then proceed with backups.

So in 11.1.0.7

oracle@abc:$ asmcmd -v 
asmcmd version 11.1.0.6.0

When i migrated to 11.2.0 for ASM my scripts for metadata backup Started failing

running the same command in 11.2.0 netted

oracle@abc:$ asmcmd -v

WARNING: Tracing levelnot specified

Default level of tracing is enabled.

ASMCMD> exit

In 11.2.0 to get version from ASM is

oracle@abc:$ asmcmd -V

asmcmd version 11.2.0.2.0

Not sure if this behaviour changed in 11.2.0.1 or 11.2.0.2 .

Although it would be nice if Oracle would not reuse the same flag for something else just makes our lives and scripts miserable.

Relinking causes many warning on AIX for 11.2.0

noreply@blogger.com (Fuad Arshad) — Mon, 21 Mar 2011 23:11:00 +0000

As i started applying the first PSU to my 11.2.0.2 instances. I noticed OPatch generating crazy Ld messages

ld: 0711-319="" defined:="" exported="" freeinstance__14txsoqmdm10gtagfv="" not="" symbol="" warning:="">
ld: 0711-319 WARNING: Exported symbol not defined: freeInstance__17TxsOqSQLConstantsFv
ld: 0711-319 WARNING: Exported symbol not defined: freeInstance__19TxsOqPatternMatcherFv
ld: 0711-319 WARNING: Exported symbol not defined: freeInstance__19TxsOqSnapshotCasterFv
ld: 0711-319 WARNING: Exported symbol not defined: freeInstance__21TxsOqExecutionFactoryFv
ld: 0711-319 WARNING: Exported symbol not defined: freeInstance__21TxsOqRollupGIDManagerFv
ld: 0711-319 WARNING: Exported symbol not defined: freeInstance__22TxsOq11gPatternMatcherFv
ld: 0711-319 WARNING: Exported symbol not defined: freeInstance__24TxsOqSQLDerivationFinderFv

This is a Bug and is explained in Relinking causes many warning on AIX [ID 1189533.1].

Apparently all these messages can be ignored

Oracle 11.2.0.2 Memory Bug

noreply@blogger.com (Fuad Arshad) — Sun, 20 Mar 2011 17:56:00 +0000

my installs for 11.2.0.2 were going on . I noticed something peculiar . The Memory utilization on my AIX Box was more than 10.2.0.4 . I looked at it and said well Maybe 11.2.0.2 needs more memory and brushed it off. That was till i read kurtvm's blog.
Apparently there is a bug

This is apparently a bug

From Kurtvm's Blog

Bug 10211065.-P Base Bug 9796810

Abstract: MEMORY FOOTPRINT FOR DEDICATED SERVER PROCESSES MORE THAN DOUBLED AFTER 11G UGP

Bug 9796810.-P Base Bug 10190759

Abstract: 11G SERVER PROCESSES CONSUMING MUCH MORE MEMORY THAT 10G OR 9I

Bug 10190759.-P

Abstract: PROCESSES CONSUMING ADDITIONAL MEMORY DUE TO 'USLA HEAP'

The good news is - there's a 'interim' patch - number 10190759.

On to patching my environments.

Upgrade From Oracle 10.2.0.4 to Oracle 11.2.0.2

noreply@blogger.com (Fuad Arshad) — Thu, 03 Mar 2011 01:57:00 +0000

Below is a simple GUI Method to upgrade your Database from 10.2.0.4 to 11.2.0.2
As part of the upgrade Process from 10.2.0.4 the First Step will be to check the Database for issues.
The Process will be to first install the 11.2.0.2 Software. And the run the @utlu112i.sql which is available in your new Software Home $NEW_ORACLE_HOME/rdbms/admin
Once you run this against your old system
You will see a result like this
-- Start Oracle Upgrade Tool --

Oracle Database 11.2 Pre-Upgrade Information Tool 02-23-2011 13:44:07
Script Version: 11.2.0.2.0 Build: 001
Database:
--> name: DTESTDB
--> version: 10.2.0.4.0
--> compatible: 10.2.0.4
--> blocksize: 8192
--> platform: AIX-Based Systems (64-bit)
--> timezone file: V4
Tablespaces: [make adjustments in the current environment]
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 2635 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 440 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 61 MB
--> UNDO_01 tablespace is adequate for the upgrade.
.... minimum required size: 32 MB.
**********************************************************************
Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]
Note: Pre-upgrade tool was run on a lower version 64-bit database.
**********************************************************************
--> If Target Oracle is 32-Bit, refer here for Update Parameters:
-- No update parameter changes are required.
.--> If Target Oracle is 64-Bit, refer here for Update Parameters:
-- No update parameter changes are required.
.**********************************************************************
Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
-- No renamed parameters found. No changes are required.
.**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
Remove all Parameterw listed in here
.**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
Check If anything is Invalid .
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --> Database contains INVALID objects prior to upgrade.
.... The list of invalid SYS/SYSTEM objects was written to
.... registry$sys_inv_objs.
.... The list of non-SYS/SYSTEM objects was written to
.... registry$nonsys_inv_objs.
.... Use utluiobj.sql after the upgrade to identify any new invalid
.... objects due to the upgrade.
.... USER PUBLIC has 7 INVALID objects.
WARNING: --> Your recycle bin is turned on and currently contains no objects.
.... Because it is REQUIRED that the recycle bin be empty prior to upgrading
.... and your recycle bin is turned on, you may need to execute the command:
PURGE DBA_RECYCLEBIN
.... prior to executing your upgrade to confirm the recycle bin is empty.
.**********************************************************************
Recommendations
**********************************************************************
Oracle recommends gathering dictionary statistics prior to upgrading the database.
To gather dictionary statistics execute the following command
while connected as SYSDBA:
EXECUTE dbms_stats.gather_dictionary_stats;
**********************************************************************
Oracle recommends removing all hidden parameters prior to upgrading.
To view existing hidden parameters execute the following command
while connected AS SYSDBA:
SELECT name,description from SYS.V$PARAMETER WHERE name
LIKE '\_%' ESCAPE '\'
Changes will need to be made in the init.ora or spfile.
**********************************************************************
Oracle recommends reviewing any defined events prior to upgrading.
To view existing non-default events execute the following commands
while connected AS SYSDBA:
Events:
SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2
WHERE UPPER(name) ='EVENT' AND isdefault='FALSE'
Trace Events:
SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2
WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'
--- End Oracle Upgrade Tool -----
After The Process is complete . Start ./dbua

As part of the Upgrade you have an option to Move the datafiles. In this we have chosen no

If you are fine with this Please Proceed . it is recommended that you upgrade your TimeZone File

Please Select Next and A warning will show up if you have decided not to turn off archiving

Select the new Values for you FRA & Diag Dest

Select Grid Control of DB Control Options

Add in the Passwords

It will provide with a summary

Oracle will now start the upgrade Process

This will complete and

Technorati Tags: oracle

Oracle 11.2.0.2 Software Install Guide

noreply@blogger.com (Fuad Arshad) — Mon, 21 Feb 2011 16:26:00 +0000

In the second part of the series of Installing Oracle Software here is the Installing the Database Software for a single instance system

This Document will graphically explain the Installation Process for Oracle 11.2.0.2 Database . Oracle 11.2.0.2 Database is used to either create a new Oracle Database or upgrade an existing Database.
The Images/Installation were performed on a system running AIX 6.1.6.2

The First step is to run rootpre.sh. If you have ASM . ensure the Grid Infrastructure guiide is followed first. if rootpre.sh fails due to clusterware running and you have upgraded ASM to 11.2 . You can ignore the messages and then execute ./runInstaller --- Please note setting up X is not in the realm of this document.

After you pass the initial screen. Select do not install updates and do not type in your Oracle Support ID and password.

The Second Screen Will provide you the following options. You can select Software only if you intend to do a software install for upgrade later.

Once you Select Install you will get the Screen below below . Our Goal is to install Software for a single instance based database & Select English as your language

The next option talks about the editions of Oracle . Based on your license agreements. Select the appropriate version. We will select Enterprise for this installation. Please note the space requirements are also listed below

The select options screen at the bottom allows for selecting specific options. Select the options appropriate to your needs.

Next screen you will ne asked to enter ORACLE_BASE and Software Home Directory

If you select a home directory that is the same as the user directory if will prompt youand let you know that Oracle Recommends not using the User Home Directory for the ORACLE_BASE .

You can say yes if you are sure .

Next Step will ask you for OS Groups. Please follow your standard security practice for selecting OS Groups . For purposes of this install i will select dba for all groups.

After This the software will start checks to ensure all OS Level parameters requirements are met. The Recommendation is to always use RDA first . ./rda.sh –T hcve will give you a good overview of your system and ensure that the prerequisite checks are met prior to starting a software install.After the checks Oracle will now provide a script that will work on fixing the prerequisites that are missing .

After the fixup scripts are run in conjunction with the sysadmins. run Check Again and reso,lve any ourstandign issue. If issues are non mandatory you can check ignore all and continue

After making sure all the values are right Select next and the install process will start

On AIX 6.1 You might Hit bug #Bug:10259393 talked about in ID 1264074.1 . An AIX APAR will be required based on the version . THE AIX APAR might be different based on your configuration For AIX 6.1 TL6, IBM have released fix IZ88711:

If you get an Error during Linking that has similar attributes as described in the above note just Press continue . Relinking the agent is explained in the doc above after the APAR is installed.
After the install Has completed . Run or have your Sysadmins run root.sh and the software install is complete.

You have now completed the install for Oracle 11.2.0.2 Software .

Publish Post

New deinstall utility in Oracle 11.2

noreply@blogger.com (Fuad Arshad) — Tue, 15 Feb 2011 21:26:00 +0000

Oracle 11.2 Now does not allow you to deinstall software via the OUI interface directory . Any Requests for software deinstallation using the OUI will tell you to use the deinstall utility

There is a new utility know as deinstall available in $ORACLE_HOME/deinstall that allows for deinstallation

$ORACLE_HOME/deinstall/deinstall will allow for deinstallation in the form shown below

The deinstall process will cleanly deinstall the software and detach the Oracle Home.

######ORACLE DEINSTALL & DECONFIG TOOL START ############

Checking for existence of the Oracle home location /oracle/product/11.2.0/db_1
Oracle Home type selected for de-install is: SIDB
Oracle Base selected for de-install is: //oracle
Checking for existence of central inventory location /oracle/oraInventory

Install check configuration END

Skipping Windows and .NET products configuration check

Checking Windows and .NET products configuration END

Network Configuration check config START

Network de-configuration trace file location: /oracle/oraInventory/logs/netdc_check2011-02-14_10-32-02-AM.log

Network Configuration check config END

Database Check Configuration START

Database de-configuration trace file location: /oracle/oraInventory/logs/databasedc_check2011-02-14_10-32-02-AM.log

Use comma as separator when specifying list of values as input

Specify the list of database names that are configured in this Oracle home []:
Database Check Configuration END

Enterprise Manager Configuration Assistant START

EMCA de-configuration trace file location: /usr/local/oracle/oraInventory/logs/emcadc_check2011-02-14_10-32-12-AM.log

Enterprise Manager Configuration Assistant END
Oracle Configuration Manager check START
OCM check log file location : //oraInventory/logs/ocm_check9011.log
Oracle Configuration Manager check END

Grid Control targets losing Config information

noreply@blogger.com (Fuad Arshad) — Sun, 13 Feb 2011 21:17:00 +0000

ew year New interesting issues.
This time we had a fellow DBA come to discuss why this one particular database keeps moving bad to metric collection error with database not configured anymore.

The Agent logs $AGENT_HOME/sysman/log/emagent.trc showed for this target
011-01-03 02:36:38,423 Thread-3643 WARN vpxoci: OCI Error -- ErrorCode(1008): ORA-01008: not all variables bound
On doing some more debugging. this issue showed up to be a specific issue with Oracle 10.2.0.3 and cursor_sharing as described in ID 422118.1.
The Workaround is to change the cursor sharing from similar to exact and flushing the shared pool.
Please also Note in Oracle 11 Cursor_sharing=similar has already been deprecated per Note # 1169017.1

Virtual Box 4.0 Is Out

noreply@blogger.com (Fuad Arshad) — Sun, 13 Feb 2011 21:16:00 +0000

Although the check for updates didnt work . Virtual Box 4.0
http://www.virtualbox.org
Change log is here
http://www.virtualbox.org/wiki/Changelog
Enjoy the upgrade

Grid Control 10.2.0.5 AIX Alert

noreply@blogger.com (Fuad Arshad) — Sun, 13 Feb 2011 21:15:00 +0000

If you are using Oracle Enterprise Manager Grid Control. Please be aware of a security certificate expiring on Dec 31. This is critical since your agents will not communicate to the OMS thus causing issues in your monitoring infrastructure.
From the Oracle Note
"What is the Issue?
Enterprise Manager Grid Control installations configured to use the Secure Sockets Layer (SSL) protocol utilize a self-signed Certificate Authority (CA) which is stored in the Oracle Management Repository.
For the 10.2.0.5 release of Grid Control on AIX 5L, this Certificate Authority will expire on 31-Dec-2010 00:00:00, which will cause SSL authentication to fail.. This issue affects Oracle Management Service (OMS) 10.2.0.5 on AIX 5L, as well as SSL communication from all new 10.2.0.5 Management Agents on AIX 5L (regardless of OMS platform/release) added after 31-Dec-2010 00:00:00.
Note that this communication issue is specific to Enterprise Manager Grid Control release 10.2.0.5 on the AIX 5L platform only."
Please refer to MOS Note Note 1171558.1 for more info.
Update: I just added a copy of the Email we recieved. Seems like people didnt know about this . Not sure how MOS targets its emails for alerts like these. GC_Alert_OCT-10

Book Review - SQL Pocket Guide By Jonathan Gennick

noreply@blogger.com (Fuad Arshad) — Sun, 13 Feb 2011 21:15:00 +0000

SQL Pocket Guide by Jonathan Gennick is book that addresses SQL across multiple platforms. The Book tries to talk about SQL syntax across the major databases, which include Oracle 11Gr2, DB2 9.7, Postgres SQL and SQL Server. Not All SQL is standard and variations of SQL in terms of Syntax are clearly highlighted and explained. The Book is written by Jonathan Gennick whose previous titles include SQL* Plus a definitive guide, Books on SQL Loader & regular expressions.
The SQL Pocket Guide is not a guide that is meant for cover-to-cover reading. This Book is rather a keep for the times when you need to find examples for SQL. Since my work with SQL has been for Oracle based Databases. I was intrigued by how SQL compares between Database vendors. E.g., CAST function was explained and pros and cons explained were brought to light that SQL Server has a better function called CONVERT that does a better job than CASE.
In This Age of Google searches and trying to find solutions in form of a web search, I feel Books Like these still play their part and should be in the arsenal of every Database Professional. While I did not read the entire book, the sections I scanned thru and the statements I used were definitely well explained and examples were of good value. The Book provides and easy reference with good online examples that can be downloaded and used to test syntax.
Further Book Details can be found here.

Querying EM Grid Control data

noreply@blogger.com (Fuad Arshad) — Sun, 13 Feb 2011 21:14:00 +0000

EM Grid Control provides lots of benefits in the enterprise. Most people discuss Grid Control in the context if Diagnostic Packs and Tuning Packs which Grid Control has a nice interface to, but Grid Control has a wealth of other information built into it.
I was recently asked by a colleague to help him find all the Listener ports that were being used in the Enterprise .
While Grid Control Doesn't provide a default report for this . All the data is available in the Grid Control repository. A Simple Table Based report based on the below query can be used to get that data

SELECT mgmt$target.host_name,mgmt$target.target_name,mgmt$target.target_type,mgmt$target_properties.property_name,mgmt$target_properties.property_value
FROM mgmt$target, mgmt$target_properties
WHERE (mgmt$target.target_name = mgmt$target_properties.target_name)
AND (mgmt$target.target_type = mgmt$target_properties.target_type)
and (mgmt$target.target_type='oracle_listener')
and (mgmt$target_properties.property_name='Port');

The Above SQL Will Display all Listener's and their ports.
the MGMT$target and mgmt$target_properties can provide and great deal of other options and reports based on Block Sizes and other parameters set can be used to quickly find issues in your enterprise.
P.S The above query is based on the Grid Control 10.2.0.5 Repository

PSU and Upgrades

noreply@blogger.com (Fuad Arshad) — Sun, 13 Feb 2011 21:13:00 +0000

While upgrading one of the instances on a server . We hit an error
ORA-00600: internal error code, arguments: [kccgtt_1], [3], [], [], [], [], [],
The Error was interesting and points to an aspect of the prechecks that we hadnt explored before. Differences in PSU Levels between Homes. The Database Home was installed recently and since it was a new Home the latest PSU was applied. What wasnt done was checking the ASM Home for the PSU level. Turns out ASM Home has 11.1.0.7.2 vs Database Home having 11.1.0.7.4. ASM has to follow the rule of Same or Higher patch level the the highest level of Database version.
Once ASM was Patched All was well but it just adds another layer of checking that DBA's have to do when installing or Upgrading Oracle.

11.1 DBUA & Blanks/Spaces

noreply@blogger.com (Fuad Arshad) — Sun, 13 Feb 2011 21:12:00 +0000

As part of a routine upgrade to 11.1 we decided to use dbua to complete all the upgrade tasks. Dev & test were a breeze but the DBUA screens on Production came with a Big OK Sign with no info whatsoever. It was kind of annoying but after digging into $ORACLE_BASE/cfgtoologs/dbua/logs was able to Find the error to be
java.util.StringTokenizer.nextToken(StringTokenizer.java:259)
oracle.sysman.assistants.util.attributes.InitParamAttributes.loadInitParams(InitParamAttributes.java
:1763)
oracle.sysman.assistants.dbma.backend.Database.updateNonDefaultInitParams(Database.java:1068)
oracle.sysman.assistants.dbma.backend.CompManager.obtainDatabaseInformation(CompManager.java:2272)
Metalink search came up with a error in the DBUA utility for 10R2 (Oracle Please update that this issue exists in 11 also). Note id # 444148.1 describes the situation as a parameter that have single quotes.
in our case i had smtp_out_server=' ' . This cause dbua to unable to parse the spfile.
Solution was to create a pfile remove this parameter and proceed. DBUA Proceeded to next step after this