Database upgrade 12c to 19c using DBUA
STEPS TO UPGRADE A DATABASE FROM 12C TO 19C DBUA UPGRADE 12C TO 19C TAKE A RMAN FULL BACKUP. STOPPING THE LISTENER RUN THE PREUPGRADE FIXUPS RUN THE PREUPGARDE…
Read MoreRMAN Clonning Active duplication
RMAN CLONNING WITH ACTIVEDUPLICATION: Steps in source database: STEP1:verify whether the database is up with pfile or spfile if started with spfile create a pfile from spfile and transfer the…
Read MoreMigration from Windows to linux Oracle 12c database to 19c database
MIGRATION FROM WINDOWS TO LINUX(12.1.0.1 TO 19.0.0) INSTALLED A DATABASE IN WINDOWS AND CHECKED THE PLATFORM NAME AND ENDIAN FORMAT CREATED A USER AND CREATED A TABLE IN…
Read MoreHow to create Oracle EBS (Applications User ) with only read privilege
Introduction Steps to create Oracle EBS Application user with read only priviliege Posted by Sakthi Sethu Perumal a.Connect to the Oracle EBS b.Select system Administrator responsibility Choose Users->Define Create a…
Read More11g 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 MoreUsers 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 MoreStarting 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 MoreHow 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 MoreError 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 MoreREP-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