Most of the time, after installing Oracle10g, you can log on to the Windows Authentication Window popped up by kcsqlbi: 5560isqlplusdba. Even if you enter any account, you cannot log on.
Most of the time, after installing Oracle10g, log on to the Windows Authentication Window popped up by http: // kcsqlbi: 5560/isqlplus/dba, even if any account is entered, you cannot log on.
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.
