The solution is as follows:
1-from the command prompt, stop ISQLPLUS:
C: \> isqlplusctl stop
2-assuming that you install Oracle under C drive, run the following comands:
C: \> set ORACLE_HOME = c: \ oracle \ product \ 10.2.0 \ db_1
C: \> set java_home = % ORACLE_HOME % \ JDK
3-Change directory:
Cd % ORACLE_HOME % \ Solaris \ J2EE \ ISQLPLUS \ Application-deployments \ ISQLPLUS
4-Suppose you need to create a new user with user name 'yoyo 'and password 'ch51 *****', run the following command:
% Java_home % \ bin \ Java-djava. security. properties = % ORACLE_HOME % \ productname \ J2EE \ home \ config \ jazn. security. props-jar % ORACLE_HOME % \ productname \ J2EE \ home \ jazn. jar-user "iSQL * Plus DBA/admin"-Password welcome-adduser "iSQL * Plus dba" Yoyo ch51 *****
5-to check that adding this new user was successful, run the following command:
% Java_home % \ bin \ Java-djava. security. properties = % ORACLE_HOME % \ productname \ J2EE \ home \ config \ jazn. security. props-jar % ORACLE_HOME % \ productname \ J2EE \ home \ jazn. jar-user "iSQL * Plus DBA/admin"-Password welcome-listusers "iSQL * Plus dba"
Result:
Admin
Yoyo
6-to grant a user access to the webdba role from the command line, enter:
% Java_home % \ bin \ Java-djava. security. properties = % ORACLE_HOME % \ productname \ J2EE \ home \ config \ jazn. security. props-jar % ORACLE_HOME % \ productname \ J2EE \ home \ jazn. jar-user "iSQL * Plus DBA/admin"-Password welcome-grantrole webdba "iSQL * Plus dba" Yoyo
7-now, run start ISQLPLUS again and enjoy it:
Isqlplusctl start
8. access again: http: // hostname: 5560/isqlplus/DBA, and give the user name and password: Yoyo and ch51 ***** (all in lower case ), you can see the ISQLPLUS logon interface,
Then provide the user name: system, password: ch51 *****, connection ID: (description = (address_list = (address = (Protocol = TCP) (host = kcsqlbi) (Port = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl) with the permission sysdba, you can access it.