Today I went through BI Publisher Desktop Tool , used for designing report template for BI Publisher.
With my 8+ years of experience in Oracle Reports, while designing this sample template I felt as I am designing it in Oracle report.
Over all, it left a good impression on me, so I though of sharing my experience of designing my first report for BI Publisher.
Before starting we need to install a BIPublisherDesktop plugin for ms word. Once done we can start the ms word and can see the BI Publisher related menus under addon.
Step 1: Under Oracle BI Publisher under add on. […]

[Read more →]

Example, I have following report server (highlighted) which I need to delete.

Assume %OMH% is Oracle Middle Tier Home
Go to %OMH% /sysman/emd
Open file targets.xml for editing.
Check for <Target> tag where its attribute “NAME” should matches as follows:
“<ias_instance_name>_Reports_Server: <reports_server_to_be_removed>”
In our example it is oracleas.dbserver _Reports_anand
Where
“oracleas.dbserver” is ias_instance_name
“anand” is reports server name
Select from Starting Tag <Target..> to ending tag </Target> and delete selected lines.
<Target TYPE=”oracle_repserv” NAME=”<ias_instance_name>_Reports_Server: <reports_server_to_be_removed>” …>
…
</Target>

Save and Close targets.xml file.
Now go to %OMH%/dcm/bin
Give following commands to update and resync console with new configuration:
1. dcmctl updateconfig -ct opmn -v -d
2. dcmctl resyncinstance -v -d
Once done without any error, go to %OMH%/bin
Give following […]

[Read more →]

Wishing Everybody Merry Christmas And Happy New Year 2008!
May All Your Wishes Come True And Lead You Into The Path of Continued Success, Prosperity, Good Health and Never Ending Happiness……

Bookmark this post

Hide Effect.BlindUp(’obsocialbookmark_bar154′);

[Read more →]

Today when doing some research on “FAST DUAL”, I came across following error when I try to set autotrace on:
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
SQL>
Anyway I ignored the error and ran my sql.
The result was I could see the execution plan but not statistics as follows.
SQL> select sysdate from dual;
SYSDATE
———
17-DEC-07
Execution Plan
———————————————————-
Plan hash value: 1388734953
—————————————————————–
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
—————————————————————–
| 0 | SELECT STATEMENT | […]

[Read more →]

Recently while doing R&D, I came across the ADR Command Interpreter (ADRCI).
Introduced in Oracle Database Release 11g, it is a command-line tool that one can use to manage diagnostic data.
Diagnostic data includes incident and problem descriptions, trace files, dumps, health monitor reports, alert log entries, and more.
ADRCI has a rich command set, and can be used in interactive mode or within scripts.
In addition, ADRCI can execute scripts of ADRCI commands in the same way that SQL*Plus executes scripts of SQL and PL/SQL commands.
It enables us to:

View diagnostic data within the Automatic Diagnostic Repository (ADR).
View Health Monitor reports.
Package […]

[Read more →]

Yesterday I was doing some r&d and tried to find trace file for my session.
After lot of trouble I was able to find them.
Last time its was a simple task, I just need to look at $ORACLE_BASE/SID/udump directory of the database server.
But now trace files are stored in the the trace directory under Automatic Diagnostic Repository (ADR) home.
To get the location of individual trace files we can use data dictionary views as follow:
To find the trace file for your current session:

SELECT value
FROM v$diag_info
WHERE name = ‘Default Trace File’;
This query will return the full path to the trace file.

To find all trace files […]

[Read more →]

On 13th October 2007, I wrote about “Understanding Virtual Columns“.
Then Ray DeBruyn ask me a very good question, which I totally miss to ask myself when I was writing about it.
What happens if I use:
INSERT INTO myTable VALUES myTableRec
or
UPDATE myTable SET ROW = myTableRec
Assuming I declare myTableRec as myTable%ROWTYPE, is the new feature smart enough to ignore the virtual column?
To find out the answer, I did following:

SQL> create table virtual_col(
2 a number,
3 b number,
4 c number GENERATED ALWAYS AS (a+b) VIRTUAL,
5 d number);
Table created.
SQL> desc virtual_col;
Name […]

[Read more →]

On 12th july 2007, I wrote a post about new feature of 11g related to sequence.
In this post I mention that in 11g we don’t need to use dual table to fetch next value of a sequence and using simple PL/SQL expression the next value can be fetched.
Any way thats the old story and lot of people have wrote about it.
But recently I got to know from Asif blog, what exactly is happening in background.
I follows what he did and confirms that he 100% right!

Created the new sequence
SQL> create sequence new11g_seq;
Sequence created.

Give a name to the trace file that will […]

[Read more →]

While installing the database some time due some problem, everything is installed but enterprise manager does not work.
In another common case (I am not really talking about production servers here) due to some reason like change in ip addresses and so on, enterprise manager stops working.
Whatever the case, In simple words there is a requirement that we need to drop the existing setup of enterprise manager and create new one with new configuration.
Note here I am only talking about dropping and then creating again which I normally do with my development server off course there are other options too.
First drop […]

[Read more →]

I don’t why but I never came across this function, may be because I am so used to using MOD function to get the remainder of two number when one of them is divided by others, so never though of finding any other function doing same thing.
But yesterday I came across this function while surfing on the net and thought may be many of us may be missing it too.
So sharing for those person who have missed it like me…..
REMAINDER(n2,n1)
REMAINDER returns the remainder of n2 divided by n1 . This function takes as arguments any numeric datatype or any nonnumeric […]

[Read more →]