Issue 

Error while saving a new location "FRM-40735: ON-INSERT trigger raised unhandled exception ORA-29273". See screenshot below.

Issue

After starting the Oracle Linux and login with root user, I type "startx" command to start the GUI mode. But I get error "starx command not found".

Issue

How to find Oracle Linux Distribution and Release Information?

Issue Summary

Getting java error when launching the console to view VM from Oracle VM Manager. Unable to view the VM Console.

Simply issue the following command to see Java Version:

$ java -version

1. The TZUpdater tool modifies the JDK/JRE software instance that is used to execute the tool. A single image of the JDK/JRE software is modified per execution. 

2. You must stop any running instances of the JDK/JRE software to be operated upon before you run the TZUpdater tool on that installed JDK/JRE software image.

1. You need to first setup the environment variable for ORACLE_HOME in your Path. But if you don't know that then simply change the directory to the place where Oracle Database has been installed.

2. Use the following command to view the list of all components and their associated versions in a specific Oracle Home:

1. You need to first setup the environment variable for ORACLE_HOME in your Path. But if you don't know that then simply change the directory to the place where Oracle Database has been installed.

2. Use the following command to view the installed top level components:

1. You need to first setup the environment variable for ORACLE_HOME in your Path. But if you don't know that then simply change the directory to the place where Oracle Database has been installed.

2. Use the following command to view the installed Oracle Homes and top level components:

Issue

Error in starting DB Listener for Oracle EBS 12i Database

Error Description

[tid: 10] [ecid: 0000JamlB3^Dg^05zzWByW1GJcXU000001,0] Cannot start Oracle Virtual Directory server: null.[[com.octetstring.vde.util.DirectoryException    at com.octetstring.vde.util.CSFUtil.refreshCredStore(CSFUtil.java:265)    at com.octetstring.vde.backend.BackendHandler.reloadDynamicConfig(BackendHandler.java:284)    at com.octetstring.vde.backend.BackendHandler.<init>(BackendHandler.java:257)    at com.octetstring.vde.backend.BackendHandler.init(BackendHandler.java:428)    at com.octetstring.vde.VDEServer.initialize(VDEServer.java:267)    at com.octetstring.vde.VDEServer.startServer(VDEServer.java:180)    at com.octetstring.vde.VDEServer.main(VDEServer.java:359)Caused by: oracle.security.jps.service.credstore.CredStoreException: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException: PKI-02002: Unable to open the wallet. Check password.

Workflow Errors Reported

Document Manager Failed With Error Number while processing Standard Purchase Order 6044

Solution 1

Use adpatch utility to recompile the forms, relink libraries and invalid db objects (see here for more info How to recompile INVALID objects in Oracle EBS Database?)

Error's description by 'adpatch' utility (while applying patch 9239090)

The following Oracle Forms objects did not generate successfully:

Error's description by 'adpatch' utility (while applying patch 9239090)

The following Oracle Forms objects did not generate successfully:

1. To investigate the error you must check the adpatch.log and logs associated with the worker files. These can be found under following directory:

$APPL_TOP/admin/[SID]/log

This can be done in several ways. Below I have described the most easiest ones.

Option 1 - Use 'adadmin' utility to recompile all invalid objects in the database

You must complete the following steps in order to upgrade from Oracle E Business Suite (EBS) 12.1.1 to 12.1.3.

1. Download Patch 9239030. Unzip patch in a directory - say /u01/patches. Now make sure you give execute permissions on this directory. To be on safe side I simply use the following command:

1. Open a new terminal window and setup environment to run scripts on Database Tier (for more info see )

2. Start the listener

In this example I will demonstrate you how 'adctrl' utility is used for checking the status of workers or restarting workers while applying patches.

1. Open a new terminal window and setup environment to run scripts on Application Tier (for more info see How to setup environment for Application Tier at linux terminal?)