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

<Nov 29, 2016 9:25:18 AM IST> <INFO> <Loading domains file: /u01/soa_12c/Middleware/MW_Home/oracle_common/common/nodemanager/nodemanager.domains>

<Nov 29, 2016 9:25:18 AM IST> <WARNING> <Domains file not found: /u01/soa_12c/Middleware/MW_Home/oracle_common/common/nodemanager/nodemanager.domains>

<Nov 29, 2016 9:25:22 AM IST> <INFO> <Loading identity key store: FileName=/u01/soa_12c/Middleware/MW_Home/oracle_common/common/nodemanager/security/DemoIdentity.jks, Type=jks, PassPhraseUsed=true>

<Nov 29, 2016 9:25:22 AM IST> <SEVERE> <Fatal error in NodeManager server>

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

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">

        <component name="Common Infrastructure Engineering" version="7.4.0.0" InstallDir="">

        <component name="WebLogic Server" version="10.3.6.0" InstallDir="/u01/app/applmgr/BODHTREE/fs1/FMW_Home/wlserver_10.3">

        <component name="Oracle Configuration Manager" version="10.3.5.0" InstallDir="">

Step 2:

Login to http://<server_name>:port/console

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';

 

OR

Apply Patch 19509982 if available for your DBVersion and Platform

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

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

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)

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!