-
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?
-
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.
-
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?
-
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?
-
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]
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|