Script 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 MoreGeneral Ledger Category Payroll Extract
Below is the query to extract Payroll data from General Ledger, historical data for a week. select gjl.je_line_num, gcc.concatenated_segments, nvl(gjl.entered_dr,0) entered_debit,nvl(gjl.entered_cr,0) entered_credit,gjl.description from gl_je_lines gjl,gl_code_combinations_kfv gcc, gl_je_headers gjh,gl_je_sources gs,gl_je_categories gc…
Read MoreOCI DBCS: RESTORE the DB from backup, OPEN command fails, wallet status is found to be CLOSED,
Issue : OCI DBCS: RESTORE the DB from backup, OPEN command fails, wallet status is found to be CLOSED, Observation : – Took a complete database backup – Used the…
Read MoreOCI Restore fails during Recreate Controlfile step while adding tempfile to PDB
Issue : OCI Restore fails during Recreate Controlfile step while adding tempfile to PDB SYMPTOMS : Create new DB System from backup fails during Recreate Controlfile script execution. Reason :…
Read MoreOCI Restore failure during Tempfile Creation
Issue : OCI Restore failure during Tempfile Creation Trying to create a new DB System from backup in OCI. Restore fails during “Re-Create Control File” step: Cause for the issue…
Read MoreGot the error : ORA-20401: Authorization failed, while listing contents of OCI Object storage using PL/SQL in ADB
Issue : Got the error : ORA-20401: Authorization failed, while listing contents of OCI Object storage using PL/SQL in ADB Error : ERROR at line 1: ORA-20401: Authorization failed for…
Read More