Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-2396

Karan KukrejaNov 15 2010 — edited Apr 6 2011
Hi all ,

Hope everyone had a good weekend.. :)



I got this alert in my alert mail :

opidcl aborting process unknown ospid (14605_1) due to error ORA-2396


and the trace file had the following details:

*********************************************************************
TNS-00505: Operation timed out
nt secondary err code: 145
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.xxx.xx)(PORT=xxxx))
opidcl aborting process unknown ospid (14605_1) due to error ORA-2396
Wed Dec 23 10:10:22 2009


***********************************************************************

Does it mean a user tried to connect and was unable to connect because ORA-2396 , which comes when "exceeded maximum idle time, please connect again"

- from http://ora-02396.ora-code.com/


and in the above error, what does this mean : opidcl aborting process unknown ospid (14605_1)

Comments

Satish Kandi
Oracle 8i is the product of Oracle corporation. No other company can provide the bug fixes/patches for the same (I don't know if there are any authorized distributors for Oracle patches).

Haven't you considered an upgrade as one of the easier options?
user11977557
Due to economic crisis, our company is planning to stay with oracle 8i with a few more years and planning to upgrade the whole environment to the latest environment.

Kindly help.
Satish Kandi
user11977557 wrote:
Due to economic crisis, our company is planning to stay with oracle 8i with a few more years and planning to upgrade the whole environment to the latest environment.

Kindly help.
I can't help except for the advice to get in touch with Oracle sales and support and work your way through.
Aman....
user11977557 wrote:
Due to economic crisis, our company is planning to stay with oracle 8i with a few more years and planning to upgrade the whole environment to the latest environment.

Kindly help.
Hmm if the economic crisis is the reason to stay with 8i, I am not sure that how you would end up paying an arm and leg for the support of an obsoleted product version? Do get in touch with Oracle sales and see if they can help you as Satish has mentioned.

Aman....
Hemant K Chitale
8.1.7 is under "Sustaining Support"

If you
a. Have the license for the software
AND
b. Have been paying support fees every year

you are entitled to patches that have already been released. However, Oracle will not work to create a new patch if your error-case is one for which they do not have a patch.

See http://www.oracle.com/us/support/policies/index.html
and the document "Oracle's Technical Support Policies" and the document (linked from the first) "Lifetime Support Policy".


Hemant K Chitale
user11977557
Hi All,
I am very grateful for all your responses.

We are planning in staying with Oracle 8i on platform AIX 5.3 TL 10. i do understand from your comments there is no company in the world other than oracle cooperation can provide correction patches for Oracle database.

We have been running this configuration from 2006 until now without any issue. I seek your point of view for a risk analysis, if we will continue to run the same configuration for 3 more years prior upgrading.


Thanks.
Nicolas Gasparotto
Bearing in mind that more you are waiting to upgrade, more difficult it will be. The direct upgrade to the latest Oracle version takes less and less in account the old version, forcing you to upgrade within "bridge" database(s) - intermediate step(s), making it more complicated, longer and risky. And that's not going to be better for your 8i version in 3 years time within the upcoming versions.

Nicolas.
EdStevens
user11977557 wrote:
Hi All,
I am very grateful for all your responses.

We are planning in staying with Oracle 8i on platform AIX 5.3 TL 10. i do understand from your comments there is no company in the world other than oracle cooperation can provide correction patches for Oracle database.

We have been running this configuration from 2006 until now without any issue. I seek your point of view for a risk analysis, if we will continue to run the same configuration for 3 more years prior upgrading.


Thanks.
Since 2006? Good grief! 8i was obsolete when you started.
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 4 2011
Added on Nov 15 2010
#general-database-discussions, #process
8 comments
43,018 views