Home » Other » Client Tools » sysdba access from Isqlplus (Oracle 10g, Windows XP)
sysdba access from Isqlplus [message #385230] Sun, 08 February 2009 01:59 Go to next message
rumman
Messages: 48
Registered: June 2007
Location: Bangladesh
Member
Hi,

I used the following command :
-------------------------------------------------
D:\oracle\product\10.1.0\Db_2\jdk\bin\java -Djava.security.properties=D:\oracle\product\10.1.0\Db_2\sqlplus\admin\iplus\provider -jar D:\oracle\product\10.1.0\Db_2\oc4j\j2ee\home\jazn.jar -user "iSQL*Plus DBA/admin" -password welcome -shell
--------------------------------------------------------

Output as follows:

--------------------------------------------
oracle.security.jazn.JAZNRuntimeException: Configuration file "config\jazn.xml" does not exist. Check your JAAS configuration settings.
at oracle.security.jazn.JAZNConfig.getJAZNProperties(Unknown Source)
... ... ...
Realm [iSQL*Plus DBA] does not exist in system.
-----------------------------------------------

Could anybody please say what may be the reason for this error?
Re: sysdba access from Isqlplus [message #385231 is a reply to message #385230] Sun, 08 February 2009 02:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Could anybody please say what may be the reason for this error?

Quote:
Configuration file "config\jazn.xml" does not exist. Check your JAAS configuration settings.

Regads
Michel
Re: sysdba access from Isqlplus [message #385233 is a reply to message #385231] Sun, 08 February 2009 02:37 Go to previous messageGo to next message
rumman
Messages: 48
Registered: June 2007
Location: Bangladesh
Member
I understood that. But how could I solve it?
Re: sysdba access from Isqlplus [message #385234 is a reply to message #385233] Sun, 08 February 2009 02:45 Go to previous messageGo to next message
rumman
Messages: 48
Registered: June 2007
Location: Bangladesh
Member
I solved it.
Re: sysdba access from Isqlplus [message #385238 is a reply to message #385234] Sun, 08 February 2009 03:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How?

Regards
Michel
Re: sysdba access from Isqlplus [message #386084 is a reply to message #385234] Thu, 12 February 2009 09:44 Go to previous messageGo to next message
shekharnegi12
Messages: 52
Registered: October 2008
Member
Rumman,

If you don't mind can you please let me know how did you solve the issue.

Cheers,
SN
Re: sysdba access from Isqlplus [message #386087 is a reply to message #386084] Thu, 12 February 2009 10:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But he doesn't want to share his solution, he just want us to help him and take without giving anything.

Regards
Michel
Re: sysdba access from Isqlplus [message #386368 is a reply to message #385230] Sat, 14 February 2009 00:56 Go to previous messageGo to next message
rumman
Messages: 48
Registered: June 2007
Location: Bangladesh
Member
Hi all,

Sorry I was not in touch.

I removed the parameters( -user "iSQL*Plus DBA/admin" -password welcome ) from the command and used the following:

D:\oracle\product\10.1.0\Db_2\jdk\bin\java -Djava.security.properties=D:\oracle\product\10.1.0\Db_2\sqlplus\admin\iplus\provider -jar D:\oracle\product\10.1.0\Db_2\oc4j\j2ee\home\jazn.jar -shell

This took me to the jazn shell. Then I created iSQL*Plus DBA realm,
user admin with password welcome. Then I could connect with the username and password to jazn shell.

But I need to create roles and others I suspect.

I think this is not a good solution.
I am looking for other solutions now.
Re: sysdba access from Isqlplus [message #462133 is a reply to message #385230] Tue, 22 June 2010 21:55 Go to previous message
infotechw3
Messages: 7
Registered: June 2010
Location: Tsingdao
Junior Member
Hi, I have the same problem, found a solution:

you can execute "java -Djava.security.properties=D:/oracle/product/10.2.0/db_1/oc4j/j2ee/home/config/jazn.security.props -jar D:/oracle/product/10.2.0/db_1/oc4j/j2ee/home/jazn.jar -user "iSQL*Plus DBA/admin" -password welcome -shell" under the directory of "D:\oracle\product\10.2.0\db_1\oc4j\j2ee\isqlplus\application-deployments\isqlplus>"

D:\oracle\product\10.2.0\db_1\oc4j\j2ee\isqlplus\application-deployments\isqlplus>java -Djava.security.properties=D:/oracle/product/10.2.0/db_1/oc4j/j2ee/home/config/jazn.security.props -jar D:/oracle/product/10.2.0/db_1/oc4j/j2ee/home/jazn.jar -user "iSQL*Plus DBA/admin" -password welcome -shell
JAZN:> listusers
iSQL*Plus DBA/dev
iSQL*Plus DBA/admin

Do not forget to restart isqlplussvc by isqlplusctl stop/start

why? I don't know, Just do it

[Updated on: Tue, 22 June 2010 22:29]

Report message to a moderator

Previous Topic: "X Rows Selected" message being suppressed
Next Topic: Oracle Database Tools - colledge graduate work
Goto Forum:
  


Current Time: Fri Mar 29 08:18:28 CDT 2024