No question at this time
DBA Top 10
1 M. Cadot 23300
2 A. Kavsek 15200
3 M. Hidayathullah ... 11000
4 B. Vroman 8300
5 P. Wisse 6000
6 T. Boles 5000
7 J. Schnackenberg 3800
8 G. Lambregts 2200
8 P. Knibbs 2200
10 K. Van Nieuwenhov... 2100
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48039
Total active users1770
Act. users last 24h10
Act. users last hour1
Registered user hits last week205
Registered user hits last month1405
Go up

network adapter issues
Next thread: IMPDP seems to be stuck
Prev thread: Need to download 10.2.0.1

Message Score Author Date
Hi Guys Our application can't connect to the d...... Tso P Jul 10, 2017, 15:24
Hi Tso, I would say a network issue. You fur...... Philip Wisse Jul 10, 2017, 16:06
Thanks Phillip I have restarted the databases/i...... Tso P Jul 11, 2017, 10:53
The other thing that I have observed is that I hav...... Tso P Jul 11, 2017, 11:17
Hi Tso, If it works don't touch it and walk awa...... Philip Wisse Jul 11, 2017, 11:56
ps -ef | grep -i DBW | grep -v $$ | grep -v grep...... Tso P Jul 11, 2017, 13:39
Hi Tso, Is this issue resolved?... raghavendra rao yella Jul 17, 2017, 19:59

Follow up by mail Click here


Subject: network adapter issues
Author: Tso P, South Africa
Date: Jul 10, 2017, 15:24, 72 days ago
Os info: solaris 11
Oracle info: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Message: Hi Guys

Our application can't connect to the database, when I checked the errors I get the following:

Internal Exception: java.sql.SQLRecoverableException: IO Error: Socket read timed out

Upon investigation I realised that when I try tnsping it takes time to respond.

I have restarted the listener but immediately after that I did a tnsping then I get 220m,3310m,...,9580m,etc

The load averages: 42.4, 24.9, 22.9 which is way high.

Is there any services that I can restart to fix this issue.

What might be the issue here?

Please help!!!

Thanks in advance!!!
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: network adapter issues
Author: Philip Wisse, Netherlands
Date: Jul 10, 2017, 16:06, 72 days ago
Message: Hi Tso,

I would say a network issue.

You further test with the ping command.
---
Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: network adapter issues
Author: Tso P, South Africa
Date: Jul 11, 2017, 10:53, 71 days ago
Message: Thanks Phillip

I have restarted the databases/instances and now things look normal.

But I still worried as when I start the sqlplus it just hangs a few minutes....

>sqlplus "/as sysdba";

SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 11 10:52:05 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.


What might be the cause here...

Thanks in advance...
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: network adapter issues
Author: Tso P, South Africa
Date: Jul 11, 2017, 11:17, 71 days ago
Message: The other thing that I have observed is that I have another instance that run on 11.2.0.4. Immediately I have started the instance the load average skyrocketed to 5.32.

And when I start that instance after . oraenv the sqlplus used of 12c.

Like :

>. oraenv
ORACLE_SID = [orcl] ? orcl
The Oracle base remains unchanged with value /app/oracle

ohidevlz1*-/export/home/oracle
>sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 11 11:14:39 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

SQL> conn /as sysdba
Connected to an idle instance.
SQL>

But this is the 11g instance should I be concerned about this?

Thanks in advance...
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: network adapter issues
Author: Philip Wisse, Netherlands
Date: Jul 11, 2017, 11:56, 71 days ago
Message: Hi Tso,

If it works don't touch it and walk away quietly.

ps -ef | grep -i DBW | grep -v $$ | grep -v grep

HTH, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: network adapter issues
Author: Tso P, South Africa
Date: Jul 11, 2017, 13:39, 71 days ago
Message:
ps -ef | grep -i DBW | grep -v $$ | grep -v grep


oracle 28565 29707 0 10:17:41 ? 0:06 ora_dbw0_dbone1
oracle 17688 29707 0 Mar 28 ? 219:55 ora_dbw1_ohircu
oracle 17686 29707 0 Mar 28 ? 239:35 ora_dbw0_ohircu
oracle 16482 29707 0 11:20:10 ? 0:04 ora_dbw0_dbone2
oracle 2497 29707 0 10:19:28 ? 0:04 ora_dbw0_dbone3
oracle 10472 29707 0 10:24:41 ? 0:04 ora_dbw0_dbone4


Thanks
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: network adapter issues
Author: raghavendra rao yella, United States
Date: Jul 17, 2017, 19:59, 65 days ago
Message: Hi Tso,

Is this issue resolved?
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here