How to find out linux release information?

For Oracle Enterprise Linux:
$ rpm -qf /etc/redhat-release
enterprise-release-5-0.0.9
$ cat /etc/enterprise-release
Enterprise Linux Enterprise Linux Server release 5.2 (Carthage)

For RedHat Enterprise Linux:
$ rpm -qf /etc/redhat-release
redhat-release-4AS-5.5
$ cat /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 4)

For SuSE, use “/etc/SuSE-release”:
$ cat /etc/SuSE-release
SUSE LINUX Enterprise Server 9 (i586)
VERSION = 9

Useful Articles for the Oracle E-Business Suite Technology Stack for Applications DBA (Security)

Note 738923.1 Oracle E-Business Suite Releases 11i and 12 Critical Patch Update note

Note 403537.1 Best Practices for Securing Oracle E-Business Suite Release 12

Note 189367.1 Best Practices for Securing the E-Business Suite Release 11i

To download and Upload rules for a particular form

To download rules for a particular form:

FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt> FND_FORM_CUSTOM_RULES form_name=<form name>

Upload:
FNDLOAD <userid>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt>

How To Control The Output Format Of Report Custom Layout Template in Oracle Apps

Profile 'FND: Default Template Output Type' needs to be defined at SITE level
with any one of the following values:

* EXCEL
* FO
* HTML
* PDF
* RTF

the way to find version of installed family packs in oracle apps?

SELECT PRODUCT_VERSION,PATCH_LEVEL FROM
FND_PRODUCT_INSTALLATIONS WHERE PATCH_LEVEL LIKE ‘%GL%’;

How to schedule a Job in Unix

Use cronjob
crontab -l ( list current jobs in cron)
crontab -e ( edit current jobs in cron )
_1_ _2_ _3_ _4_ _5_ $Job_Name
1 – Minutes (0-59)
2 – Hours ( 0-24)
3 – day of month ( 1- 31 )
4 – Month ( 1-12)
5 – A day of week ( 0- 6 ) 0 -> sunday 1-> monday

Delete Duplicate Rows from Oracle Table

DELETE FROM EMPLOYEES WHERE ROWID NOT IN
(SELECT MIN(ROWID)
FROM EMPLOYEES
GROUP BY LAST_NAME ) ;

How to compile Forms in 11i and R12

Compile Forms in 11i

$ f60gen module=<formname>.fmb userid=apps/<apps_pwd> output_file=$XX_TOP/forms/US/<formname>.fmx


Compile Forms in R12

$ frmcmp_batch <formname>.fmb userid=apps/<apps_pwd> output_file=$XX_TOP/12.0.0/form/US/<formname>.fmx module_type=form compile_all=special

Oracle will retire several certification tracks effective November 1, 2011

Exams to be retired November 1:

1Z0-109 Oracle WebLogic Server 10g Developer
1Z0-110 Oracle Weblogic Portal 10g Developer
1Z0-200 Oracle 11i E-Business Essentials
1Z0-207 Oracle Comm. Billing & Revenue Mgmt.: Pricing
1Z0-208 Oracle Comm. Billing & Revenue Mgmt.: Server Developer
1Z0-209 Oracle Comm. Billing & Revenue Mgmt.: System Administrator
1Z0-211 Oracle 11i General Ledger Fundamentals
1Z0-212 Oracle 11i Payables Fundamentals
1Z0-213 Oracle Receivables 11i Fundamentals
1Z0-221 Oracle 11i Inventory Management Fundamentals
1Z0-222 Oracle 11i Purchasing Fundamentals
1Z0-223 Oracle 11i Order Management Fundamentals
1Z0-231 Oracle 11i 2.6 Implement Workflow
1Z0-232 Oracle 11i System Administration
1Z0-233 Oracle 11i Install, Patch and Maintain Applications
1Z0-235 Oracle 11i Applications DBA: Fundamentals I
1Z0-236 Oracle 11i Applications DBA Fundamentals II
1Z0-255 Hyperion Essbase 7.1.2 Consultant
1Z0-257 Hyperion Financial Management 4.1 Consultant
1Z0-259 Hyperion Planning 4.1 Consultant
1Z0-262 Hyperion Planning 4.1 Administrator
1Z0-263 Hyperion System 9 BI+ 9.0 Administrator
1Z0-273 Hyperion Financial Management 4.1 Administrator I & II
1Z0-301 Oracle9iAS: Basic Administration
1Z0-615 Siebel 7.7 Consultant Core Exam
1Z0-620 Siebel 7.7 Analytics Application Developer Professional Exam
1Z0-630 Siebel 7.7 Analytics Server Architect Professional Exam
1Z0-640 Siebel 7.7 Analytics Data Warehouse Developer Professional Exam

Just Words

Believe that anything you can imagine you can achieve it real.
Having the devotion,passion and dedication to learn & Work

“Knowledge grows when it is shared“.