Monday, 17 September 2018

ORA-12152 "Unable To Send Break Message" on Connection

When trying to login to the database from a client(Toad, SQL Developer) when using a Cisco GSS and a CSM (Content Switch Module) the connection fails to complete or fails before receiving any data with a network related Error: ORA-12152 "Unable To Send Break Message"
Solution: To resolve such an issue, make sure all switches or firewalls are set to the highest possible value and test. Once all connections are successful, the idle time limit can be tuned downward to a value that won't cause an interruption. This type of configuration would normally be handled by the Network Administrator of a system so this information should be passed on to them for actioning.
Ref:ORA-12152 "Unable To Send Break Message" on Connection [ID 363638.1]
OR
Error: ORA-12152 "Unable To Send Break Message"
Cause: Unable to send break message. Connection probably disconnected.
Action: Re-establish connection. If the error is persistent, turn tracing and re-execute the operation.
Or you can try this:
Add SQLNET.EXPIRE_TIME to the database sqlnet.ora file. This is the file located $ORACLE_HOME/network/admin directory or the directory specified by
The EXPIRE_TIME should be set to the highest value possible that is within the firewall idle connection timeout, to limit the amount of network traffic generated.
For example if the firewall timeout is 20 minutes set: SQLNET.EXPIRE_TIME=15

How to configure XVFB in AIX Environment??

Issue: We are facing concurrent request running continuously not completed issue on live server.

Cause: Due to VNCSERVER got hanged.

Solution: To resolve it we have installed XVFB Server which is the alternative for vncserver.
so we can kill the vncserver process before installation of XVFB.

Resolve this issue by Download & Install below RPMS:
X11.vfb
OpenGL.OpenGL_X.dev
Pre Req RPM PKG for OpenGL.OpenGL_X.dev
-rw-r-----    1 root     system      1402880 Sep 14 14:25 OpenGL.OpenGL_X.adt
-rw-r-----    1 root     system     21670912 Sep 14 14:25 OpenGL.OpenGL_X.dev
-rw-r-----    1 root     system     35701760 Sep 14 14:25 OpenGL.OpenGL_X.rte
-rw-r-----    1 root     system      3738624 Sep 14 14:25 OpenGL.OpenGL_X.tools

Step 1: Installtation Process by root User.
# installp -agcd . X11.vfb

# installp -agcd . OpenGL.OpenGL_X.dev

After installtion check DISPLAY

# export DISPLAY=erpprodappl:0.0
# xclock
Xlib: connection to "erpprodappl:0.0" refused by server
Xlib: Invalid MIT-MAGIC-COOKIE-1 key
Error: Can't open display: erpprodappl:0.0
# hostname
appnode2
# export DISPLAY=172.16.1.22:0.0
# xclock
Error: Can't open display: 172.16.1.22:0.0

Step 2: Run Below command to start XVFB Server.
# /usr/lpp/X11/bin/xinit /usr/lpp/X11/bin/mwm -- :0 -vfb -force -x abx -x dbe -x GLX &
[1]     10813502
#
:0
# xhost + 172.16.1.22
172.16.1.22 being added to access control list

Step 3: check X server running status.
# ps -ef|grep vfb OR  ps -ef|grep X11
    root 10617054 10813502   0 14:34:41  pts/0  0:00 /usr/lpp/X11/bin/X -cc 4 -x abx -x dbe -x GLX -D /usr/lib/X11/rgb :0 -vfb -force -x abx -x dbe -x GLX
    root 10813502  8519794   0 14:34:41  pts/0  0:00 /usr/lpp/X11/bin/xinit /usr/lpp/X11/bin/mwm -- :0 -vfb -force -x abx -x dbe -x GLX

Note: I hope  resolve avobe issue after doing this activity.