Oracle Database Advanced Security 10g Release 1, Administrator'S Manual

Page: 471 / 518

User Migration Utility Usage Examples
Using the User Migration Utility G-25
Migrating Users Using the PARFILE, USERSFILE, and LOGFILE Parameters
It is possible to enter user information and User Migration Utility parameters into a
text file and pass the information and parameters to the utility using the
PARFILE
and
USERSFILE
parameters. The
LOGFILE
parameter sets the directory path for
the log file where details about the migration for each user are written.
The
PARFILE
parameter tells the utility where a text file is located that contains the
parameters for a bulk user migration. The
USERSFILE
parameter works like the
PARFILE
parameter, except it contains database users instead of parameters. The
parameters and users lists contain one parameter or user for each line. The
LOGFILE
parameter tells the utility where to write the system events that occur
during a user migration, such as errors. Use the
USERSFILE
parameter during
phase one of the migration process. The
PARFILE
and
LOGFILE
parameters can be
used in both phases.
Example G–4 shows the syntax for a typical parameter text file to migrate users
scott1
,
scott2
, and all external database users, while retaining their old
schemas, to the directory at
c=Users, c=us
. In this example a log of migration
events is written to the file
errorfile1
in the directory where the utility is run. If
another location is desired, then include the path with the file name.
Example G–4 Parameter Text File (
par.txt
) to Use with the PARFILE Parameter
DBLOCATION=machine1:1521:ora_sid
DBADMIN=system:manager
USERS=ALL_EXTERNAL:LIST:FILE
USERSLIST=scott1:scott2
USERSFILE=usrs.txt
DIRLOCATION=machine2:636
CONTEXT="c=Users, c=us"
ENTADMIN="cn=janeadmin":welcome
LOGFILE=errorfile1
Example G–5 shows the syntax for a typical users list text file.
Example G–5 Users List Text File (
usrs.txt
) to Use with the USERSFILE Parameter
user1
user2
user3
To execute phase one of the migration process with these parameters and users list
text files, use the syntax shown in
Example G–6 .