22
Jan
07

Oracle 10.2.0.2 sucks on windows

Ok. I hate to say that because I prefer Oracle more than others.

But Oracle 10.2.0.2 has a lot of memory leaks which won’t show until you build it on your live Server. The problem is that to starting observing the problem, the database needs to get some workload so it won’t show on a test or train server.

The reason is that there are bugs into this particular release that will threaten your critical systems.

The symptoms where we installed it are as follow:

1) Inability for new users to login to Oracle after a while because new sessions are not properly closed.

This problem can be solved with a tool such as currport. You should be able to see that you got a lot of sessions without a session ID. Oracle is not even able to kill them. Currports fortunately allows us to look into the sessions at OS level and kill the Close_wait sessions.

There are a few actions to take on the server which involve addind new keys in the registry.

2) Impossibility to perform a proper shutdown  without Oracle shutting down the service.

3) Oracle shutting down without warning

After looking into the problem and searching on Metalink, I found a list of bug full of memory leaks.

These issues appeared only on this particular release. This means that if you are on Oracle 10.2.0.1, you should skip this version and upgrade to Oracle 10.2.0.3.

Oracle 10.2.0.3 get one problem with bind variable but it’s minor compared to the bugs of 10.2.0.2.

Advertisements

13 Responses to “Oracle 10.2.0.2 sucks on windows”


  1. 1 Jean-Pol Landrain
    February 13, 2007 at 1:34 pm

    The problem with the bind variables in 10.2.0.3 can be solved by using the (hidden) setting ALTER SESSION SET “_optim_peek_user_binds”=FALSE
    For example, you can issue this from an after logon trigger or, if you’re using a connection pool, it’s often possible to specify an sql statement that is executed each time a connection is created and added to the pool.

  2. February 15, 2007 at 9:04 am

    Thanks a lot for your answer.
    I think I will need this information sooner than later.

  3. February 15, 2007 at 9:17 am

    Well…
    After a bit of looking around on the web (and a very short discussion with a collegue), I think this is not a good idea.

    This parameter is related to the optimizer and should not be manipulated unless there is very good reasons to do so.

  4. 4 Jean-Pol Landrain
    August 14, 2007 at 1:06 pm

    Yes, this parameter is related to the optimizer.
    When you use it, it tells the optimizer to not take into account the value of the bind variables to calculate the optimization plan. If you don’t set it, the optimizer calculates the plan on the first request, taking into account the value of the bind variables, and doesn’t recalculate it for the subsequent similar requests (it always reuses the same plan). It’s fine if you do a lot of requests with the same kind of values, but it kills the performance when you use a large set of different values for your queries.
    I have done a lot of tests with many different versions of Oracle. Having this parameter set (to FALSE) was the default behavious until 10.2.0.3, and I don’t know why Oracle has changed that because it gives a lot of surprises when you migrate your mission critical applications to this version. Another thing that is strange with it: the behavious with this parameter is linked to the version of the driver, and not to the version of the database.

  5. August 16, 2007 at 7:06 am

    hi Jean Pol.

    Thanks for these very valuable informations.
    I think it will really help the people passing by.

    Nico

  6. 6 KENTOY
    August 17, 2007 at 5:06 am

    Hi Nico,

    Are by any chance running a Oracle-JDE EnterpriseOne 8.12 system on this particular database instance?…

    KEN

  7. August 17, 2007 at 7:53 am

    Hi Ken.

    Nothing like that on this instance…

    Sorry : /

  8. 8 Mahesh Pimparikar
    January 15, 2008 at 11:30 am

    Hi Nico,

    Currently I am having 9.2.0.8.0 in D drive.
    Is it possible to install 10g in some different drive.
    Will it create any problem ?

    Thanks
    Mahesh

  9. 9 Mahesh
    March 16, 2008 at 11:09 am

    Hi Nico,

    I am planning to practice 10g at home.
    OS is windows XP professional.
    When I searched download on OTN,
    it is showing me
    Oracle Database 10g Release 2 (10.2.0.3) for Microsoft Windows Vista
    Will it be OK for XP Prof. ?
    Or do you suggest any other download ?

    Thanks
    Mahesh

  10. March 17, 2008 at 8:47 am

    Hi.

    Vista is really a different engine than say, windows 2000 and XP.
    I would suggest you to find another release of Oracle.

    Ultimately.;; Just try! You never know. your comment would be valuable after you tried 😉

    enjoy doing it.

    Nico

  11. 11 shank
    October 30, 2008 at 2:16 pm

    Hi,
    i have one problem,i have upgraded oracle client 10.2.0.1 to 10.2.0.3,if i try to connect using ODBC,am getting the following error
    ORA-12514:TNS:listener does not currently know of service requested in connect descriptor

    i checked my tns entries also,i hope that is correct.
    could u plz tell me the solution…
    Thank u

  12. February 8, 2013 at 1:09 pm

    I absolutely am in awe of this post. totally gonna have
    to put this on my blogroll.

  13. August 9, 2014 at 10:27 pm

    Wow, that’s what I was seeking for, what a data! present here at this blog, thanks
    admin of this web page.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: