PL/SQL Instrumentation using ILO


Fred has embarassed me by reminding me that I had introduced him to code instrumentation by using the DBMS_APPLICATION_INFO package as he explains PL/SQL Instrumentation using ILO.

As people will have noted from my series on Nordic, I have not been using any code instrumentation at all. To remedy this, I am going to install the ILO package into the Oracle XE database.

Extract the downloaded zip file into a suitable place (i.e. C:\Users\douglas\OCM\ILO2.2).

Create the User

Connect to the XE database using Run SQL Command program in the Oracle Database 10g Express Edition program group.

CONNECT / AS SYSDBA

Using the instructions given in Install.txt, I created the following script from the ilo_create_user.sql. (XE is restrictive in the tablespaces you can use.)

CREATE USER ilo
  IDENTIFIED BY ilo
  DEFAULT TABLESPACE users
  TEMPORARY TABLESPACE temp
  QUOTA UNLIMITED ON users
  PROFILE DEFAULT
  ACCOUNT UNLOCK
/
ALTER USER ilo DEFAULT ROLE ALL;

Install the Product

At this stage, you are going to have to use SQL*Plus instead of the XE provided interface because the current directory has to be where you unpacked the zip file.

Start up a command window:

cd C:\Users\douglas\OCM\ILO2.2
@ilo_install

You will see some output, then this:

Preparing to start. Hit enter to continue...

After you press enter, you will need to answer the following three (3) questions. The answers to the first (2) are the values you provided in the CREATE USER command above. (The password is specified by the IDENTIFIED BY clause.) The third answer has to XE if you are using the XE database.

Good, you are authenticated with AS SYSDBA credentials

*** Enter the user you wish to own ILO [ilo]:
*** Enter the password for this user:
*** Enter the TNS alias for this user: xe

Testing

Fred has the testing plan.

Advertisements

2 thoughts on “PL/SQL Instrumentation using ILO

  1. I wouldn’t be so foolhardy to embarrass an OCM…? The consequences would be very dire…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s