[SOLVED] How to find the versions of adgrants.sql that have been applied previously on Oracle Database 12c under Oracle EBS R12.2.x?


Issue How to find the versions of adgrants.sql that have been applied previously on Oracle Database 12c under Oracle EBS R12.2.x? Solution Step 1.  Go to the Linux terminal and login as Oracle Database Tier manager Step 2. Set the environment and start the SQL * Plus session using the following commands (alternatively you may use Oracle S...
Continue reading
  142 Hits

[Solved] How to disable firewall in Oracle Linux 7.5?


Issue How to disable firewall in Oracle Linux 7.5?  Introduction to firewall in Oracle Linux 7.5 Unlike previous Oracle Linux releases which uses 'iptables' command, the newer Oracle Linux 7.x release uses 'firewalld' command to manage the firewall. Firewalld uses zones and services in comparison to iptables that make use of chains and rules. ...
Continue reading
  242 Hits

[SOLVED] How to open port 1521 in firewall under Oracle Linux 7.5?


Issue How to open port 1521 in firewall under Oracle Linux 7.5? Solution Use this command to find your active zone(s): firewall-cmd --get-active-zones It will say either 'public', 'dmz' or something else. You should only apply to the zones required. In case of 'public' use the following command: firewall-cmd --zone=public --add-port=1521/tcp --perm...
Continue reading
  140 Hits

[SOLVED] Error occurs when executing special instructions specified under README.txt of Patch 26825525 iAS Forms and Reports Server

Oracle E-Business Suite Installation of Release 12.2.0 failed with error RW-50004 under Oracle Linux 7.5 OS

Issue Unable to complete post patch application 'Special Instruction for formsapp.ear' steps for patch 26825525 (iAS Forms and Reports Server) and getting the following errors. Post Patch Application steps mentioned in the README.txt file of patch 26825525: ---------------------------------------------------------- SPECIAL INSTRUCTION FOR formsapp....
Continue reading
  141 Hits
  0 Comments

[SOLVED] Weblogic Server Smart Update 3.3.0 Utility takes very long time to load



Issue Weblogic Server Smart Update 3.3.0 Utility takes very long time to load Solution Increase the heap size to allow more memory. To do that simply open the bsu.sh file located at /u01/oracle/VIS/fs1/FMW_Home/utils/bsu/bsu.sh and increase the memory values. vi /u01/oracle/VIS/fs1/FMW_Home/utils/bsu/bsu.sh Present value  MEM_ARGS="-...
Continue reading
  113 Hits
  0 Comments

[SOLVED] Linux 7 user shows -bash-4.2 instead of username like [[email protected] ~]



Issue On login Oracle Linux 7.5 user shows -bash-4.2 instead of username like [[email protected] ~] Solution Use this command in your terminal to fix this issue:   export PS1='[\[email protected]\h \W]\$ ' If you want to show this prompt show after you reboot, you can try this (with su): echo "export PS1='[\[email protected]\h \W]\$ '" > /etc/profile.d/bash_prompt.sh Envir...
Continue reading
  107 Hits
  0 Comments

[SOLVED] How to change Weblogic Admin Server password in Oracle EBS Release 12.2?

Oracle E-Business Suite Installation of Release 12.2.0 failed with error RW-50004 under Oracle Linux 7.5 OS

Issue How to change Weblogic Admin Server password in Oracle EBS Release 12.2? Solution Simply run through the below mentioned steps: Step 1. Stop all Application Tier Services running under the Application Server: cd $INST_TOP/admin/scripts./adstpall.sh   Step 2. Now run the below command to change Oracle Weblogic Server password: [oracl...
Continue reading
  170 Hits

[SOLVED] How to find Linux Release/Version in Oracle Linux?

How to find Linux Release/Version in Oracle Linux?

Issue How to find Linux Release/Version in Oracle Linux? Solution Simply issue the following command to find the Linux Release: [[email protected] ~]# cat /etc/*releaseLSB_VERSION=base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarchOracle Linux Server release 6.5Red ...
Continue reading
  131 Hits

[SOLVED] How to fix error - File does not exist: favicon.ico

Error This error is thrown while in Apache Log while starting Applications Tier: File does not exist: /u01/install/APPS/inst/apps/EBSDB_ebs/portal/favicon.ico Log File Location = /u01/install/APPS/inst/apps/EBSDB_ebs/logs/ora/10.1.3/Apache File Name = error_log.1536192000.txt Solution Step 1. Complete any of the below mentioned optio...
Continue reading
  185 Hits

[SOLVED] ApplicationLogManager is not installed, may result in loader leaks. Set -Djava.util.logging.manager=oracle.classloader.util.ApplicationLogManager

Error Following error is thrown while starting Application Tier: ApplicationLogManager is not installed, may result in loader leaks. Set -Djava.util.logging.manager=oracle.classloader.util.ApplicationLogManager  Log File Directory = /u01/install/APPS/inst/apps/EBSDB_ebs/logs/ora/10.1.3/opmn File Name = default_group~oacore~default_gr...
Continue reading
  167 Hits

[SOLVED] How to disable firewall in Oracle Linux 7.5?

Oracle Linux 7.5 Firewall Disabled

Issue I installed Oracle E-Business Suite Release 12.2 in Virtualbox VM, but wasn't able to connect to its front-end from Windows host. After investigation I found that Oracle Linux firewall was open and it was blocking port 8000. I issued the following command to find its status: [[email protected] ~]# systemctl status firewalld ‚óŹ firewalld.serv...
Continue reading
  274 Hits

[SOLVED] How to delete a logical volume and resize existing one with the freed-up space in Oracle Linux 7.5?

Resize Oracle Linux 7.5 Logical Volume

Issue There are two issues that are being addressed here. Let's address them one by one. Issue 1 = How to delete a logical volume in Oracle Linux 7.5?  Solution Step 1. Find the logical volumes that exists in your installation: [[email protected] oracle]# df -h Filesystem Size Used Avail Use% Mounted on devtmpfs 5.2G 0 5.2G 0% /dev tmpfs 5.2...
Continue reading
  226 Hits

[SOLVED] Installing gparted in Oracle Linux 7.5 using Oracle's own EPEL mirror under Oracle Yum

Installing gparted in Oracle Linux 7.5 using Oracle's own EPEL mirror under Oracle Yum

Issue I wanted to resize my partition but when issue the command  yum install gparted  it wasn't getting gparted installed and simply gave me the error that gparted was not found in Oracle yum repository. So then the question is how can I install gparted in Oracle Linux 7.5 using Oracle's own Yum? Solution Oracle has its own EPEL (Extra P...
Continue reading
  496 Hits

[SOLVED] Oracle E-Business Suite Installation of Release 12.2.0 failed with error RW-50004 under Oracle Linux 7.5 OS

Oracle E-Business Suite Installation of Release 12.2.0 failed with error RW-50004 under Oracle Linux 7.5 OS

Error Oracle E-Business Suite Installation of Release 12.2.0 failed with error " RW-50004: Error code received when running external process ". Investigation done Step 1.  First have a look at the Installation log to see further details at the following location: RDBMS $ORACLE_HOME/temp/$CONTEXT_NAME/logs In my case the above log file was loca...
Continue reading
  293 Hits

[SOLVED] Getting error APP-FND-01564: ORACLE error 12514 in AFPCOA


Error Getting the following error while executing the script: The SQL statement being executed at the time of the error was: and was executed from the file . APP-FND-01564: ORACLE error 12514 in AFPCOA Cause: AFPCOA failed due to ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Solution In my case I was usi...
Continue reading
  280 Hits

[SOLVED] Error while opening up jnlp file in Oracle VM Manager in Firefox





Issue Getting error while opening up jnlp file in Oracle VM Manager. As a result unable to see the status of the VM's that were started. Investigation done 1. Latest Java blocks jnlp file possibly because of its certificates related settings. At the time of writing this post the latest Java was at Version 8 with Update 181. 2. Latest Firefox blocks...
Continue reading
  223 Hits

[SOLVED] Network eth0 and eth1 doesn't starts up automatically in Oracle Linux 5


Issue Networks eth0, eth1 and eth2 doesn't start automatically. Investigation done Found the following root causes for this issue: 1. On Boot was set to 'No' in eth0, eth1 and eth2  2. eth0, eth1 and eth2 nicknames were given as eth0.bak, eth1.bak and eth2.bak respectively 3. Network Manager service was not running Resolution A. Set On Boot to...
Continue reading
  225 Hits

[SOLVED] How to concatenate ova files in Windows10?


Issue How to concatenate ova files in Windows10 desktop? Solution Use this command if there are multiple ova files such as EB.ova.01, EB.ova.02, EB.ova.03 and you want to output them into EB.ova. Open command prompt and issue the following command. type EB.ova.01 EB.ova.02 EB.ova.03 > EB.ova Environment + ...
Continue reading
  406 Hits

Oracle Database Tier patch 24911308 failed to get applied - Oracle EBS R12.2.0


Error Description Database Tier patch 24911308 failed to get applied Oracle Interim Patch Installer version 12.1.0.1.10 Copyright (c) 2017, Oracle Corporation. All rights reserved.  Oracle Home : /u01/oracle/VIS/12.1.0  Central Inventory : /u01/oraInventory from : /u01/oracle/VIS/12.1.0/oraInst.loc  OPatch version : 12.1.0.1.10 ...
Continue reading
  1202 Hits

Where can I find the latest version of OPatch Utility?


Issue Where can I find the latest version of OPatch Utility? Solution Oracle ships OPatch as part of the standard product shipment. However, new versions of OPatch are occasionally released and are located under the OPATCH PLACEHOLDER Patch 6880880 Environment 1. Oracle E-Business Suite Release 12.2 2. Oracle Linux x86-64 Operating System
  908 Hits