Category Archives: ERP

RC-20200: Fatal: Could not find Unzip When Installing EBS R12

Posted by on December 12, 2014 1 comment

Problem: While installing EBS R12.1 on Linux x86-64, the following error appears:

"Processing Disk1....

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

Please make sure you have UnZip 5.X in your path and try again...

Cannot execute Install for database ORACLE_HOME

RW-50010: Error: - script has returned an error:   1
RW-50004: Error code received when running external process.  Check log file for details.
Running Database Install Driver for TEST instance"

Solution: As root user, rename the default unzip (/usr/bin/unzip) to a temporary filename (e.g. /usr/bin/unzip-ver6), perform the installation, and then rename unzip-ver6 to the original name when complete.

# mv /usr/bin/unzip /usr/bin/unzip-ver6

Reference: R12 Rapid Install Failing With “RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.” (Doc ID 1455077.1)

 

Monitoring Users in EBS

Posted by on December 1, 2014 No comments

Problem: How do I determine who is logged on to EBS?

Solution: There are two ways you can do this: check the Monitor Users form, or run the Signon Audit Users report.

Read more »

Using Date Parameters in Custom Concurrent SQL Programs

Posted by on November 12, 2014 No comments

Problem: I want to create a custom concurrent program based on a SQL script, but do not know how to pass date parameters to the concurrent program.

Solution: Use ‘&1’, ‘&2’ etc. and format it using ‘yyyy-mm-dd hh24:mi:ss’ in the SQL program (i.e. to_date(‘&1’, ‘yyyy-mm-dd hh24:mi:ss’). In the Concurrent Program parameter setup, set the Value Set as FND_STANDARD_DATE.

Read more »

System failed to generate the PDF document

Posted by on January 16, 2013 No comments

Problem:

After installing the R12.1 Vision instance on Windows Server 2003 and patching to R12.1.3, navigated to Purchasing, Vision Operations (USA) > Buyer Work Center > Orders. Selected an order’s radio button, selected View PDF from the drop-down list and clicked Go.

The following error was displayed:

System failed to generate the PDF document. Please contact your system administrator.

Solution:

Navigate to the XML Publisher Administrator responsibility > Home > Administration. Under Properties > General, change Temporary directory from /tmp to C:TEMP and save.

SEVERE: Failed to allocate port(s) in the specified range(s)

Posted by on December 5, 2012 No comments

Problem:

When creating the Enterprise Manager Database Control repository, the following error is displayed:

SEVERE: Failed to allocate port(s) in the specified range(s) for the following process(es): 
JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]

Solution:

Ensure that the IP address and hostname are correctly set, as well as the ORACLE_HOSTNAME environment variable.

Shared Folder Is Not Accessible

Posted by on October 17, 2012 No comments

Problem:

After sharing folders on Windows 2003, unable to access them from Windows XP. XP does not prompt for the Windows 2003 login. The following message appears:

\APPSWINDOWS11gR2 is not accessible. You might not have permission 
to use this network resource. Contact the administrator of this 
server to find out if you have access permissions. 
Access denied

Solution:

Manually map network drives to the Windows 2003 shared folders from XP machine using the NET USE command, adding the /USER switch to include the user name.

Read more »

Basic RMAN Commands

Posted by on October 12, 2012 No comments

Here is a list of some RMAN commands I frequently use:

1. To connect to RMAN without a repository:

rman target /

2. To crosscheck backups:

crosscheck backup;

3. To list expired backups:

list expired backup;

4. To delete expired backups:

delete expired backup;

5. To set a disk destination for backups:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   ‘E:backupDEV1%U’;

6. To include a maximum size of 2GB for backupset pieces:

CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2G FORMAT ‘E:backupDEV1%U’;

7. To execute a backup to the default location:

backup database;

8. To restore and recover datafile 30:

run {

restore datafile 30;

recover datafile 30;

}

Internet Explorer cannot display the webpage When Connecting to OEM

Posted by on October 11, 2012 4 comments

Problem:

After applying latest OS updates (October 9, 2012) on Windows XP SP3, Internet Explorer 7 (IE7) can no longer connect to Oracle Enterprise Manager (11g) via SSL (https). Firefox is able to connect to OEM.

Solution:

Update for Windows XP (KB2661254-V2) affecting certificates. Quick fix: from Add/Remove Programs, check ‘Show updates’, remove Update for Windows XP (KB2661254-V2) and reboot.

Note that removing Windows updates may affect your computer’s security. Proceed at your own risk.

*** UPDATE: Oracle has fixed the issue in MOS ID: 1489557.1 (EM Grid Control 11g Console Not Accessible Via Internet Explorer After Applying Microsoft Security Patches On Client PC)

Reference:

Microsoft Security Advisory (2661254): Update For Minimum Certificate Key Length
http://technet.microsoft.com/en-us/security/advisory/2661254

Microsoft Security Advisory (2749655): Compatibility Issues Affecting Signed Microsoft Binaries
http://technet.microsoft.com/en-us/security/advisory/2749655
Read more »

ORA-01843: not a valid month

Posted by on September 20, 2012 No comments

Problem:

When trying to convert the char column (attribute9) to date using the to_date function in SQL Developer, the following error is displayed:

ORA-01843: not a valid month
01843. 00000 -  "not a valid month"
*Cause:   
*Action:

Solution:

Dates were stored in two different formats (mm/dd/yyyy) and (dd-mon-yyyy) in the attribute9 column. Convert all dates to one format (dd-mon-yyyy).

‘ap7001are.us.oracle.com’ Target Host in R12 Database Control

Posted by on September 6, 2012 No comments

‘ap7001are.us.oracle.com’ Target Host in R12 Database Control

Problem:

After enabling and launching Database Control on an R12.1 instance, the instance ‘ap7001are.us.oracle.com’ is seen as a target host and ‘PROD_ap7001are.us.oracle.com’ as the listener.

Solution:

Drop and recreate the Enterprise Manager repository on the R12 instance.

Read more »