Oracle Database 11.2.0.3
Red Hat Enterprise Linux Server release 5.8 (Tikanga)
Hi Team,
we are experiencing latency issues when connecting to DB
I have checked the awr report. Please find below findings:
1. Elapsed time > DB time (load is high on DB)
2. The DB CPU and SQL net message using db link is high
Is it network related or should I increase CPU cores?
From alert log:
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=imis)(CID=(PROGRAM=oracle)(HOST=RHIS-GC-0813-2.MTG.local)(USER=DefaultAppPool)))(ADDRESS=(PROTOCOL=TCP)(HOST=10.224.1.46)(PORT=1521)))
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
Time: 21-JUN-2018 05:34:40
Tracing not turned on.
Tns error struct:
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 111
nt OS err code: 0
***********************************************************************
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=imis)(CID=(PROGRAM=oracle)(HOST=RHIS-GC-0813-2.MTG.local)(USER=DefaultAppPool)))(ADDRESS=(PROTOCOL=TCP)(HOST=10.224.1.46)(PORT=1521)))
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
Time: 21-JUN-2018 05:34:40
Tracing not turned on.
Tns error struct:
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 111
nt OS err code: 0
Regards,
Joe