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: ...
-
Issue - We are not able to migrate the concurrent programs from one to another environment using FNDLOAD UPLOAD. i.e. from DEV to PROD...
-
FNDLOAD - Uploading from the data file XXB_CONC.ldt The file XXB_CONC.ldt could not be opened for reading Issue - [applmgr@xxora-app UPLOAD...
No comments:
Post a Comment