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

Thread: HELP, URGENT

  1. #1
    Join Date
    Nov 2000
    Posts
    245

    To create packages for replication, I run catrep.sql from svrmgrl/connect internal, the result is all object (package) valid for owner SYS, but invalid for system. why?

    what I missing or I should run from differenct account?

  2. #2
    Join Date
    Jan 2001
    Posts
    71
    You should create user repadmin on all replicated site and use this user to create and manager replication. Refer to Oracle instruction about Replication and Replication Manager.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    A package can only be valid or invalid for all users. It can't be valid for one user and invalid for another. There might be some public synonyms missing for some objects, try to address them in full notation with owner name in front of them (like SYS.GLOBAL_NAME).
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Nov 2000
    Posts
    245
    after I drop all invalid system packages, it works.
    I don't understand why create 2 pair each, one owner is sys
    2nd one is system and system package is invalid.

    question is who should own those package and where/who I should run from?

    here is what I did the incorrect result:

    cd $ORACLE_HOME/rdbms/admin
    svrmgrl
    > connect internal
    > @catrep
    > exit

    I did twice, one log in as oracle, another one is regular user. but I thought as long as oracle_sid is correct, I don't see the difference.

    any idea?


  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Its always better to have a look at the script comments before running it. Who should run will bementioned over there.

    Otherwise make a script that should be run after each and every new database creation per your enterprise standards. Thats how I do. See this script

    <font face=courier>
    apps% more crpqst3.sql
    /* Step3 */

    spool crpqst3.log
    connect system/manager

    @?/rdbms/admin/utlxplan.sql
    @?/rdbms/admin/utlchain.sql
    @?/rdbms/admin/utllockt.sql
    @?/rdbms/admin/utldtree.sql
    @?/rdbms/admin/pupbld.sql
    @?/rdbms/admin/catdbsyn.sql

    disconnect;
    connect sys/change_on_install

    @?/rdbms/admin/catblock.sql
    @?/rdbms/admin/catio.sql
    @?/rdbms/admin/dbmssql.sql
    @?/rdbms/admin/dbmsutil.sql
    REM @?/rdbms/admin/dbmsalrt.sql
    REM @?/rdbms/admin/dbmslob.sql
    REM @?/rdbms/admin/dbmsjob.sql
    REM @?/rdbms/admin/dbmspipe.sql
    REM @?/rdbms/admin/dbmssnap.sql

    disconnect;
    spool off
    </font>

    [Edited by sreddy on 02-05-2001 at 10:19 AM]

  6. #6
    Join Date
    Nov 2000
    Posts
    26

    replication problem

    hi,
    i too encountered this very probm. myself,
    what u have done for dropping system's packages is itself correct, the packages for replication are owned by sys only,. system does not have anything to do in that area, this seems to be a bug in the catrep.sql script(version) itself,
    do not worry about the user repadmin now. , this user will be required when u are actually setting up uer replication sites and not for the initial replication support, hope my answer is not too late
    bye and cheers
    soren

  7. #7
    Join Date
    Nov 2000
    Posts
    245
    thanks for your kindly answers.

    I agree the problem solved, I admit my mistake is I should read the script comments before I do anything, indeed there is a line in catrep.sql:

    Rem Must be run while connected to sys or internal

    thanks again.

    Jim

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