Recently after I configured database on testing machine and configure the forms to run on middle tier on testing machine (all windows environment), I came across the error ORA-12638.

After little bit of brains storming and checking online, I found out that one of the way to solve this error is to disable the Oracle Advanced Security Authentication and let database use the supplied user name and password to authenticate.
It can be disable by updating the sqlnet.ora file with the following entry:
SQLNET.AUTHENTICATION_SERVICES = (NONE)

Note : Default entry in my case was SQLNET.AUTHENTICATION_SERVICES= (NTS)
Guys do check out other method and let me […]

[Read more →]

Today while exporting I came to know that Oracle XE does not support Bitmap Indexes.

Then to test it out, I login into Oracle XE’s SQL*Plus console and tried to run a create bitmap index DDL sql and result was still negative as follows.
 
So I was convince that it does not support Bit-mapped Indexes..

Bookmark this post

[…]

[Read more →]

Today I came across this thread at Oracle Forum.
Where Question was as follows:
Consider Test table have Numb (Number datatype) field. table values are given below.
Table Name: Test
NUMB
1
2
4
7
8
9
12 … This table have more than thousand records like that…..
How to retrive the missing numbers. I’m expecting the output 3,5,6,10,11……..
Could you please give the SQL for this task. Thanks!
One of the member David Grimberg gave following solution.

select level numb from dual connect by level <= (select max(numb) from test)
minus
select numb from test;
I was very impress with this sql because I recognize the worth of this sql to myself and many situation in which […]

[Read more →]

Now in Application Express 3.1 installation we have two scripts to change the password of internal ADMIN account.
First one is as follows which was available before version  3.1
@UNZIP_DIR/apex/apxxepwd.sql password
Where
password is the password of the Application Express internal ADMIN account.
Second one is as follows which is new in version 3.1
@UNZIP_DIR/apex/apxchpwd.sql
When prompted enter a password for the ADMIN account.
Where:
UNZIP_DIR is the directory where you unzip your application express installation.

Bookmark this post

[…]

[Read more →]

Even though there is a document about up-gradation at Oracle, I wrote what I thought I will be following in future. There are things which one may not find in documents but learn with experience or when actually doing it.
Steps to up-gradation are as follows:
1. Change your working directory to apex where you have unzip the installation.
2. Start SQL*Plus from here and connect to the database as SYSDBA role. Thus making apex as your working directory.
3. To Install Full development environment
@apexins tablespace_apex tablespace_files tablespace_temp images
it can be something like this
@apexins SYSAUX […]

[Read more →]

Recently I forget the Application Express (version 3.0.1) internal ADMIN account of my development site.
So to change the password without knowing the old password, I login as SYS into the Database Server and run the following script.
SQLPLUS> @C:\oraclexe\apex\apxxepwd.sql new_password
Where “C:\oraclexe\apex” is APEX_HOME directory.
What this script is doing is as follows:
First it changes the current schema to “FLOWS_030000″
alter session set current_schema = FLOWS_030000;
The set the security group id and and user name using wwv_flow_security package as follows:
wwv_flow_security.g_security_group_id := 10;
wwv_flow_security.g_user := ‘ADMIN’;
The change the status as “import in progress” using wwv_flow_security package
wwv_flow_security.g_import_in_progress := true;
Then get the internal user id of the “ADMIN” […]

[Read more →]

Normally, when I connect to Oracle, I don’t worry about case sensitivity of my password.
But today, when I was trying to connect Oracle, I was contineously getting following error.
Flashing message “ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.”.
I was out of clue why exactly this is happening as I was providing right username and password!
I became little bit irritated, what’s wrong am I doing.
Usually I provide username and password in small case as I know that Oracle is case insensitive. So for a change I tried the same username and password with upper case and it […]

[Read more →]

Oracle BI Publisher Desktop is provided by Oracle to aid in development of BI Publisher templates from your desktop with or without connection to BI Publisher Server.
When we install it, it comes with demos in flash, Sample XML data file with sample templates, PDF help for BI Publisher and plugin for MS Word.
Plugin in MS Word look something like as follows:

It can be downloaded from Oracle site.

Bookmark this post

[…]

[Read more →]

Today I create my second report using group above and group left.
I also used sum function in this report.
First I loaded XML data as before.
My XML data structure is as follows:

My intention is to design a summary report of total sale by year and month.
Run Table Wizard as follows:

Follow the following steps in Wizard:

Once clicked the result will be as follows:

Now I deleted whole Table inside the inside second column of second row of main table.
Now it should look like as follows:

Now keep you cursor inside second column of second row of main table.
Now goto Choose Field menu as follows:

Choose […]

[Read more →]

Yesterday I post about how I design my first BI Publisher report in offline mode.
Today I would like to share my understanding about BI Publisher till now.
Just like going from Oracle Forms 6 to Oracle Forms 6i, I felt no difference from programming point of view except few tit-bits here and there.
In reality it was big change. Whole architecture was changed.
Now I am feeling same thing when I am comparing Oracle Reports and BI Publisher.
From designing point of view, I don’t feel any much change. The learning curve is very smooth.
But from architecture point of view, it’s a hell lot […]

[Read more →]