problem/s logging into isql*plus as dba
Date: Fri, 15 Aug 2008 11:04:12 -0700 (PDT)
Message-ID: <00af131a-597a-4e0e-bc7f-5b5be1ec214c@a2g2000prm.googlegroups.com>
hello friends,
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 :
- 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 tried restarting the instance but that doesn't work either
please help
regards
Received on Fri Aug 15 2008 - 13:04:12 CDT