How To Check Oracle EBS Version

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 :D

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

View Previous Backup On SQL Server

The case is I try to restore db through full backup on differential backup. I failed when restore diffential backup. With this query I found last full backup of db.

SELECT
CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,
msdb.dbo.backupset.database_name,
msdb.dbo.backupset.backup_start_date,
msdb.dbo.backupset.backup_finish_date,
msdb.dbo.backupset.expiration_date,
CASE msdb..backupset.type
WHEN 'D' THEN 'Database'
WHEN 'L' THEN 'Log'
END AS backup_type,
msdb.dbo.backupset.backup_size,
msdb.dbo.backupmediafamily.logical_device_name,
msdb.dbo.backupmediafamily.physical_device_name,
msdb.dbo.backupset.name AS backupset_name,
msdb.dbo.backupset.description
FROM msdb.dbo.backupmediafamily
INNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id
WHERE (CONVERT(datetime, msdb.dbo.backupset.backup_start_date, 102) >= GETDATE() - 7) AND database_name='FMS_JASARAHARJA'
ORDER BY
msdb.dbo.backupset.database_name,
msdb.dbo.backupset.backup_finish_date

Voila, u can find the location of your last backup.