Report Error to Excel/PDF

Today I get one case from my team who implement EBS in PGN (Perusahaan Gas Negara).

Issue :

When create report and try to open in excel, he got error message : "REP-3000: Internal error starting Oracle Toolkit"

These how step by step I solved the issue :

1. Log in to apps server as root.


2. Check inittab file : more /etc/inittab, see the id mode, if mode 5 by looking this line "id:5:initdefault".


3. I found inittab mode was 5, so :


4. 
   

   #export DISPLAY=:0.0



5. 
   

   #xhost +



6. Modify the context file.


7. 
   

   #vi /oracle/DEV/devappl/admin/PROD_devmrcap.xml (*vary depend your installation)



8. Find DISPLAY and change to : "<DISPLAY >:0.0</DISPLAY>" *something like that.


9. Log in with application user.


10. Run environment.


11. Shutdown application by :

#cd $COMMON_TOP/admin/scripts/

#sh adstpall.sh apps/apps

10. Make sure all process were stop by : #ps -ef | grep FNDLIBR ,they should be one process.

11. Run autoconfig : #sh adautocfg.sh apps/apps.

12. Startup application by : #sh adstral.sh apps/apps.

Tuning Oracle Database

There many ways to tuning oracle database, one of them by using third party application. The name is Toad . I use Toad version 9.7.0.51.

Toad has many features, we need these three feature at minimum.

1. ADDM/ADDR Reports
   
   
   
   • Location : Database - Monitor - ADDM/AWR Reports
   
   
   • Function : It will tell us if any slow query appears. So we need to check the query then.


2. Oracle Tuning Advisor
   
   
   
   • Location : Database - Optimize - Oracle Tuning Advisor
   
   
   • Function : It will tess how to tune query. We neet do know query before and write on it. Then OTA will explain tune posibilities for query. For example : create index, remove sub-query, etc.


3. Session Browser
   
   
   
   • Location : Database - Monitor - Session Browse
   
   
   • Function : It help when we need watch running query online. We need execute program who slow performance then we need to see every query on it.

There many ways to tune database, I will write it later.

Preparing OEL 5 for Oracle EBS r12

Hi, I do preparation for installing oracle EBS on OEL 5. My environment are in Virtual Box. After installing OEL 5, what I do is :

• Setup reproforge configuration following these steps :

# wget http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm # rpm -Uvh rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm source : https://forums.oracle.com/forums/thread.jspa?threadID=2332788

• Setup yum configuration :

# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-el5.repo

open with editor (vi) :
# vi /etc/yum.repos.d/public-yum-el5.repo

change : enable=0 to enable=1 (all of repo)

#yum list (for updating repository to public yum)

source : http://public-yum.oracle.com

I need to read my external hardisk which formatted by ntfs, so I need to install fuse and ntfs-3g packages :

#yum install fuse

#yum install ntfs-3g

These two steps for easy step to install anything from repository.

After that I extracted file Staging R12.

#cd Source

#tar xfvz  StageR12.tar

(to be continued) :D