Configure ISQLPLUS for Oracle 10 GB

1. Set Environment Variables
1. Name = ORACLE_HOME value = D: \ oracle \ product \ 10.2.0 \ db_1
2. Name = java_home value = % ORACLE_HOME % \ JDK (java.exe in oraclecan be disabled)
3. Add % java_home % \ bin to change the PATH variable value. (In fact, 2 and 3 are Java environment variables)
2. Run cmd To Go To The DOS operation interface
1. Run the command: D :\> cd % ORACLE_HOME % \ productname \ J2EE \ ISQLPLUS \ Application-deployments \ ISQLPLUS
2. Go to D: \ oracle \ product \ 10.2.0 \ db_1 \ productname \ J2EE \ ISQLPLUS \ Application-deployments \ ISQLPLUS>
-- Executed command
Java-djava. Security. properties = % ORACLE_HOME % \ productname \ J2EE \ home \ config \ jazn. Security. Props
-Jar % ORACLE_HOME % \ Solaris \ J2EE \ home \ jazn. Jar
-User "iSQL * Plus DBA/admin"
-Password welcome
-Shell
3. Go to the jazn page
1. Create a user
Jazn:> adduser "iSQL * Plus dba" Username Password
2. User List
Jazn:> listusers "iSQL * Plus dba" (listusers)
3. Grant webdba Permissions
Jazn:> grantrole webdba "iSQL * Plus dba" username
4. delete a user
Jazn:> remuser "iSQL * Plus dba" username
5. revoke the webdba permission
Jazn:> revokerole webdba "iSQL * Plus dba" username
6. Change the password
Jazn:> setpasswd "iSQL * Plus dba" username old_password new_password
4. Restart the iSQLPLus Service
(Oracle 10 Gb does not need to be restarted)