Session hang issue
We have run a cron job for deleting daily archivelog. Due to this job there is one session hanging on specific procedure.
(ODSDEV.CC_AGENTS_EVENT_PROC)
I am going to change my question. We have stopped the cron job but still we face the same session hung issue on specified procedure.?
This is on Linux.
Please help us how to get rid of session hung issue.
Alert log Error:
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 -
Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 15-MAR-2018 04:41:44
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.21.224)(PORT=62044))
Thu Mar 15 05:27:45 2018
oracle linux session archive-log
asked Mar 15 '18 at 5:30
Rahman GurbazRahman Gurbaz
187
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
|
show 2 more comments
We have run a cron job for deleting daily archivelog. Due to this job there is one session hanging on specific procedure.
(ODSDEV.CC_AGENTS_EVENT_PROC)
I am going to change my question. We have stopped the cron job but still we face the same session hung issue on specified procedure.?
This is on Linux.
Please help us how to get rid of session hung issue.
Alert log Error:
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 -
Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 15-MAR-2018 04:41:44
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.21.224)(PORT=62044))
Thu Mar 15 05:27:45 2018
oracle linux session archive-log
asked Mar 15 '18 at 5:30
Rahman GurbazRahman Gurbaz
187
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Simply kill the session
– Husam Mohamed
Mar 15 '18 at 5:36
It is a temporary solution....I need permanent solution @Husam Mohammed
– Rahman Gurbaz
Mar 15 '18 at 5:44
I haven't had my coffee yet. Please be hold. Why are you not using RMAN to manage your archive log files?
– Michael Kutz
Mar 15 '18 at 10:40
we just need weakly backup.
– Rahman Gurbaz
Mar 15 '18 at 11:00
Since you only need weekly backups, add "delete obsolete archivelog all" to the end of your weekly RMAN backup script.
– Michael Kutz
Mar 15 '18 at 13:26
|
show 2 more comments
We have run a cron job for deleting daily archivelog. Due to this job there is one session hanging on specific procedure.
(ODSDEV.CC_AGENTS_EVENT_PROC)
I am going to change my question. We have stopped the cron job but still we face the same session hung issue on specified procedure.?
This is on Linux.
Please help us how to get rid of session hung issue.
Alert log Error:
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 -
Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 15-MAR-2018 04:41:44
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.21.224)(PORT=62044))
Thu Mar 15 05:27:45 2018
oracle linux session archive-log
asked Mar 15 '18 at 5:30
Rahman GurbazRahman Gurbaz
187
We have run a cron job for deleting daily archivelog. Due to this job there is one session hanging on specific procedure.
(ODSDEV.CC_AGENTS_EVENT_PROC)
I am going to change my question. We have stopped the cron job but still we face the same session hung issue on specified procedure.?
This is on Linux.
Please help us how to get rid of session hung issue.
Alert log Error:
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 -
Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 15-MAR-2018 04:41:44
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.21.224)(PORT=62044))
Thu Mar 15 05:27:45 2018
oracle linux session archive-log
oracle linux session archive-log
asked Mar 15 '18 at 5:30
Rahman GurbazRahman Gurbaz
187
asked Mar 15 '18 at 5:30
Rahman GurbazRahman Gurbaz
187
edited Mar 18 '18 at 5:38
Rahman Gurbaz
asked Mar 15 '18 at 5:30
Rahman GurbazRahman Gurbaz
187
asked Mar 15 '18 at 5:30
Rahman GurbazRahman Gurbaz
187
asked Mar 15 '18 at 5:30
Rahman GurbazRahman Gurbaz
187
187
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Simply kill the session
– Husam Mohamed
Mar 15 '18 at 5:36
It is a temporary solution....I need permanent solution @Husam Mohammed
– Rahman Gurbaz
Mar 15 '18 at 5:44
I haven't had my coffee yet. Please be hold. Why are you not using RMAN to manage your archive log files?
– Michael Kutz
Mar 15 '18 at 10:40
we just need weakly backup.
– Rahman Gurbaz
Mar 15 '18 at 11:00
Since you only need weekly backups, add "delete obsolete archivelog all" to the end of your weekly RMAN backup script.
– Michael Kutz
Mar 15 '18 at 13:26
|
show 2 more comments
Simply kill the session
– Husam Mohamed
Mar 15 '18 at 5:36
It is a temporary solution....I need permanent solution @Husam Mohammed
– Rahman Gurbaz
Mar 15 '18 at 5:44
I haven't had my coffee yet. Please be hold. Why are you not using RMAN to manage your archive log files?
– Michael Kutz
Mar 15 '18 at 10:40
we just need weakly backup.
– Rahman Gurbaz
Mar 15 '18 at 11:00
Since you only need weekly backups, add "delete obsolete archivelog all" to the end of your weekly RMAN backup script.
– Michael Kutz
Mar 15 '18 at 13:26
Simply kill the session
– Husam Mohamed
Mar 15 '18 at 5:36
Simply kill the session
– Husam Mohamed
Mar 15 '18 at 5:36
It is a temporary solution....I need permanent solution @Husam Mohammed
– Rahman Gurbaz
Mar 15 '18 at 5:44
It is a temporary solution....I need permanent solution @Husam Mohammed
– Rahman Gurbaz
Mar 15 '18 at 5:44
I haven't had my coffee yet. Please be hold. Why are you not using RMAN to manage your archive log files?
– Michael Kutz
Mar 15 '18 at 10:40
I haven't had my coffee yet. Please be hold. Why are you not using RMAN to manage your archive log files?
– Michael Kutz
Mar 15 '18 at 10:40
we just need weakly backup.
– Rahman Gurbaz
Mar 15 '18 at 11:00
we just need weakly backup.
– Rahman Gurbaz
Mar 15 '18 at 11:00
Since you only need weekly backups, add "delete obsolete archivelog all" to the end of your weekly RMAN backup script.
– Michael Kutz
Mar 15 '18 at 13:26
Since you only need weekly backups, add "delete obsolete archivelog all" to the end of your weekly RMAN backup script.
– Michael Kutz
Mar 15 '18 at 13:26
|
show 2 more comments
1 Answer
1
active
oldest
votes
OH yes I have find an issue:
This issue is due to network outages.
How i have find!
I have run the bellow query and find that a session is waiting for network.
Then i have forwarded this issue to network team
select * from V$SESSION_WAIT where sid =136;
136 53316| SQL*Net message from dblink driver| id |675562835| 0000000028444553 |#bytes| 1| 0000000000000001 | 0 |00| 2000153315| 7| Network| 0| 246255| WAITING |246254945393| -1| 0|
answered Mar 18 '18 at 10:58
Rahman GurbazRahman Gurbaz
187
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f200321%2fsession-hang-issue%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
OH yes I have find an issue:
This issue is due to network outages.
How i have find!
I have run the bellow query and find that a session is waiting for network.
Then i have forwarded this issue to network team
select * from V$SESSION_WAIT where sid =136;
136 53316| SQL*Net message from dblink driver| id |675562835| 0000000028444553 |#bytes| 1| 0000000000000001 | 0 |00| 2000153315| 7| Network| 0| 246255| WAITING |246254945393| -1| 0|
answered Mar 18 '18 at 10:58
Rahman GurbazRahman Gurbaz
187
add a comment |
OH yes I have find an issue:
This issue is due to network outages.
How i have find!
I have run the bellow query and find that a session is waiting for network.
Then i have forwarded this issue to network team
select * from V$SESSION_WAIT where sid =136;
136 53316| SQL*Net message from dblink driver| id |675562835| 0000000028444553 |#bytes| 1| 0000000000000001 | 0 |00| 2000153315| 7| Network| 0| 246255| WAITING |246254945393| -1| 0|
answered Mar 18 '18 at 10:58
Rahman GurbazRahman Gurbaz
187
add a comment |
OH yes I have find an issue:
This issue is due to network outages.
How i have find!
I have run the bellow query and find that a session is waiting for network.
Then i have forwarded this issue to network team
select * from V$SESSION_WAIT where sid =136;
136 53316| SQL*Net message from dblink driver| id |675562835| 0000000028444553 |#bytes| 1| 0000000000000001 | 0 |00| 2000153315| 7| Network| 0| 246255| WAITING |246254945393| -1| 0|
answered Mar 18 '18 at 10:58
Rahman GurbazRahman Gurbaz
187
OH yes I have find an issue:
This issue is due to network outages.
How i have find!
I have run the bellow query and find that a session is waiting for network.
Then i have forwarded this issue to network team
select * from V$SESSION_WAIT where sid =136;
136 53316| SQL*Net message from dblink driver| id |675562835| 0000000028444553 |#bytes| 1| 0000000000000001 | 0 |00| 2000153315| 7| Network| 0| 246255| WAITING |246254945393| -1| 0|
answered Mar 18 '18 at 10:58
Rahman GurbazRahman Gurbaz
187
answered Mar 18 '18 at 10:58
Rahman GurbazRahman Gurbaz
187
answered Mar 18 '18 at 10:58
Rahman GurbazRahman Gurbaz
187
answered Mar 18 '18 at 10:58
Rahman GurbazRahman Gurbaz
187
187
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f200321%2fsession-hang-issue%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Simply kill the session
– Husam Mohamed
Mar 15 '18 at 5:36
It is a temporary solution....I need permanent solution @Husam Mohammed
– Rahman Gurbaz
Mar 15 '18 at 5:44
I haven't had my coffee yet. Please be hold. Why are you not using RMAN to manage your archive log files?
– Michael Kutz
Mar 15 '18 at 10:40
we just need weakly backup.
– Rahman Gurbaz
Mar 15 '18 at 11:00
Since you only need weekly backups, add "delete obsolete archivelog all" to the end of your weekly RMAN backup script.
– Michael Kutz
Mar 15 '18 at 13:26