Re: ### => Help PLEASE ! Repository Designer migration to 6i ####

From: Richard Spee <rhpspee_at_wxs.nl>
Date: Wed, 12 Jun 2002 22:10:49 +0200
Message-ID: <ae8aa3$fei$1_at_reader07.wxs.nl>


Richard.

Read the oracle designer installation guide. Is says that the script you are looking for is generated from another script CKGENUSR.SQL.

(Extract from installation guide)
Step 12 - Migration of subordinate users This step migrates subordinate users from a release 2.1.2 or 6.0 repository to a release 6i repository. The procedure grants the necessary set of system and repository privileges to the subordinate users in the new repository.

This step uses the following SQL scripts: Script Notes

      CKGENUSR.SQL Located in Oracle_home\REPADM61\UTL directory. This script generates the migration script called MIGRATE_REPOS_USERS.SQL to the working directory.

      MIGRATE_REPOS_USERS.SQL When executed, this script creates Oracle database users on the target database (where the release 6i repository resides) with the same usernames and privileges as those from the source database (where the release 2.1.2 or 6.0 repository resides). It also creates a log file called MIGRATE_REPOS_USERS.LOG in the working directory.

      Note: Migrated subordinate users are given the default password "changeme".
      CKGENPRV.SQL Located in Oracle_home\REPADM61\UTL directory. This script generates the
migration script called MIGRATE_REPOS_PRIVS.SQL to the working directory.
      MIGRATE_REPOS_PRIVS.SQL When executed, this script creates repository users with default
repository privileges in the release 6i repository. Also creates a log file called MIGRATE_REPOS_PRIVS.LOG in the working directory.

Caution: Do not make changes to the scripts because such changes will not be supported. If in doubt, contact your Oracle Support Representative for assistance.

"Richard" <rheras_at_tid.es> wrote in message news:3D071EE3.3040806_at_tid.es...
> Hi everybody,
>
> I'd like to know where can I find the script 'migrate_repos_privs.sql'.
> The propose of this script is to migrato users from the old repository
> version to 6i.
>
> I start with repository version 6 and I try to execute this script. The
> source of this script try to call 'jr_sys_privs.ins' package internally
> but it doesn't exist in old repository. The result obviously is an error
> 'pl/sql called not found'.
>
> This is the fouth step (4/5) in the tutorial instructions. Next I'm
> going to push the 'migrate repository' button in the tool to complete
> the migrate process.
>
> Thanks. (Please, send me copy of your answers to: rheras_at_tid.es )
>
> Best regards:
> Richard.
>
Received on Wed Jun 12 2002 - 22:10:49 CEST

Original text of this message