| Hung session between SOLARISand OS/390 8.1.7 Instances [message #113794] |
Wed, 19 December 2001 10:03  |
Colin Pitka
Messages: 3
Registered: December 2001
|
Junior Member |
|
|
Hi,
We recently upgraded our Os/390 Oracle instances to Version 8.1.7.2.50 (From version 8.1.5.1.1), and applied the lated bug fix. Our SOLARIS Oracle version is 8.1.7.1.0.
After upgrading the OS/390 database, we have distributed process that hang periodically when going through DB links from SOLARIS to OS/390.
Hase anyone elese seen this? Any ideas?
|
|
|
|
| Re: Hung session between SOLARISand OS/390 8.1.7 Instances [message #113795 is a reply to message #113794] |
Wed, 19 December 2001 23:23  |
paul mansfield
Messages: 35
Registered: January 2001
|
Member |
|
|
Colin,
we've had a number of NET8 problems even at 8.1.7.2. not exactly the same as yours but sometimes batch jobs have hung when using a remote database. When we look at the log we'll generally see there has been some sort of abend in NET8. Recycling NET8 always solves the problem. There are a number of new patches out whcih may solve this.
One situation which we had quite regularly was when we were using the NET8 link to export and then killed the export we subsequently had unpredictable results from NET8. I'm just applying a patch for bug2131936 which will hopefully resolve all our NET8 issues!!
|
|
|
|
| Re: Hung session between SOLARISand OS/390 8.1.7 Instances [message #113797 is a reply to message #113795] |
Thu, 20 December 2001 05:18 |
Colin Pitka
Messages: 3
Registered: December 2001
|
Junior Member |
|
|
Paul,
We have applied patch for bug2131936 and the latest patch for bug2139026 (I think it was released last week) and we still have the intermittent hanging issue with our distributed databases.
We also have some strange errors in the NET8 that we will investigate.
Are your hanging sessions running PL/SQL that access remote tables?
Have you logged a TAR with this hanging issue with OS/380 Oracle support? When I logged it with them they were acting like they haven't heard of it before ... just curious.
Thanks,Colin
|
|
|
|
| Re: Hung session between SOLARISand OS/390 8.1.7 Instances [message #113798 is a reply to message #113797] |
Fri, 21 December 2001 01:43 |
paul mansfield
Messages: 35
Registered: January 2001
|
Member |
|
|
Colin,
we've had a few problems in this area. Our hanging jobs are generally COBOL batch jobs but I'm not altogether sure what generates the hang as a number of other activities (such as exports) are run against remote databases. We've raised a number of tars - I'm currently applying a fix for b2131936. We don't get the problems that often - perhaps once every week or two but then, all our major production stuff is run on the mainframe anyway - its just our test systems on AIX. To be honest, NET8 with 8.1.7 has been very flaky and not very well tested, its needed quite a number of patches.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
