How To Check Oracle EBS Version

22 March 2013 Leave a comment

Somehow we should know what version we running in. There’s two ways to check it out :
1. On the application just click : Help -> About Oracle Application
2. Run this simple query : “SELECT release_name FROM app.fnd_product_groups”

Cheers ūüėÄ

Categories: Artikel

Check Status RMAN Backup

17 March 2013 Leave a comment

Some how, we need to check status our RMAN backup, so these the script :

  • To check full and incremental RMAN backup with archivelog :

col status format a9
col hrs format 999.99
SELECT
session_key,input_type, status,
to_char(start_time,’mm/dd/yy hh24:mi’)¬† start_time,
to_char(end_time,’mm/dd/yy hh24:mi’) end_time,
elapsed_seconds/3600 hrs
FROM v$rman_backup_job_details ORDER BY session_key;

  • Tp check full and incremental backup, not archivelog backup

col status format a9
col hrs format 999.99
SELECT
session_key, input_type, status,
to_char(start_time,’mm/dd/yy hh24:mi’) start_time,
to_char(end_time,’mm/dd/yy hh24:mi’) end_time,
elapsed_seconds/3600 hrs
FROM v$rman_backup_job_details
WHERE input_type=’DB INCR’ ORDER BY session_key;

 

Categories: Uncategorized

Resuming Screen

13 February 2013 Leave a comment

I usually using screen command for my work on machine. It works when I lost my connection to my machine, my job could be continued. But some case, my screen not detached. This is my solution when the screen still attached. Fist of all, check your screen status with command “screen -ls”

  1. Use screen -D. Just type “sceen -d (ppt/tty number)”
  2. If number 1 failed. So you need to kill the process. What process number? 

“ps -ef | grep screen”

noted the number where the pty/tty is ” screen -r 123.tty.DEVMRCAP”

“ps -ef ¬†| grep (process number)

noted the process number

“kill -9 (process number)

Believe me, it works ūüėÄ

Categories: Uncategorized

Troubleshoot : Can’t Access DB From Some Node/TOAD

12 February 2013 Leave a comment

Symptom :

Yesterday I had case, my developer can’t access db with TOAD but he can access it on machine.

Solutin :

Check : $TNS_ADMIN/sqlnet.ora

There are lines :

tcp.validate_checking = yes

tcp.invited_nodes = ….

First line is sett db should check node who can access db. yes means db machine would check who access the db.

Second line is define nodes who accepted to access db.

Both of lines is addition, after install db, the lines is not exist, we should add those lines for security issue.

 

Categories: Uncategorized

How To Change Sysadmin Password

12 February 2013 Leave a comment

Sometime we lost sysadmin password. So¬†this article i will define steps of¬†‚Äúhow we can change sysadmin user password‚Ä̬†.For to can change sysadmin user password, we have 2 options:

1. We can use E-Business suite screens (if we know old password)

2. We can use FNDPASS utulity(whether we have old password or not)

Please follow below steps for can change sysadmin user password:

1. If we want to change sysadmin user password with E-Business suite

Login to EBS  than:

System Administrator -> User -> Query the desired USERNAME and in password tab enter the new password.

To test,relogin into the applications as the SYSADMIN user and thenew password. 
Verify that a concurrent program such as Active Users runs.

2. If we want to change sysadmin user password with FNDPASS utulity

Keep all services running.
Login  OS level by way of the applmgr user and source(run)n your environment scripts
cd $APPL_TOP
run APPSORA.env

cd $FND_TOP/bin
Run FNDCPASS to change the SYSADMIN password

FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN <New Password>

Example:

FNDCPASS apps/apps 0 Y system/manager USER sysadmin/sysadmin123

Restart the Apache, Forms, Reports, 8.0.6 listener and concurrent manager services. << This step not mandotary,but recommended
To test, login to EBS as the SYSADMIN user with new password. 
Verify that a concurrent program such as Active Users runs.

Reference:

How To Change The Password For The SYSADMIN User [ID 423274.1]

How to Change Applications R12 Passwords using Applications Schema Password Change Utility (FNDCPASS)? [ID 437260.1]

Categories: Uncategorized

Report Error to Excel/PDF

8 January 2013 Leave a comment

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.

Categories: Uncategorized

Tuning Oracle Database

3 January 2013 Leave a comment

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.

 

Categories: Uncategorized