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 :

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

K Gaur wrote:
> 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 :
>
> 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
Instructions are in the SQLPlus guide.

palooka