Oracle Solutions
474 FOLLOWERS
Oraclesolutions intends to share all the valuable knowledge and keys to relevant products of Oracle Especially Databases and ERP.
Oracle Solutions
3d ago
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
Oracle Solutions
3d ago
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
Oracle Solutions
3d ago
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
Oracle Solutions
3d ago
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
Oracle Solutions
3d ago
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
Oracle Solutions
3d ago
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
Oracle Solutions
3d ago
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
Oracle Solutions
1w ago
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
Oracle Solutions
1w ago
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
Oracle Solutions
1w ago
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