Publisher says Outstanding Orders to be filled soon

Friends,

I have heard back from the publisher today. They have printed enough copies to fill the demand. All outstanding orders should be filled within the next two weeks. The demand was higher than expected and caught them off guard. That is actually good news that the book is selling better than expected. Moving forward there will be sufficient copies available to satisfy everyone.

Thanks for the great support from all my readers.

You can place an order for the book by clicking on the title below. An out of stock warning may appear right now, but you can safely ignore that. A description of the book is as follows.

Oracle Enterprise Manager Grid Control: Advanced OEM Techniques for the Real World

Oracle’s Enterprise Manager Grid Control is recognized as the IT Industry’s leading Oracle stack (application to disk) administration and management tool. It is unrivalled in its ability to monitor, manage, maintain and report on entire enterprise grids that comprise hundreds (if not thousands) of Oracle databases, middle-ware and servers following an approach that is consistent and repeatable, as well as the Oracle Applications such as Oracle E-Business Suite, PeopleSoft, Siebel, and so on.

However, Enterprise Manager Grid Control may seem daunting even to the most advanced Oracle Administrator. The problem is you know about the power of Enterprise Manager but how do you unleash that power amongst what initially appears to be a maze of GUI-based screens that feature a myriad of links to reports and management tasks that in turn lead you to even more reports and management tasks?

This book shows you how to unleash that power.

Based on the Author’s considerable and practical Oracle database and Enterprise Manager Grid Control experience you will learn through illustrated examples how to create and schedule RMAN backups, generate Data Guard Standbys, clone databases and Oracle Homes and patch databases across hundreds and thousands of databases. You will learn how you can unlock the power of the Enterprise Manager Grid Control Packs, PlugIns and Connectors to simplify your database administration across your company’s database network, as also the management and monitoring of important Service Level Agreements (SLAs), and the nuances of all important real-time change control using Enterprise Manager.

There are other books on the market that describe how to install and configure Enterprise Manager but until now they haven’t explained using a simple and illustrated approach how to get the most out of your Enterprise Manager. This book does just that.

Regards,

Porus.

New White Paper Published "Managing Oracle Applications with EM"

Friends,

I am pleased to announce that a brand new white paper of mine has been published this month (June 2011) on the Oracle Technical Network (OTN):

White Paper: Managing Oracle Applications with Oracle Enterprise Manager 11g

This white paper delves into the four Oracle Application Management Suites for Oracle’s E-Business Suite, Siebel, PeopleSoft and JD Edwards EnterpriseOne products and examines the many management capabilities that they offer for Oracle Applications. It is geared towards Oracle application managers and application administrators, with a goal to provide a clear understanding of the immense advantages and benefits the Application Management suites have to offer. It is a fantastic introduction to these powerful Application Management Suites of Oracle Enterprise Manager. Enjoy the world of Oracle EM !

Some comments in LinkedIn groups:

"Many congrats and really appreciate the efforts for the documentation on E-Biz related features. Highly informative. Its indeed a powerful EM :-)."

"Nice improvement over previous versions of EM! "

"This white paper is very useful for our jobs!"

"Hey .. Great white paper very valuable."

"Thanks for sharing this, very useful."

Thanks people for appreciating the white paper.

Regards,

Porus.

My New EM11g Book is in stock now

I am pleased to say my first EM11g book is in stock and is being delivered now.

Thanks to all my readers for their patience. The book is not very expensive,

only $19.95 USD (30% off if ordered now).

http://www.rampant-books.com/book_1001_advanced_techniques_oem_grid_control.htm

Oracle Enterprise Manager Grid Control: Advanced OEM Techniques for the Real World

Oracle’s Enterprise Manager Grid Control is recognized as the IT Industry’s leading Oracle database administration and management tool. It is unrivalled in its ability to monitor, manage, maintain and report on entire enterprise grids that comprise hundreds (if not thousands) of Oracle databases and servers following an approach that is consistent and repeatable.

However, Enterprise Manager Grid Control may seem daunting even to the most advanced Oracle Administrator. The problem is you know about the power of Enterprise Manager but how do you unleash that power amongst what initially appears to be a maze of GUI-based screens that feature a myriad of links to reports and management tasks that in turn lead you to even more reports and management tasks?

This book shows you how to unleash that power.

Based on the Author’s considerable and practical Oracle database and Enterprise Manager Grid Control experience you will learn through illustrated examples how to create and schedule RMAN backups, generate Data Guard Standbys, clone databases and Oracle Homes and patch databases across hundreds and thousands of databases. You will learn how you can unlock the power of the Enterprise Manager Grid Control Packs, PlugIns and Connectors to simplify your database administration across your company’s database network, as also the management and monitoring of important Service Level Agreements (SLAs), and the nuances of all important real-time change control using Enterprise Manager.

There are other books on the market that describe how to install and configure Enterprise Manager but until now they haven’t explained using a simple and illustrated approach how to get the most out of your Enterprise Manager. This book does just that.

Covers the NEW Enterprise Manager Grid Control 11g.

Regards,

Porus.

Managing PeopleSoft with Enterprise Manager

Good blog post by Oracle ACE Nicolas Gasparotto on managing PeopleSoft installations with Oracle Enterprise Manager 11g.

http://gasparotto.blogspot.com/2011/04/manage-peoplesoft-with-oem-grid-control.html

News from my publisher

News from my publisher: Due to unforeseen printer-related delays for my EM Book, orders placed for the book may not have been delivered so far. The publisher is now using a new printer and expects to start delivery of my EM book very soon. If you have already placed an order, please wait another week or so for delivery. Thanks for your patience.

Regards,

Porus.

Latest List of my Published White Papers and Technical Articles on OTN

Many of you have asked me for a full list of all my published technical articles/white papers on the Oracle Technical Network (OTN), for easy reference. Here is the latest list as of Oct 2012. I have placed the white papers at the top, and the articles are in chronological order in the article list. The latest article on Enterprise Manager Cloud Control 12c, published in October 2012, is right at the bottom of the list. A couple of these articles were even in the most popular OTN article list in 2009.

My Published White Papers on Oracle Technology Network (OTN)

White Paper: Advanced Uses of Oracle Enterprise Manager 11g
White Paper: Managing Oracle Applications with Oracle Enterprise Manager 11g

My Published Articles on Oracle Technology Network (OTN)
Using Grid Control with Filer Snapshotting
Oracle Enterprise Manager Grid Control Architecture for Very Large Sites
Oracle RMAN Backups: Pushing the "Easy" Button
Patch a Thousand Databases, Using Oracle Enterprise Manager Grid Control
Easy Disaster Proof Production with Grid Control
Using Oracle GoldenGate for Real-Time Data Integration
Mask Your Secrets Using Oracle Enterprise Manager
Manage Mass Provisioning Using Oracle Enterprise Manager Grid Control

Overview of Oracle EM Management Packs

Provision Your Oracle RAC Systems Using Oracle Enterprise Manager
NEW!! Ease the Chaos with Automated Patching: Oracle Enterprise Manager Cloud Control 12c

Happy Reading

New EM Provisioning Article published on Oracle Technical Network

Dear Friends,

Happy Deepavali (Indian Festival of Lights).

I am pleased to announce that a new article of mine has been published on the Oracle Technical Network in November 2010:

Manage Mass Provisioning Using Oracle Enterprise Manager Grid Control

http://www.oracle.com/technetwork/articles/mass-provisioning-177500.html

Learn how to provision literally hundreds or even thousands of systems using the mass provisioning techniques described here. The Deployment Procedures supplied by Oracle for provisioning, really make it a simple process.

Regards,

Porus.

New Links to my OTN articles on EM

The Oracle Technical Network (OTN) recently upgraded its site and in the process there are new links to my articles that have been published on the OTN site in the past few years. Here are the new links, please use these from now on:

My Published Oracle White Paper
Advanced Uses of Oracle Enterprise Manager 11g

My Published Articles on The Oracle Technology Network (OTN):

Using Grid Control with Filer Snapshotting

Oracle Enterprise Manager Grid Control Architecture for Very Large Sites

Oracle RMAN Backups: Pushing the "Easy" Button

Patch a Thousand Databases, Using Oracle Enterprise Manager Grid Control

Easy Disaster Proof Production with Grid Control

Using Oracle GoldenGate for Real-Time Data Integration

Mask Your Secrets Using Oracle Enterprise Manager

Oracle Enterprise Manager 11g Grid Control simplifies RAC management in Oracle Exadata V2

In Oracle Database 11g Release 2, which is the latest version of the database used in Oracle Exadata Version 2, RAC install and management is vastly simplified especially if you are using Oracle Enterprise Manager 11g Grid Control.

As an example of the installation ease, 11gR2 RAC features the new ASM Cluster File System (ACFS) on which the Cluster voting disk and Cluster Registry (OCR) can be stored seamlessly during installation, so much so that new DBAs may not even know about these files (in previous versions, they had to be stored very carefully on raw devices). This means the installation is a lot more streamlined and efficient - the improvement in each version of RAC is obvious.

The actual setup of the RAC database on Oracle Exadata V2 is done by Oracle Advanced Customer Services (ACS) at this point, a cutting-edge support team in Oracle. After the database is setup, data migration can be done using a variety of methods, including the new and powerful Oracle GoldenGate.

So the path to move to Exadata V2 has been greatly steamlined and well thought out by Oracle.

More comments on Grid Control Book

Friends, here are a few more comments that I received on my upcoming book on Grid Control:

I read the briefing on OTN hope I buy the book and will see how it can help.
Between Grid, cloud and RAC the concept is still a bit cloudy.

Congratulation for this achievement & Thanks for telling. I will wait for
this to be available in market.

Porus, Its great to know that finally some one wrote a very valuable book
for all of us. But I would strongly recommend if you could add additionally
topics related to setting Events, alerts, strategies used in practical
production environments and also customizing the reports, Dashboards and adding
additional few steps to add layer of analytical queries (using the Metadata) to
create ITIL based reporting using various Mgmt repository tables. That way not
only DBA's can use GRID but it can help the Upper Management as well.

My reply:

Thanks guys. Great to know that you appreciate the book. Yes, definitely I have some ITIL content with customization of a few reports. I am not concentrating on events and alerts, I think every other book does that - they look at the "monitoring" aspects of Grid Control and seem to forget the "management" aspects. For eg. Service level management.

Lots of interest in new book

Friends, I have received lots of interest in my new upcoming book (http://www.rampant-books.com/book_1001_advanced_techniques_oem_grid_control.htm), thanks for that.
Here are some of your comments, thanks a lot guys. The book is to be published this Fall 2010.

That is a fantastic news Porus. I will definitely read this book. Do let me
know once it is out in the market. All the very best to your book.

Congrats Sir, will spread the mail around to all my tech staffs.

Congradulations!!! I will look for it.

Congratz on publishing the new book Porus.

Congratulations on the new book. I am wondering if there is a way to get an advance copy of this book either in electronic format or in physical format? I am very interested in this subject.

Porus - Congratulations on completing the book. I will like to get a copy for myself once available in the market.

Well done on putting the book together.I will keep an eye out for it downunder in Australia.

Congratulations on the publication of your New Book!

Eager enough to buy your book on Grid Control as we have installed 10g Grid Control in our environment and I'm sure it'll be boon to us.

Congratulations Porus. Will definetly by it! I with you to finish this book with success.

Congrats !!! Looking a lot more like this....

Congratulations !I am sure that will help lots of DBAs to upgrade from DBA v1.0 to DBA v2.0 in Oracle's terminology.

Good Luck with this.

Congratulations big achievement

Went through the details of your book, it's really a comprehensive guide for the GC guys. Best of luck for your efforts & continue with you endeavour.

Good Luck Porus, would be an interesting read.

My New Grid Control book

Friends,

I am pleased to announce that my new book "Oracle Enterprise Manager Grid Control: Advanced OEM Techniques for the Real World" is getting ready to be published soon (Fall 2010) by Rampant Techpress:

http://www.rampant-books.com/book_1001_advanced_techniques_oem_grid_control.htm

Please do recommend to all your friends and colleagues, it is a great handy book if you really want to make best use of Oracle Enterprise Manager Grid Control.

I have based it on a lot of practical experience and I am sure it will be useful to a lot of you.

Regards,

Porus Homi Havewala
(Oracle ACE Director).

Easy Disaster Proof Production : My New OTN Article published

I am pleased to announce that in the first month of the new year 2010, a brand-new technical article of mine has been published on the Oracle Technology Network :

Easy Disaster Proof Production with Grid Control
http://www.oracle.com/technology/pub/articles/havewala-easydr.html

The article, based on personal real-life experience, explains how the use of Oracle Enterprise Manager Grid Control for Data Guard setup, management (including switchover or failover), and monitoring can save a lot of time and resources.

Please read, enjoy and recommend to your friends and colleagues.

A Happy New Year 2010 to all of you. All the Best for the New Year.

Regards,

Porus Homi Havewala
(Oracle ACE Director).

Most Popular OTN articles in 2009 - two of my articles on Enterprise Manager

Fellow Readers,

Great News. The Oracle Technology Network (OTN) has just published
the list of Most Popular OTN articles in 2009 and two of my articles
on Enterprise Manager are in the list.

http://blogs.oracle.com/otn/2009/11/the_most_popular_articles_and.html

The OTN is the world's largest community of Developers, DBAs and Architects.
The two articles of mine in the top 10 are:

Oracle RMAN Backups: Pushing the "Easy" Button
Oracle Enterprise Manager Grid Control Architecture for Very Large Sites

Thanks for the tremendous support of the readers on this topic. My aim is to make Grid Control popular among the DBA and IT community, it really is a fantastic product that makes our lives easier.

Regards,

Porus.

Final 2009 seminar on Oracle Performance Options, Products and Enterprise Manager Packs

This Friday, I conducted another interesting seminar which was S&I System's last Oracle seminar for the year. The topic was Oracle Performance Options, Products and Enterprise Manager Packs.

These were the topics I covered. The clients were introduced to many new Oracle concepts for the first time.

• Partitioning Option, and improvements in 11gR2
• Parallel Query Option, and improvements in 11gR2
• Advanced Compression Option (11g), and Hybrid Columnar Compression in 11gR2
• Active Data Guard (11g)
• In-memory Database Cache (Times-Ten), and it's Grid in 11gR2
• Enterprise Manager Diagnostics and Tuning Packs
  

The following Enterprise Manager packs were also demonstrated in live demos:

• Service Level Management Pack
• Configuration Management Pack
• Diagnostics and Tuning Packs
• Remedy Connector
  

I also demo'ed the new Enterprise Manager feature of SQL Monitoring of long-running SQL in 11g databases, which suitably impressed the attendees.

A number of clients immediately expressed interest in using the Service Level Management and Configuration Management packs for their hundreds of database targets, and discussed Grid Control architecture for such large systems.

The 2009 list of successful Oracle seminars conducted by S&I Systems can be seen on:

http://www.si-asia.com/marketing/oracleworkshops2009/

EM Desktop Widgets released

Rejeeb Mohammed, User Experience Designer in the EM User Experience Team has sent the following information:

I am so pleased to let you know that, EM grid control team has released the
first set of desktop widgets in oracle open world. EM Desktop Widgets are
lightweight internet applications ( built in Adobe's AIR environment) that
provide persistent desktop access to key Enterprise Manager monitoring and
diagnostic information.

There are 3 widgets available in the initial
release:

Target Search & Monitoring : This widget provides rapid
access to EM targets through quick and easy target searching. Also you can mark
targets as your favorites and monitor their status in real time.

High
Load DB : Provides a summary of the top 5 databases ordered by the Average
Active Sessions performance or load metric.

Service Level and
Monitoring: This widget provides a summary view of a set of services including
the service status and availability, and a status of SLA’s associated with the
service including any alerts.

I encourage you to download the widgets
from http://www.oracle.com/technology/products/oem/widgets/index.html,
and use them.

We absolutely need your feedback to determine what's good
and what's not with the current widgets. We will use this information to
determine the direction of future widgets.

Some more feedback on the article

Some more feedback on the article:

Another DBA wrote: "Porus, you are the man ... would love to go through your articles. Digging my heels back in Oracle after a while and I intend to go through your articles while in the process. Great Stuff. Great Work."

Another Team leader said:

"I went through some of your papers and they are really amazing I must say. I like the article on Grid Control Architecture and RMAN very much, as we often get this questions from the customers but do not know where to look for. This really gives a very good insight."

Thanks guys for your appreciation of the articles. I wrote them specifically to convince customers that the time is right to use Grid Control. I am happy that you and other readers like them.

Oracle ACE Director Meeting in USA

On an invitation from Oracle Corporation, I attended the Oracle ACE Director meeting at the Oracle HQ in Redwood Shores, California.

Oracle had everyone at the meeting sign a non-disclosure agreement so we cant say much about what was discussed. The main discussions were on Fusion Middleware.

One interesting probability for the future is that Weblogic server will be big in everything - including Enterprise Manager. This will enable Grid Control to scale enormously.

The ACE Director meeting was followed by the ODTUG conference in Monterey, California where I met industry stalwarts such as Tom Kyte, Don Burleson, and Cary Millsap.

A few photos of my trip to the Oracle HQ are enclosed.

Grid Control 10g Release 5 is out!!!

Grid Control 10g Release 5 is out since Wednesday morning, a lot of people were eagerly awaiting this release. I attended the Global launch Webcast on Tues., March 3, 9am PT which was 1 AM Singapore time. Richard Sarwal, Oracle SVP of Product Development, conducted the talk and slideshow. Towards the end of the demo, it was mentioned that Release 5 was now available for download from OTN. Both Windows and Linux versions are available. I downloaded it overnight and will install it soon. Files more than 2 GB for full download.

Main plus points of Release 5, from what I could gather, are:

1. Most stable release of Grid Control 10g and with the best performance
2. Manages Oracle VM for the first time
3. Manages Oracle Weblogic Server, apps and Service Bus
4. Real User Experience Insight (RUEI) with E-Biz, Peoplesoft and Siebel Accelerators
5. Oracle Communications Billing and Revenue Management
6. Oracle Beehive Management
7. Oracle Coherence Management
8. Supports ADDM for RAC for the first time
9. Real Time SQL monitoring, Automatic Sql tuning
10. Now supports 11g's new advisors such as Partition Advisor, Data Recovery Advisor
11. Now supports Database Vault
12. Secure Cloning and Masking = Automate masking of sensitive production data while cloning. Masking has been enhanced with deterministic masks, compound masks etc.
13. Application Diagnostics for Java = always-on, real-time, deploy on any Java server, JVM, or JRockit
14. Configuration Management detects unauthorized changes in real time. Continuous change capture for os, database, middleware and applications
15. Configuration Management now integrates Enterprise Manager with My Oracle Support so you can upload configurations directly to My Oracle Support
16. Database Replay automation now can capture workloads from 9.2.0.8 onwards.

Enjoy!!!

POC: Customized Patch Reports for Grid Control

This is part of the Grid Control POC we recently arranged for a large client.


As per the earlier post on the issue of patch reports, the supplied out-of-box
reports show the patch, bugs fixed, installation time, Host, Home directory
and Platform. The reports do not show the databases, the reason being that
the patch is actually at the Oracle Home level and not at the database level.
If you wish to add in the database name, it is possible to modify the report by
creating a copy and then modifying the Sql statement. For example the
above report is from this statement that can be modified:


SELECT distinct
patch as PATCH,
bugs as BUGS,
installation_time as TIMESTAMP,
host as HOST,
home_location as HOME_DIRECTORY,
platform as PLATFORM
from mgmt$applied_patches patch,
mgmt$em_homes_platform home,
mgmt$target tgt
where home.HOME_ID = patch.CONTAINER_GUID
and patch.target_guid = tgt.target_guid
and patch.installation_time>MGMT_VIEW_UTIL.ADJUST_TZ(??EMIP_BIND_START_DATE??,??EMIP_BIND_TIMEZONE_REGION??,tgt.TIMEZONE_REGION)
and patch.installation_time<= MGMT_VIEW_UTIL.ADJUST_TZ(??EMIP_BIND_END_DATE??,??EMIP_BIND_TIMEZONE_REGION??,tgt.TIMEZONE_REGION)

You can join this to MGMT$target_components which would have the same home as the mgmt$applied_patches home,
and then select the targets that are databases in this home.

SELECT distinct
patch as PATCH,
installation_time as TIMESTAMP,
host as HOST,
tgtcomp.target_name,
tgtcomp.target_type,
patch.home_location as HOME_DIRECTORY,
patch.home_name as HOME_NAME,
platform as PLATFORM
from mgmt$applied_patches patch,
mgmt$em_homes_platform home,
mgmt$target tgt,
mgmt$target_components tgtcomp
where home.HOME_ID = patch.CONTAINER_GUID
and patch.target_guid = tgt.target_guid
and tgtcomp.home_name = patch.home_name
and tgtcomp.target_type = 'oracle_database'
and patch.installation_time>MGMT_VIEW_UTIL.ADJUST_TZ(??EMIP_BIND_START_DATE??,??EMIP_BIND_TIMEZONE_REGION??,tgt.TIMEZONE_REGION)
and patch.installation_time<= MGMT_VIEW_UTIL.ADJUST_TZ(??EMIP_BIND_END_DATE??,??EMIP_BIND_TIMEZONE_REGION??,tgt.TIMEZONE_REGION)


This is just an example of the customization that is possible.


How do we know what info is in the Grid Control Repository? We recommend using the new Sql Developer
Data Modelling utility from Oracle. This is downloadable from the Oracle Technical Network (OTN) and currently
installs as a stand-alone utility, but will be incorporated into a new release of Sql Developer in the not-too-distant
future. ( Sql Developer keeps getting better and better, just like Grid Control ! )


The Data Modelling utility allows reverese engineering of an existing Oracle Database, you can access
this via the menu. Select File>Import>Data Dictionary. In this way, you can import form Oracle 9,10
and 11, MS SQL Server 2000 and 2005, DB2/390 7 and 8, DB2/UDB 7 and 8.


Use this to reverse engineer the SYSMAN schema in the Grid Control repository, especially the MGMT$ views.
Then you can understand what info is available.


As a test of the customization:

After applying database patch 7210195 via Grid Control to our FINPRD1 and FINDW1 database home,
we created a Grid Control customized report "Applied Interim Patches (Customized - Database Level)".


The Sql used in this report is:


SELECT distinct
patch as "Applied Interim Patch",
installation_time as "Time Applied",
tgtcomp.target_name as "Database Target Name",
patch.home_location as "Oracle Home Directory",
patch.home_name as "Oracle Home Name",
host as Host
from mgmt$applied_patches patch,
mgmt$em_homes_platform home,
mgmt$target tgt,
mgmt$target_components tgtcomp
where home.HOME_ID = patch.CONTAINER_GUID
and patch.target_guid = tgt.target_guid
and tgtcomp.home_name = patch.home_name
and tgtcomp.target_type = 'oracle_database'
and patch.installation_time>MGMT_VIEW_UTIL.ADJUST_TZ(??EMIP_BIND_START_DATE??,??EMIP_BIND_TIMEZONE_REGION??,tgt.TIMEZONE_REGION)
and patch.installation_time<= MGMT_VIEW_UTIL.ADJUST_TZ(??EMIP_BIND_END_DATE??,??EMIP_BIND_TIMEZONE_REGION??,tgt.TIMEZONE_REGION)
order by installation_time desc


As you can see, we have changed the headings of the field columns in the report, and we also changed the styled text in the
Report definition from “INSTR_APPLIED_PATCHES_ALL_HOSTS” to the customized line:


“The report shows the interim patches applied on Oracle Databases across all the hosts
in the last 31 days. Use the time period selector to view the interim patches applied within a time-period. Thanks.”


We also created a Report: "Applied Interim Patches (Customized - Database Level and Select which Database)" that does the above and also allows you to select which database.


The Sql statement for this is:


SELECT distinct
patch as "Applied Interim Patch",
installation_time as "Time Applied",
tgtcomp.target_name as "Database Target Name",
patch.home_location as "Oracle Home Directory",
patch.home_name as "Oracle Home Name",
host as Host
from mgmt$applied_patches patch,
mgmt$em_homes_platform home,
mgmt$target tgt,
mgmt$target_components tgtcomp
where home.HOME_ID = patch.CONTAINER_GUID
and patch.target_guid = tgt.target_guid
and tgtcomp.home_name = patch.home_name
and tgtcomp.target_type = 'oracle_database'
and tgtcomp.target_guid = ??EMIP_BIND_TARGET_GUID??
and patch.installation_time>MGMT_VIEW_UTIL.ADJUST_TZ(??EMIP_BIND_START_DATE??,??EMIP_BIND_TIMEZONE_REGION??,tgt.TIMEZONE_REGION)
and patch.installation_time<= MGMT_VIEW_UTIL.ADJUST_TZ(??EMIP_BIND_END_DATE??,??EMIP_BIND_TIMEZONE_REGION??,tgt.TIMEZONE_REGION)
order by installation_time desc


The line which selects the database target selected is “and tgtcomp.target_guid = ??EMIP_BIND_TARGET_GUID??”


Regards,


Porus Homi Havewala
(Oracle ACE Director)
Principal Consultant,
S & I Systems Pte Ltd.