The post Updating OS in Oracle RAC appeared first on Oracle Solutions. Updating OS in Oracle RAC running on Azure using Flashgrid Software In this blog post we will talk about on how to update the OS for nodes running Oracle RAC Database on Flashgrid Cluster. Note: Simultaneously updating OS and applying Grid Infrastructure patches in rolling fashion is not recommended. Nodes should not be rebooted while GI cluster is in rolling patching mode. Note: Running yum update without first stopping Oracle and FlashGrid services may result in the services restarting non-gracefully during the update. No ..read more

The post April CPU JDK Upgrade on DB appeared first on Oracle Solutions. April CPU JDK Upgrade on DB and Grid Homes in Oracle 19c Real Application Cluster Setup   Current Version:- GRID HOME:- grid> cd $GRID_HOME/jdk/bin grid> ./java -version java version “1.8.0_311” Java(TM) SE Runtime Environment (build 1.8.0_311-b11) Java HotSpot(TM) 64-Bit Server VM (build 25.311-b11, mixed mode)   ORACLE_HOME:- oracle> $ORACLE_HOME/jdk/bin oracle> ./java -version java version “1.8.0_311” Java(TM) SE Runtime Environment (build 1.8.0_311-b11) Java HotSpot(TM) 64-Bit Server VM (build 25 ..read more

The post Changing IP Address in an Oracle EBS R12 Environment appeared first on Oracle Solutions. Changing IP Address in an Oracle EBS R12 Environment 1. First, Change the IP Address of the Server by editing the /etc/hosts file 2. Now, Verify the current IP address setup in the Oracle EBS environment. Connect as apps user into SQL*Plus and run: select  NODE_NAME, STATUS, NODE_MODE, NODE_ID,SERVER_ADDRESS, HOST, DOMAIN, WEBHOST, VIRTUAL_IP from fnd_nodes where node_name = upper(‘hostname’); 3. Run the following command to remove the old ip address from the Oracle EBS tables: perl ..read more

The post AUTOCONFIG COULD NOT SUCCESSFULLY INSTANTIATE THE FOLLOWING FILES appeared first on Oracle Solutions. ERROR Error: ****** DB autoconfig Error: ***************** [AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase of its execution. Errors are grouped by directory and phase. The report format is: [INSTANTIATE PHASE] AutoConfig could not successfully instantiate the following files: Directory: /U01/PROD/db/tech_st/11.2.0.3/appsutil/install/PROD_proddb adcrdb.sh  AutoConfig is exiting with status 1   SOLUTION   Check adcrdb.s ..read more

The post Adrelink Fails With Error tech_st/10.1.2/lib/stubs/libc.so.6 collect2: ld returned 1 exit status appeared first on Oracle Solutions. ERROR Adrelink Fails With Error tech_st/10.1.2/lib/stubs/libc.so.6 collect2: ld returned 1 exit status /u01/app/applmgr/TST123/apps/tech_st/10.1.2/lib/sysliblist` -ldl -lm -lpthread /usr/bin/ld: cannot find /u01/prod/apps/tech_st/10.1.2/lib/stubs/libc.so.6 collect2: ld returned 1 exit status make: *** [/u01/app/applmgr/TST123/apps/apps_st/appl/ad/12.0.0/bin/adpchnew] Error 1 Done with link of ad executable ‘adpchnew’ on Thu Oct 27 22:11:12 EDT 2016 Relin ..read more

The post How to Create The Service Manager ‘FNDSM’ on Oracle Applications appeared first on Oracle Solutions. Create The Service Manager ‘FNDSM’ Run below command to check if node is registered for FNDSM:- select CONCURRENT_QUEUE_NAME from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME like ‘FNDSM%’; if not then follow Note.218893.1 :How to Create The Service Manager ‘FNDSM’ on Oracle Applications SOLUTION From the Application tier: 1. Log in as applmgr 2. cd to $FND_TOP/patch/115/sql 3. Run the script: afdcm037.sql 4. This script will create libraries for FNDSM and create Managers for Pree ..read more

The post Enable Automatic Compilation of JSP pages in R12 appeared first on Oracle Solutions. Enable Automatic Compilation of JSP pages in R12 1.Login into Oracle E-Business suite and select System Administrator responsibility 2. Select function AutoConfig  (under Oracle Applications Manager) For each web tier server perform the following: -Click on pencil icon under Edit Parameters -Select tab System -Expand section jtff_server 3. Change value for the entry s_jsp_main_mode from justrun to recompile Confirm the change by clicking Save          button 4. Run AutoCo ..read more

The post Removing Old Grid Home appeared first on Oracle Solutions. Manually Remove an Old Grid Home After Upgrading/Patching to a Higher Grid Home on ODA 1. Check the components and their versions [root@testlinux ~]# odacli describe-component System Version ————— 19.20.0.0.0 System node Name ————— testlinux Local System Version ————— 19.20.0.0.0 Component Installed Version Available Version —————————————- ——————– ——————– OAK 19.20.0.0.0 up-to-date GI 19.20.0.0.230718 up-to-date DB { [OraDB19000_home5 [db1,db2]]19.20.0.0.230718 up-to-date [OraDB19000_home6 [db3]]19.20.0.0.230718 up-to-date } D ..read more

The post Materialized View refresh error appeared first on Oracle Solutions. Materialized View refresh error generating huge Archive Logs after Database Upgrade to 19c. Issue:- A huge amount of archive log generation when materialized view refreshing after database upgrade from 11g to 19c and performance issues while accessing the database.   Analysis:- On checking the issue it was noticed that a database feature naming “MV Refresh stats Collection” was introduced from Oracle Database 12.2.0.1. This is used to monitor refresh performance of Materialized views. Database collects and stores ..read more

The post AC-50480: Internal error occurred appeared first on Oracle Solutions. AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora SOLUTION: AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora. [ID 1324667.1]   To implement the solution, please execute the following steps: NOTE: Ensure that you have taken a backup of your system before applying the recommended solution. 1. Clean the Data Topology Model Sqlplus apps/… SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN; COMMIT; EXIT; 2. Run AutoConfig on all tiers, firstly ..read more