Jul 26, 2013
Active users from fnd_user in Ebiz R12 and 11i
2.1K

Active users from fnd_user in Ebiz R12 and 11i

You can find active users from fnd_user who has end_date greater than today’s date by issuing below query:   SELECT USER_NAME, EMAIL_ADDRESS, END_DATE FROM apps.fnd_user WHERE trunc(SYSDATE) BETWEEN trunc(start_date) AND * nvl(end_date,trunc(SYSDATE));
Jul 22, 2013
ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg’
1.4K

ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg’

When applying PSU 16619892, OPatch completed with errors as below: Error: OPatch found the word “warning” in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg’ /u01/app/oracle/product/11.2.0/db/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg’...
Jul 19, 2013
Online Oracle Identity Management Training
1.5K

Online Oracle Identity Management Training

Online Oracle Identity Management Admin Training Weekend batches are beginning: Install and Configure Identity Management: 1. Install Fusion Applications Provisioning Framework. 2. Install Transactional Database for Fusion Applications 3. Install Fusion Applications RCU. 4. Install Identity Management RCU 5. Install and configure Oracle HTTP Server as the entry point. 6....
Jul 16, 2013
ORA-19815: WARNING: db_recovery_file_dest_size of 48318382080 bytes is 100.00% used, and has 0 remaining bytes available.
8K

ORA-19815: WARNING: db_recovery_file_dest_size of 48318382080 bytes is 100.00% used, and has 0 remaining bytes available.

Error: ORA-19815: WARNING: db_recovery_file_dest_size of 48318382080 bytes is 100.00% used, and has 0 remaining bytes available. ORA-16014: log 3 sequence# 51 not archived, no available destinations ARCH: Archival stopped, error occurred. Will continue retrying ORACLE Instance DB1 – Archival Error ORA-16038: log 3 sequence# 51 cannot be archived ORA-19809: limit...
Jul 15, 2013
Online Oracle Database 12c Training
516

Online Oracle Database 12c Training

Please find the course content: Introduction Course Objectives Course Schedule Overview of Oracle Database 12c Overview of Oracle Cloud Exploring the Oracle Database Architecture Oracle Database Architecture: Overview Oracle Database Instance Configurations Connecting to the Oracle Database Instance Oracle Database Memory Structures Process Architecture Process Structures Process Startup Sequence Database...
Jul 04, 2013
1.3K

Oracle RAC 12c Installation on Oracle Virtual Box

Step-by-step Installation of Oracle RAC 12c on Oracle Virtual Box Download Virtual Box Download Oracle Enterprise Linux 5.7 64-bit Download Oracle 12cR1 64-bit Database Software Installation of Oracle Enterprise Linux 5.7 by clicking on the link Linux Post Installation Steps: 1) To be consistent with the rest of the article, the following information should be set during the installation process. #vi /etc/hosts 127.0.0.1 localhost.localdomain localhost # Public 192.168.1.101 rac1.oracle.com rac1 192.168.1.109...
Jul 04, 2013
Upgrade database from 11g to 12c
2.7K

Upgrade database from 11g to 12c

Step by Step Procedure to update Oracle Database 11gR2 to 12cR1 There are different ways of upgrading to the latest release of Oracle database and Oracle provides multiple methods to upgrade. Few are listed below: 1)Database Upgrade Assistant (DBUA) 2)Manual Upgrade 3)Transportable Tablespaces 4)Datapump export/import 5)Oracle Streams 6)Oracle GoldenGate Now,...
Jul 03, 2013
Routine AFPESA cannot construct the name of an executable file
984

Routine AFPESA cannot construct the name of an executable file

Error in Standard Manager Logfiles: Routine AFPESA cannot construct the name of an executable file for  your concurrent request 23455110. Check that the file name components are correct and valid on your system. Check that the environment for the person who started the concurrent manager. Solution Check your custom environment file...
Jul 02, 2013
Find Concurrent Manager Logfile
1.9K

Find Concurrent Manager Logfile

Please use below script to find Concurrent Manager Logfile.   SELECT ‘ICM_LOG_NAME=’ || fcp.logfile_name FROM fnd_concurrent_processes fcp, fnd_concurrent_queues fcq WHERE fcp.concurrent_queue_id = fcq.concurrent_queue_id AND fcp.queue_application_id = fcq.application_id AND fcq.manager_type = ‘0’ AND fcp.process_status_code = ‘A’;