Monthly Archives: August 2012

11g Database Not Starting With spfile On Windows

Problem:

After creating an spfile on an 11g instance (11.1.0.7) on R12.1.3 on Windows 2008, it does not automatically appear when the ‘show parameter spfile’ command is issued in SQL*Plus.

Solution:

When the database is started via the Windows Services panel, it seems that the pfile is used by default, even though the spfile may have been created. Stop and start the database via SQL*Plus to see the spfile.

Read more »

Unable to delete oraclient10.dll

Problem:

When cleaning up an R12.1 instance on Windows 2008, unable to delete C:oracleTEST1appstech_st10.1.2BINoraclient10.dll

Possible solution:

Use rm -rf

Or reboot the machine and try deleting once more.

Read more »

Adding 3GB to Boot.ini Windows 2008

Problem:

In Windows Server 2003, to increase the memory allocated the applications, we usually modify the boot.ini and add /3GB. However, there is not boot.ini in Windows 2008. How can more memory be allocated to user’s applications?

Solution:

Use the BCDEDIT command.

Read more »

Customizing R12 Start Page Logo

Customizing R12 Start Page Logo

Problem:

How do I change or customize the Oracle logo on the R12 E-Business Suite Oracle Application Framework (OAF)/Self-Service Pages?

Solution:

In EBS, navigate to System Administrator > Profile > System

Query “Corporate Branding Image for Oracle Applications” and set its value at the Site Level to name of the picture file with the new logo. The file can be PNG, JPG or GIF (you may need to experiment to confirm this).

On the server, place the picture file in the $OA_MEDIA directory (such as F:oraclePRODappsapps_stcomnjavaclassesoracleappsmedia).

Reference:

Customizing the Corporate Branding Image for JTF-based Pages [ID 1464570.1]

Changing Default Text on OAF Pages

Problem:

How do I change the default text, “E-Business Suite”, at the top of all Oracle Application Framework/Self-Service pages?

Solution:

Launch EBS and navigate to:

System Administrator > Application > Functions

In the Function column, query for FWK_HOMEPAGE_BRAND (type F11, type FWK_HOMEPAGE_BRAND, type Ctrl+F11).

One row appears in the form. Under the User Function Name column, type the text that you want to appear on the OAF pages and save the changes.

 

Web Cache Configuration Assistant fails, libdb.so.2: cannot open shared object file

Problem:

On CentOS 5.8, when installing 10g OEM Grid Control, the Web Cache Configuration Assistant fails.

Solution:

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

Read more »

Loading Workflow Information Using WFLOAD

Problem:

How do I transfer a workflow from one R12 instance to another?

Solution:

Use the WFLOAD command to download or upload the workflow.

Read more »

Moving Alerts Between R12 Instances

Problem:

How do I move Oracle Alerts between R12 instances?

Solution:

Use the FNDLOAD command.

Read more »

ORA-27300: OS system dependent operation:CreateThread failed with status: 8

Problem:

On Windows 2008, the R12.1 instance has become flaky, not allowing connections and responding slowly.

Solution:

Tweak the IRPStackSize registry parameter, or change the memory allocated to user processes using the BCDEDIT Windows command.

Read more »