dbTalk Databases Forums  

problem/s logging into isql*plus as dba

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss problem/s logging into isql*plus as dba in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
K Gaur
 
Posts: n/a

Default problem/s logging into isql*plus as dba - 08-15-2008 , 01:04 PM






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 tried restarting the instance but that doesn't work either


please help
regards

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.