Session hang issueOracle 11g Listener not workingOracle - How can I find the session id of a shell script...
Why do we call complex numbers “numbers” but we don’t consider 2 vectors numbers?
Preparing as much as possible of a cake in advance
Do natural melee weapons (from racial traits) trigger Improved Divine Smite?
Where do you go through passport control when transiting through another Schengen airport on your way out of the Schengen area?
Can a Mimic (container form) actually hold loot?
Can a Mexican citizen living in US under DACA drive to Canada?
Naming Characters after Friends/Family
3.5% Interest Student Loan or use all of my savings on Tuition?
Can you run a ground wire from stove directly to ground pole in the ground
Practical reasons to have both a large police force and bounty hunting network?
How can friction do no work in case of pure rolling?
Does the US political system, in principle, allow for a no-party system?
Remove object from array based on array of some property of that object
How to write a chaotic neutral protagonist and prevent my readers from thinking they are evil?
Should I use HTTPS on a domain that will only be used for redirection?
What can I do if someone tampers with my SSH public key?
Paper published similar to PhD thesis
Should we avoid writing fiction about historical events without extensive research?
The Key to the Door
A bug in Excel? Conditional formatting for marking duplicates also highlights unique value
Align equations with text before one of them
How do we objectively assess if a dialogue sounds unnatural or cringy?
Named nets not connected in Eagle board design
Was it really inappropriate to write a pull request for the company I interviewed with?
Session hang issue
Oracle 11g Listener not workingOracle - How can I find the session id of a shell script (Linux)?How to find a session with a specific commandOracle connection suddenly refused on windows 8Can an active session in oracle be dead?Oracle 11.2.0.3 Service Name Mismatch issueCleanup of Oracle killed sessionMutual authentication via SSL Oracle 11gWhy my Oracle 12c database seems not to be started?TNS-12560: TNS:protocol adapter error
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♦ 7 mins 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♦ 7 mins 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♦ 7 mins 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♦ 7 mins 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