DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Patch 9.2.0.6

  1. #1
    Join Date
    Nov 2004
    Posts
    8

    Unhappy Patch 9.2.0.6

    I tried to install the 9.2.0.6 patch on Windows.
    Lots of error in the catpatch.sql and the sql called.
    Does anybody succeed to install it ?

    Thanks

    www.lochert.fr

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334

    Re: Patch 9.2.0.6

    Originally posted by plochert
    I tried to install the 9.2.0.6 patch on Windows.
    Lots of error in the catpatch.sql and the sql called.
    Does anybody succeed to install it ?

    Thanks

    www.lochert.fr
    Yes - what kind of errors are you getting?

  3. #3
    Join Date
    Oct 2003
    Posts
    312
    what error did you get??? rerun catpatch.sql and spool the result to the file so we can look at it

  4. #4
    Join Date
    Nov 2004
    Posts
    8
    Many "unable to open file ..."

    And

    ERROR at line 1:
    ORA-03113: end-of-file on communication channel


    BEGIN
    *
    ERROR at line 1:
    ORA-03114: not connected to ORACLE


    I tried to check the file but there are too many errors

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Originally posted by plochert
    Many "unable to open file ..."

    And

    ERROR at line 1:
    ORA-03113: end-of-file on communication channel


    BEGIN
    *
    ERROR at line 1:
    ORA-03114: not connected to ORACLE


    I tried to check the file but there are too many errors
    did you do all the pre-requisites and set the shared pool size and java pool size?

  6. #6
    Join Date
    Nov 2004
    Posts
    8
    Yes I did all except for shared_pool_size and java_pool_size : do I really need to set them to 150Mb ?

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Originally posted by plochert
    Yes I did all except for shared_pool_size and java_pool_size : do I really need to set them to 150Mb ?
    yep - if you didnt need to it, well - it wouldn't tell you to do it. Always follow the instructions

    let us know if it works once you have changed them

  8. #8
    Join Date
    Nov 2004
    Posts
    8
    OK I try tomorrow morning (6pm in France) with these values and I tell how the process is
    Thanks

  9. #9
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    this is not rocket science, aside from a couple of alter sessions all that catpatch does is

    @@utlil.sql
    @@catalog.sql
    @@catproc.sql

    Can you run those scripts?
    I'm stmontgo and I approve of this message

  10. #10
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    have u opened the db in migrate mode? (startup migrate)
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width