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 byThe 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
I’m Oracle Certified Professional with 12+ years of experience managing UNIX- based Oracle Databases. As a working IT professional, I have experience in a wide range of mission critical technologies, specializing in database administration best practices for backup and recovery. I have hands-on experience with real-world Production environments and have risen in the ranks from a developer to a managing DBA.
Monday, 17 September 2018
ORA-12152 "Unable To Send Break Message" on Connection
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.
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.
Subscribe to:
Posts (Atom)