The SSL external users conversion script has the following syntax:
$ORACLE_HOME/rdbms/bin/extusrupgrade --dbconnectstring database connect string --dbuser database user --dbuserpassword database user password [-a] [-l username1,username2,...] [-f filename] [-o] [-h]
The database connect string should be in the format hostname:port_no:sid, where hostname is the name of the host on which the database is running, port_no is the listener port number and sid is the system identifier for the database instance.
Use the -a option to convert all SSL-authenticated external users. Here is an example:
extusrupgrade --dbconnectstring mymachine:1521:11gR2 --dbuser system --dbuserpassword manager -a
Use the -l option to specify a comma-delimited list of users to be converted. For example:
extusrupgrade --dbconnectstring mymachine:1521:11gR2 --dbuser system --dbuserpassword manager -l user1,user2,user3
Use the -f option to specify a file that has the list of users to be converted. For example:
extusrupgrade --dbconnectstring mymachine:1521:11gR2 --dbuser system --dbuserpassword manager -f usernames.txt
There should be one user name in each line in the specified file. Here is a sample usernames.txt file:
user#1 user>2 user,3 user4 user5
You must use the -f option to convert users who have special characters (such as #) in their user names.
Note:
You can combine the -l and -f options in the same command. The script combines the list of users from both the -l and -f options. If you use the -a option along with the -l option and the -f option, then the -a option is ignored.
You can use the -o option to print a list of SSL-authenticated external users to the standard output device. The output lists the users you can convert using the extusrupgrade script. The -o option cannot be combined with any other option.
extusrupgrade --dbconnectstring mymachine:1521:11gR2 --dbuser system --dbuserpassword manager -o
A sample output for this could be:
user1 user2 user3
Tip:
You can redirect the command output to a file to get a list of users who can be converted. You can then edit the file and use it with the -f option.