The listener was went down at when load was high and it didn't turn on automatically (my environment is RAC)
TNS-12518: TNS:listener could not hand off client connection
TNS-12571: TNS:packet writer failure
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
Linux Error: 104: Connection reset by peer
[oracle@myoracle admin]$ cat /var/log/messages
cat: /var/log/messages: Permission denied
as per “Oracle” issue seems to be due to “Extensive paging/swapping activity is a clear indication that the sytem is running out of the physical memory” and solutions offered as below
1. Increase the physical memory of the system or
[oracle@myoracle OPatch]$ free
total used free shared buffers cached
Mem: 32960108 31415136 1544972 0 870980 21807352
-/+ buffers/cache: 8736804 24223304
Swap: 16777200 366380 16410820
2. Apply the Patch 6139856 for unpublished Bug 6139856 if available for your platform or
[oracle@myoracle OPatch]$ ./opatch lsinventory | grep 6139856
[oracle@myoracle OPatch]$
3. Configure Hugepages on the OS. Ref : Note 361323.1
[oracle@myoracle OPatch]$ grep Hugepagesize /proc/meminfo
Hugepagesize: 2048 kB
Ref: TNS Listener Crash with Core dump [ID 549932.1]
HugePages on Linux: What It Is... and What It Is Not... [ID 361323.1]
Search This Blog
Subscribe to:
Post Comments (Atom)
Transportable tablespace refresh
1.check tablespace for the user which need to refresh ------------------------------------------------------------------- SQL> select ...
-
Issue - When recovering database until SCN, recovery failed with error RMAN-03002 and RMAN-06556 using channel ORA_DISK_8 RMAN-00571: ...
-
Solution: a. Rename the data file so that it does not have spaces in it. b. FTP the file to a directory on your server without spaces in t...
-
Issue - Fatal NI connect error 12514, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=abc.xyz.com)(PORT=9501))(CONNECT_DATA=(S...
No comments:
Post a Comment