Re: problem/s logging into isql*plus as dba

From: Palooka <nobody_at_nowhere.com>
Date: Sat, 16 Aug 2008 21:20:59 +0100
Message-ID: <KEGpk.1747$5Y1.1358@newsfe28.ams2>


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 Received on Sat Aug 16 2008 - 15:20:59 CDT

Original text of this message