command to check log file size more than 1 gb
find / -size +1G -mtime +180 -type f -print
Read Morecommand to check oracle users in linux
getent passwd | grep oracle getent passwd | grep dba
Read Morescript-find-last-time-objects-analyzed-oracle
prompt ====================================== prompt ANALYZE – DATE – REGULAR TABLES prompt ====================================== col owner format a20 prompt select owner,’Tables’,trunc(LAST_ANALYZED),count(*) from dba_tables where owner not in (‘SYS’,’SYSTEM’) group by owner,’Tables’,trunc(LAST_ANALYZED) / prompt…
Read MoreScript for check all the enabled auditing on Database
Script for check all the enabled auditing on Database –Check the parameter is enabled or disable for Audit select name || ‘=’ || value PARAMETER from sys.v_$parameter where name like…
Read MoreQuery to check list of concurrent error
SELECT b.request_id, a.user_concurrent_program_name, b.phase_code AS completed, b.status_code AS error, u.user_name requestor, TO_CHAR (b.actual_start_date, ‘MM/DD/YY HH24:MI:SS’) starttime, ROUND ((b.actual_completion_date – b.actual_start_date) * (60 * 24), 2 ) runtime, b.completion_text FROM fnd_concurrent_programs_tl…
Read MoreHow to find Components version in R12
Apache Version $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v Go to reports path Then type: – string -a APXAPRVL.rdf|grep Header Perl Version $IAS_ORACLE_HOME/perl/bin/perl -v|grep built Java Version sh -c “`awk -F= ‘$1 ~ /^JSERVJAVA.*$/…
Read MoreDisplays Last Analyzed Details for a given Schema
— — Displays Last Analyzed Details for a given Schema. (All schema owners if ‘ALL’ specified). — SET PAUSE ON SET PAUSE ‘Press Return to Continue’ SET PAGESIZE 60…
Read MoreJava Web Start installation
Simply installing Java 1.5 from Sun is the easiest way to get the newest Java and Java Web Start. Windows: To get 1.5, go to the Java 1.5 website. Just go through the install…
Read MoreEBS VERSION 12.2.5 CLONE -Login Page Blank
After cloning EBS R12 successfully, when I am going to login EBS clone it did not show anything on the page. Login page is totally blank. I have restarted all…
Read MoreTO Assign Responsibility for the user in backend
DECLARE v_session_id INTEGER := userenv(‘sessionid’); v_user_name VARCHAR2(30) := upper(‘&Enter_User_Name’); BEGIN fnd_user_pkg.createuser(x_user_name => v_user_name ,x_owner => ” ,x_unencrypted_password => ‘oracle’ ,x_session_number => v_session_id ,x_start_date => SYSDATE – 10 ,x_end_date => SYSDATE…
Read More