+ Reply to Thread
Results 1 to 2 of 2

problem/s logging into isql*plus as dba

  1. problem/s logging into isql*plus as dba

    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

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

    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

+ Reply to Thread