Catpatch.sql Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Catpatch.sql Error

  1. #1
    Join Date
    Nov 2003
    Posts
    89

    Catpatch.sql Error

    Hi, I am implemting oracle wearhouse builder and when installing the runtime assistance I am getting an java error.
    java.sql.SQLException: ORA-01919: role 'JAVADEBUGPRIV' does not exist.

    I did a tar and they are tellingme to run the catpatch.sql file.
    I upgraded oracle from 8.17.0 to 8.1.7.4 and created the database.
    I do not see catpatch.sql file. I guess it is in 9i.
    Kindly help me out to figure out how can i go further.

    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    it's located in
    $ORACLE_HOME/rdbms/admin
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    catpatch is only available for 9i. You might try to run catalog.sql and catproc.sql (9i catpatch.sql runs the new patchset versions of catalog.sql and catproc.sql and calls the component patch scripts.)

    HTH
    Sanjay
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its 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