problem/s logging into isql*plus as dba
K Gaur
i have oracle 10g installed on my pc running on windows xp.
i tried to log into isql*plus as dba. i took the help provided at
sql*plus login page on how to login as dba. it instructs that
first you should start the jazn shell and the create a new user as :
1. enter jazn shell:
%JAVA_HOME%/bin/java -Djava.security.properties=%ORACLE_HOME%/oc4j/
j2ee/home/config/jazn.security.props -jar %ORACLE_HOME%/oc4j/j2ee/
home/
jazn.jar -user "iSQL*Plus DBA/admin" -password welcome -shell
here first i encountered the problem that the file jazn-data.xml in
the directory
-------- %ORACLE_HOME%/oc4j/j2ee/home/ contains no realm named
"iSQL*Plus DBA"
rather it contains realm "jazn.com"
then after some searching i found a jazn-data.xml file containing
realm "iSQL*Plus DBA" in directory ------------- $ORACLE_HOME/oc4j/
j2ee/isqlplus/application-deployments/isqlplus
so i replaced the file in the .....j2ee/home directory with file in
the .....application-deployments/isqlplus directory
since the http://localhost:5560/isqlplus/dba url demands
"Enter username and password for "iSQL*Plus DBA" at localhost:5560"
2. create new user
adduser "iSQL*Plus DBA" dbadmin pwd
3.grant dba role to new user
grantrole webDba "iSQL*Plus DBA" dbadmin
i followed all the steps and the jazn-data.xml reflected the changes
too
but when i tried to login with username/password as dbadmin/pwd the
login failed
i have also tried to login using admin/welcome but to no avail
i have tied restarting the instance but that doesn't work either
please help
regards
Palooka
palooka