Database Blog

11g RAC :Convert NON RAC database to RAC database using RCONFIG

Introduction This blog is about converting NON RAC database to RAC database using RCONFIG in 11g RAC Posted by JAYAKRISHNA 11g RAC :Convert NON RAC database to RAC database using RCONFIG…

Read More

Users Receive Error “Exception: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object” During Login To E-Business Suite

Introduction Solution to fix Users Receive Error “Exception: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object” During Login To E-Business Suite Posted by Jayachandran A When attempting to login EBS, the following…

Read More

Starting Http Server by “Opmnctl Startall” result with “[error] (79) Value too large for define data type: could not open transfer log file /apps/oracle/logs/access_log” error in error_log file

Introduction Solution to fix the error (79) Value too large for define data type when Starting Http Server by “Opmnctl Startall” Posted by Jayachandran A OMS_HOME/Apache/Apache/log/error_log shows: [timestamp] [error] (79) Value…

Read More

How to change oc4jadmin password for Application Server

Introduction Steps to change oc4jadmin password for Application Server Posted by Karthick How to change oc4jadmin password for Application Server You have to change the oc4jadmin password for a remote account without using  Application Server Control: Locate the following configuration file in the Oracle home of the OC4J instance: vi ORACLE_HOME/oc4j_instance_name/j2ee/home/config/system-jazn-data.xml Edit the system-jazn-data.xml file and locate the following entry for the oc4jadminuser: <user> <name>oc4jadmin</name> <display-name>OC4J Administrator</display-name> <guid>41A2E560C96711DABFD08D3BF8B780C4</guid>description>OC4J Administrator</description><credentials>{903}4nlfYYDwaqMJipVbGXuS2ce8egfwBPqp</credentials> </user> Replace the value of the <credentials> element with the new password. Be sure to include an exclamation point character (!) before the password.For example: <credentials>!welcome123</credentials> The exclamation point ensures that the password will be encrypted in the configuration file.  Save your changes and exit the system-jazn-data.xmlfile. Restart the OC4J instance.nohup $ORACLE_HOME/bin/oc4j -start & After…

Read More

Error while running the pre-clone script on oracle application

Introduction Steps to fix the Error while running the pre-clone script on oracle application Posted by Jayachandran A When we run the pre-clone script we are getting the below error as…

Read More

REP-51019 system user authentication is missing in oracle reports 12c

Introduction Steps to solve REP-51019 system user authentication is missing in oracle reports 12c Posted by Venkateshwaran REP-51019 system user authentication is missing 1)  In  rwservlet.properties confirm SSO is already disabled:…

Read More

AWR Snapshots are not generated Automatically

Introduction Steps to solve when AWR  Snapshots are not generating automatically Posted by Saravanan Scenario: ———— Oracle Database 11.2.0.4. My AWR Snapshots were not being generated even though it was full…

Read More

EBS R12.2 Cloning Steps

Introduction Steps to clone EBS R12.2 Clonning Posted by Venkatesh R K  NOTE: The following Clone approach is applicable for the APPLICATION version from R12.2.1 To R12.2.4 ENVIRONMENT:- Source:- BASE_PATH=/s01/oracle/R122 RUN_FILE_SYSTEM=/s01/oracle/R122/fs1…

Read More

Alert Log: Shutdown Waiting for Active Calls to Complete.

Introduction Steps to solve Shutdown Waiting for Active Calls to Complete. Posted by JAYAKRISHNA  Alert Log: Shutdown Waiting for Active Calls to Complete. Error: You are attempting to shut down the…

Read More

OATM Migration Appears to Have Hung. How Can I Monitor It’s Progress?

Introduction Solution to fix OATM Migration Appears to Have Hung. Posted by JAYAKRISHNA OATM Migration Appears to Have Hung. How Can I Monitor It’s Progress? The Oracle Applications Tablespace Model was…

Read More