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

Thread: Catpatch.sql Error

  1. 01-19-2005, 04:23 PM #1
    srt
    srt is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 01-20-2005, 04:44 AM #2
    OracleDoc's Avatar
    OracleDoc
    OracleDoc is offline The Doc is in!
    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
    Reply With Quote Reply With Quote
  3. 01-20-2005, 09:59 AM #3
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    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"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width