Krishna Sudagani (Oracle Application DBA, OCI Admin, and Middleware Expertise)

Over a decade of expertise as an Oracle DBA, Application DBA, OCI Admin, and Fusion Middleware specialist, I’ve solved complex challenges, optimized systems, and led innovations across diverse Oracle platforms. Now, I’m passionate about sharing insights to bridge the gap between theory and practice. From database optimization to middleware best practices, join me as we explore Oracle technologies and grow together. Stay tuned for expert tips and resources!

Tuesday, 29 November 2016

weblogic.nodemanager.common.ConfigException: Identity key store file not found: DemoIdentity.jks (SOA 12c)

We are getting below error while starting Node-manager in weblogic 12c server. Below is the steps to resolve the issue.

Error Message:

+ /usr/java/jdk1.8.0_112/bin/java -server -Xms32m -Xmx200m -Dweblogic.RootDirectory=/u01/soa_12c/Middleware/MW_Home/wlserver/../oracle_common/common/nodemanager -Dcoherence.home=/u01/soa_12c/Middleware/MW_Home/wlserver/../coherence -Dbea.home=/u01/soa_12c/Middleware/MW_Home/wlserver/.. -Xverify:none -Djava.system.class.loader=com.oracle.classloader.weblogic.LaunchClassLoader -Djava.security.policy=/u01/soa_12c/Middleware/MW_Home/wlserver/server/lib/weblogic.policy -Dweblogic.nodemanager.JavaHome=/usr/java/jdk1.8.0_112 weblogic.NodeManager -v

weblogic.nodemanager.common.ConfigException: Identity key store file not found: /u01/soa_12c/Middleware/MW_Home/oracle_common/common/nodemanager/security/DemoIdentity.jks

at weblogic.nodemanager.server.SSLConfig.loadKeyStoreConfig(SSLConfig.java:225)

at weblogic.nodemanager.server.SSLConfig.access$000(SSLConfig.java:33)

at weblogic.nodemanager.server.SSLConfig$1.run(SSLConfig.java:118)

at java.security.AccessController.doPrivileged(Native Method)

at weblogic.nodemanager.server.SSLConfig.<init>(SSLConfig.java:115)

at weblogic.nodemanager.server.NMServer.<init>(NMServer.java:143)

at weblogic.nodemanager.server.NMServer.main(NMServer.java:527)

at weblogic.NodeManager.main(NodeManager.java:31)

+ status=1

+ set +x

Fix:

Copy the file <domainhome>/security/DemoIdentity.jks to <domainhome>/nodemanager/security/DemoIdentity.jks

Copy the file <domainhome>/security/DemoIdentity.jks to <MW_Home>/oracle_common/common/nodemanager/security/DemoIdentity.jks

Wednesday, 23 November 2016

How to find weblogic server version in E-Business Suite R12.2.5

Below steps to find the Weblogic server version in E-Business Suite R12.2.5

Step 1:

Goto $FMW_HOME

[applmgr@test26 FMW_Home]$ pwd
/u01/app/applmgr/TEST/fs1/FMW_Home

[applmgr@test26 FMW_Home]$ grep -I version registry.xml

<?xml version="1.0" encoding="UTF-8"?><bea-product-information xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:gpr="http://www.bea.com/ns/cie/gpr">

Step 2:

Monday, 14 November 2016

BI AppS ETL fails with the 'ORA-01792: maximum number of columns in a table or view is 1000' Error Message

We are getting below error while loading the data into BI APPS server .

Error:

Caused By: java.sql.SQLSyntaxErrorException: ORA-01792: maximum number of columns in a table or view is 1000

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows => ORA-20942:

Fix:

The workaround is to set "_fix_control"='17376322:OFF'

SQL> alter session set "_fix_control"='17376322:OFF';

or at system level :

SQL> alter system set "_fix_control"='17376322:OFF';

Apply Patch 19509982 if available for your DBVersion and Platform

Friday, 11 November 2016

Weblogic Server 12.1.2 Performance Issue Due To weblogic.socket.NIOSocketMuxer

Weblogic server 12.1.2 in a runnable state consuming high CPU resources.

Error:

"LDAPConnThread-579 ldaps://ldapserver.us.oracle.com:636" daemon prio=10 tid=0x00000000041f6800 nid=0x56d7 runnable [0x00007f9b6b9f8000]
java.lang.Thread.State: RUNNABLE
at sun.nio.ch.IOUtil.drain(Native Method)
at sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:90)
- locked <0x000000078a2f6e48> (a java.lang.Object)
at sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:87)
- locked <0x000000078a2f6b48> (a sun.nio.ch.Util$2)
- locked <0x000000078a2f6b38> (a java.util.Collections$UnmodifiableSet)
- locked <0x000000078a2f6910> (a sun.nio.ch.EPollSelectorImpl)
at sun.nio.ch.SelectorImpl.select(SelectorImpl.java:98)
at weblogic.socket.NIOSocketMuxer$NIOInputStream.readInternal(NIOSocketMuxer.java:815)
at weblogic.socket.NIOSocketMuxer$NIOInputStream.read(NIOSocketMuxer.java:759)
at weblogic.socket.NIOSocketMuxer$NIOInputStream.read(NIOSocketMuxer.java:742)
at weblogic.socket.JSSEFilterImpl.readFromNetwork(JSSEFilterImpl.java:462)
at weblogic.socket.JSSEFilterImpl.read(JSSEFilterImpl.java:424)
at weblogic.socket.JSSESocket$JSSEInputStream.read(JSSESocket.java:64)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x000000079c2dc630> (a java.io.BufferedInputStream)
at netscape.ldap.ber.stream.BERElement.getElement(Unknown Source)
at netscape.ldap.LDAPConnThread.run(Unknown Source)
at java.lang.Thread.run(Thread.java:745)

Fix:

In this case, as customer was using Linux x86-64, changing the MuxerClass from weblogic.socket.NIOSocketMuxer to weblogic.socket.PosixSocketMuxer worked.

In WLS Admin Console

Go to Environment > Servers > Server Name > Tuning, under Advanced, set the Muxer Class based on the OS and Reboot the server.

Solaris/HP-UX Native Muxer : weblogic.socket.DevPollSocketMuxer
POSIX Native Muxer : weblogic.socket.PosixSocketMuxer
Windows Native Muxer : weblogic.socket.NTSocketMuxer

Java Muxer : weblogic.socket.JavaSocketMuxer

You may also set the above in the Weblogic startup scripts via the JAVA_OPTIONS:
-Dweblogic.MuxerClass=weblogic.socket.PosixSocketMuxer

Tuesday, 8 November 2016

Weblogic console page is not coming up after server reboot

We have bounced the server and restarted the weblogic services. After restating the services we are unable to access the console page.

Cause:

We found that Linux firewalls are enabled the server. When we rebooted the server, by detault iptables got restarted.

To check the status of your firewall and all rules, enter:
# iptables -L -n (as root user)

Fix:

Stop the ipchains service(as root user):
# service ipchains stop

Stop the iptables service:
# service iptables stop

Stop the ipchains service from starting when you restart the server:
# chkconfig ipchains off

Stop the iptables service from starting when you restart the server:
# chkconfig iptables off

Monday, 7 November 2016

Ora-12547: tns:lost contact 12c

We are unable to access the jdbc url and sql developer after configuring E-Business suite R12.2.5

Error:

I/O Error: Connection Reset
ora-12547: tns:lost contact 12c

Fix:

Backup the sqlnet.ora file from both DB and Apps side and comment the below parameters.

#tcp.validnode_checking = yes
#tcp.invited_nodes=(hostname)

Thursday, 3 November 2016

libmawt.so: libXi.so.6: cannot open shared object file: No such file or directory

We are getting below error while installing BI APPS rcu.

Error:

[oracle@test-krishna bin]$ ./rcu
Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/Softs/weblogic/rcu_obi/jdk/jre/lib/i386/xawt/libmawt.so: libXi.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1807)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1703)
at java.lang.Runtime.load0(Runtime.java:770)
at java.lang.System.load(System.java:1003)
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1807)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1724)
at java.lang.Runtime.loadLibrary0(Runtime.java:823)
at java.lang.System.loadLibrary(System.java:1028)
at sun.security.action.LoadLibraryAction.run(LoadLibraryAction.java:50)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Toolkit.loadLibraries(Toolkit.java:1605)
at java.awt.Toolkit.<clinit>(Toolkit.java:1627)
at com.jgoodies.looks.LookUtils.isLowResolution(LookUtils.java:484)
at com.jgoodies.looks.LookUtils.<clinit>(LookUtils.java:249)
at com.jgoodies.looks.plastic.PlasticLookAndFeel.<clinit>(PlasticLookAndFeel.java:135)
at oracle.sysman.assistants.rcu.ui.InteractiveRCUModel.<init>(InteractiveRCUModel.java:117)
at oracle.sysman.assistants.rcu.Rcu.execute(Rcu.java:307)
at oracle.sysman.assistants.rcu.Rcu.main(Rcu.java:363)

Fix:

[root@test-krishna Desktop]# yum install libXtst.i686

Resolving Dependencies
--> Running transaction check
---> Package libXtst.i386 0:1.0.1-3.1 will be updated
---> Package libXtst.i686 0:1.2.2-2.1.el6 will be an update
--> Processing Dependency: libXi.so.6 for package: libXtst-1.2.2-2.1.el6.i686
--> Running transaction check
---> Package libXi.i686 0:1.7.4-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================
Updating:
libXtst i686 1.2.2-2.1.el6 base 19 k
Installing for dependencies:
libXi i686 1.7.4-1.el6 base 37 k

Transaction Summary
========================================================================================================================================================================
Install 1 Package(s)
Upgrade 1 Package(s)

Total download size: 55 k
Is this ok [y/N]: Y
Downloading Packages:
(1/2): libXi-1.7.4-1.el6.i686.rpm | 37 kB 00:00
(2/2): libXtst-1.2.2-2.1.el6.i686.rpm | 19 kB 00:00
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 55 kB/s | 55 kB 00:01
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Installing : libXi-1.7.4-1.el6.i686 1/3
Updating : libXtst-1.2.2-2.1.el6.i686 2/3
Cleanup : libXtst-1.0.1-3.1.i386 3/3
Verifying : libXi-1.7.4-1.el6.i686 1/3
Verifying : libXtst-1.2.2-2.1.el6.i686 2/3
Verifying : libXtst-1.0.1-3.1.i386 3/3

Dependency Installed:
libXi.i686 0:1.7.4-1.el6

Updated:
libXtst.i686 0:1.2.2-2.1.el6

Complete!

Monday, 17 October 2016

Script to find the number of active users in oracle R12 application

select 'Number of user sessions : ' || count( distinct session_id) How_many_user_sessions from icx_sessions icx where disabled_flag != 'Y'
and PSEUDO_FLAG = 'N'
and (last_connect + decode(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'), NULL,limit_time, 0,limit_time,FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT')/60)/24) > sysdate and counter < limit_connects;

Monday, 3 October 2016

How to Configuring Node Manager to Start Managed Servers

If a Managed Server contains other Oracle Fusion Middleware products, such as Oracle SOA Suite, Oracle WebCenter Portal, or Oracle JRF, the Managed Servers environment must be configured to set the correct classpath and parameters. This environment information is provided through the start scripts, such as startWebLogic and setDomainEnv, which are located in the following directory:

$DOMAIN_HOME/bin

If the Managed Servers are started by Node Manager (as is the case when the servers are started by the Oracle WebLogic Server Administration Console or Fusion Middleware Control), Node Manager must be instructed to use these start scripts so that the server environments are correctly configured. Specifically, Node Manager must be started with the property StartScriptEnabled=true.

There are several ways to ensure that Node Manager starts with this property enabled. As a convenience, Oracle Fusion Middleware provides the following script, which adds the property StartScriptEnabled=true to the nodemanager.properties file:

$ORACLE_COMMON_HOME/common/bin/setNMProps.sh.

For example, on Linux, execute the setNMProps script and start Node Manager:

ORACLE_COMMON_HOME/common/bin/setNMProps.sh
MW_HOME/wlserver_n/server/bin/startNodeManager.sh

When you start Node Manager, it reads the nodemanager.properties file with the StartScriptEnabled=true property, and uses the start scripts when it subsequently starts Managed Servers. Note that you need to run the setNMProps script only once.

Also note that when the StartScriptEnable property is set to true, the Node Manager reads the startWebLogic script, which in turns reads the setDomainEnv script. As a result, you must make any tuning changes by editing the setDomainEnv script. Any changes that are performed using the command line or Administration Console will not be implemented when Node Manager starts the servers. For example, if you use the Administration Console to change the server start arguments, those changes are written to config.xml, but the Node Manager ignores these settings and uses those in setDomainEnv.

Sunday, 18 September 2016

Oracle E-Business Suite 12.2.6 Now Available

Oracle E-Business Suite Release 12.2.6 is now available.

Instructions for downloading and applying this latest release update pack (RUP) for the EBS 12.2 codeline can be found here:

Oracle E-Business Suite 12.2.6 Readme (Doc ID 2114016.1)

What Does Release 12.2.6 Include?

As a consolidated suite-wide patchset, this RUP includes new features, statutory and regulatory updates, and enhancements for stability, performance, and security.

Release 12.2.6 is cumulative. That means that as well as providing new updates for this release, it also includes updates that were originally made available as one-off patches for earlier 12.2 releases.

For a complete list of new features, refer to:
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (Doc ID 1302189.1)

Thursday, 15 September 2016

RCU/jdk/jre/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory

I got this error while installing RCU on OEL6.

$ ./rcu
Exception in thread "main" java.lang.UnsatisfiedLinkError:
/Installation/rcu/rcuHome/jdk/jre/lib/i386/xawt/libmawt.so:
libXtst.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1778)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1674)
at java.lang.Runtime.load0(Runtime.java:770)
at java.lang.System.load(System.java:1003)
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1778)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1695)
at java.lang.Runtime.loadLibrary0(Runtime.java:823)
at java.lang.System.loadLibrary(System.java:1028)

Cause:
libXtst rpm for 32 bit is missing.

Fix:
Please check that the libXtst-xx.el6.i686.rpm (32 bit) installed.
rpm -qa |grep libXtst
If it is not installed the need to install:
rpm -ivh libXtst-xx.el6.i686.rpm

Friday, 9 September 2016

ORA-01654: unable to extend index APPLSYS.AD_PATCH_COMMON_ACTIONS_U2 by 16 in tablespace APPS_TS_TX_IDX

While applying an NLS Patch getting ORA-1654 errors occurred due to space issues.

Error:

ORA-01654: unable to extend index APPLSYS.AD_PATCH_COMMON_ACTIONS_U2 by 16 in tablespace APPS_TS_TX_IDX

ORA-01654: unable to extend index APPLSYS.AD_PROGRAM_RUN_TASK_JOBS_N1 by 16 in tablespace APPS_TS_TX_IDX

After fixing the ORA-1654 errors by setting the APPS_TS_TX_IDX datafile to autoextend, reapplying the same NLS patch gives the following warning message and the patch is skipped:

Fix:

1. Resolve the ORA-1654 error per any of the available methods.

2. Test reapplying the patch using following option:

adop phase=apply apply_mode=downtime patches=19676458 options=forceapply restart=no abandon=yes

3. Confirm the patch applied successfully using the above command.

Tuesday, 23 August 2016

INST-08109: An ORACLE_HOME environment variable should not be defined

I got the below error while installing Oracle BI 11.1.1.9 on Linux 5.7.

Error :

INST-08109: An ORACLE_HOME environment variable should not be defined

Fix:

unset ORACLE_HOME and try to re-install.

INST-08109: An ORACLE_HOME environment variable should not be defined

Wednesday, 10 August 2016

Error in invoking target client_sharedlib of makefile

I am getting below error while installing Oracle Database 12c in OEL6.

Error:

Fix:

Step 1:
Edit /etc/sysctl.conf file and entry followings.
#vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144

Step 2:

Create the below soft links.

ln -s /etc /etc/rc.d
ln -s /usr/bin/awk /bin/awk
ln -s /usr/bin/basename /bin/basename
ln -s /usr/bin/rpm /bin/rpm
ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /usr/lib64/

Issue resolved after done all the above steps/changes.

Error in invoking target 'client_sharedlib' of makefile

I am getting below error while installing Oracle Database 12c in OEL6.

Error:

Error in invoking target 'client_sharedlib' of makefile

I am getting below error while installing Oracle Database 12c in OEL6.

Error:

Sunday, 24 July 2016

Insufficient free space in /tmp while installing SOA 12c

$JAVA_HOME/java -jar fmw_12.1.3.0.0_soa_quickstart.jar

Insufficient free space in /tmp/orcl4316142800341622207.tmp to extract the installer. Actual 365 MB. Required 3053 MB.

In my case we don't have free space under /tmp mount. So i have created /tmp directory under different location.

Fix:

mkdir -p /u01/tmp
chmod -R 777 /u01/tmp
export _JAVA_OPTIONS="-Djava.io.tmpdir=/u01/tmp"
java -jar fmw_12.1.3.0.0_soa_quickstart.jar

Wednesday, 20 July 2016

CXF Error Deploying Updated p6ws.war File

Getting below error message while deploying the p6ws.war File

Error:

Servlet: "cxf" failed to preload on startup in Web application: "p6ws.war".
java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.apache.cxf.wsdl.WSDLManager' defined in URL [zip:/home/weblogic/Oracle/Middleware/user_projects/domains/iALM/servers/AdminServer/tmp/_WL_user/p6ws/nmdpik/war/WEB-INF/lib/cxf-bundle.jar!/META-INF/cxf/cxf.fixml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: javax/wsdl/WSDLException

Cause:

The wsdl4j-1.6.2.jar is missing from the p6ws.ear/p6ws.war file.

Fix:

In the <P6 Web Services Home Directory> edit the updateWSWar.cmd or updateWSWar.sh file. Ensure the CXF_HOME path is set to the folder where wsdl4j-1.6.2.jar has been copied.
Save and execute the updateWSWar file to update the p6ws.ear/p6ws.war file.
Redeploy the p6ws.ear/p6ws.war file.

Tuesday, 28 June 2016

Oracle.DataAccess.Client.OracleException: ORA-06550: line 1, column 15

Error:

We are getting below error while installing UPK Server and Client on windows server 2012 R2.

UPK client / server Installation fails with a Library Loader log:

@ System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]:
@ ORA-06550: line 1, column 15:
@ PLS-00905: object ODSERVER_11.PART_EXISTS is invalid
@ ORA-06550: line 1, column 7:
@ PL/SQL: Statement ignored (Fault Detail is equal to An ExceptionDetail,
@ likely created by IncludeExceptionDetailInFaults=true, whose value is:
@ Oracle.DataAccess.Client.OracleException: ORA-06550: line 1, column 15:
@ PLS-00905: object ODSERVER_11.PART_EXISTS is invalid
@ ORA-06550: line 1, column 7:
@ PL/SQL: Statement ignored

Fix:

Stop the installer before running Library Loader and manually add grant permissions.

Steps:

Drop the tablespace and users. Start a fresh installation.
Create a setupdiag.ini

Locate the ..\setup\Branding\UPK\Installer folder

Create a new notepad file called setupdiag.ini

Open the file and enter the following:

[SetupDebug]

Stopbeforelibraryloader=1

Save and close the file.

Create a setupdiag.ini
Start installer and enter credentials desired to be created
Installer pauses
Grant the execute privileges

Log in as SYSDBA, run the the following queries:

grant execute on sys.dbms_lob to ODSERVER;

grant execute on sys.dbms_lob to ODSERVER_APP;

Log into Oracle with the credentials of the schema created (i.e.,ODSERVER)

Run the following query:

select object_name, object_type from obj where status !='VALID';

returned two FUNCTIONS:

ADD_PART

PART_EXISTS

Recompile the invalid objects

alter compile;

example: alter FUNCTION ADD_PART compile;

example: alter FUNCTION PART_EXISTS compile;

Let installer continue

Click Finish