Saturday, July 24, 2010

How to change Oracle forms and reports standalone configuration for custom directory???

Recently i encountered one issue to configure Oracle Forms and Reports Standalone to point to custom directory.

Below is the solution for that

Got to httpd.conf file which is located in ORACLE_HOME/Apache/Apache/conf directory.

Before changing anything in httpd.conf, take backup of httpd.conf.

Change DocumentRoot value to your directory as shown below

DocumentRoot "your custom directory"

Hope this helps!!!

How to change the logo on the connection page of discoverer portal

Below is a way change the logo on the connection page of discoverer portal

Go to
E:\Oracle\10gAS_BI\j2ee\OC4J_BI_Forms\applications\discoverer\discoverer\images

change logo_plus.gif to logo_plus_bak.gif and place your logo there and rename it to logo_plus.gif.

Now relogin to the Discoverer portal you will see your logo there.

Enjoy!!!

How to extract the DB Links DDL with the encripted password???

Below is a simple script to extract the DB Links DDL with the encripted password.

SET LONG 9000 — to print the complete string

SELECT DBMS_METADATA.GET_DDL (‘DB_LINK’,a.db_link,a.owner) FROM dba_db_links a;

Hope this helps as it has helped in alot of times.