SQL*Plus doesn't run after patching OUI to vers 2.2.0.18
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: SQL*Plus doesn't run after patching OUI to vers 2.2.0.18

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    SQL*Plus doesn't run after patching OUI to vers 2.2.0.18

    I have a new install of Ora 9.2.0.0 on an Win2K server.
    I did not create a default DB with the installation.

    I want to patch to v9.2.0.3 but to do so I have to patch the Universal Installer to 2.2.1.18 from 2.2.1.12.
    I unzipped the OUI patchset .jar file in a new folder that I created under the bin folder. e.g. oracle/ora92/bin/OUIpatch ... and ran the patch from there.
    It completed successfully and the OUI now shows as patched to v.2.2.1.18

    However, when I try and invoke SQL*Plus I get an error message:


    "The dynamic link library oraclient9.dll could not be found in the patch specified."

    It then lists a series of paths INCLUDING "oracle/ora92/bin/OUIpatch" but not "oracle/ora92/bin", where, in fact, the .dll actually is.

    Have I run the patch from the wrong location?

    If so - what do I do to unravel this?

  2. #2
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Can I add that the SQL*Plus executable is now in the OUIpatch folder and not the Bin folder?

    What has happened?

  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    And if I copy the SQL*Plus exe file back to the BIN folder it runs fine.

    But why has the OUI patch process moved these files? And what else has it moved?

    I'm of the opinion that I should uninstall Oracle completely, & re-install 9i from scratch.

    But what's the best procedure for patching to 9.2.0.3 given that I followed the instructions in the first place? (Or thought I did)

  4. #4
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Well just in case anyone was wondering ...

    The OUI upgrade must be run OUTSIDE the Oracle Home. The docs (README etc) that come with the patch (e.g. note with patch 2878462) make no mention of this but note 234944.1 does (apparantly).

    The note says that the installer may hang if run inside Ora Home but I'm certain if I run it outside the Ora Home it will not affect the installed files under the BIN directory.

    So its uninstall and reinstall time folks. You live and learn.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    But the big question is, Did you have to reboot?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    i wonder why does one directly jump to uninstall?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #7
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by marist89
    But the big question is, Did you have to reboot?
    The needle's stuck again When is the upgrade to marist90 due? (I'm surprised marist89 is still supported )

  8. #8
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    That's it lads - stick the boot in!
    'Snot my fault! I suggested Unix way back when...

  9. #9
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925


    The easy take would be to reinstall 9i, patch the installer and then patch the oracle.

    I know it is painful

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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