Setting Up iSQL*Plus for SYSDBA Access

>>>>>>>>CMD<<<<<<<<

Microsoft Windows XP [Version 5.1.2600]

(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\orasoft>d:

D:\>set oracle_home=d:\oracle\product\10.2.0\db_1

D:\>set java_home=%oracle_home%\jdk

D:\>set oracle_home

oracle_home=d:\oracle\product\10.2.0\db_1

D:\>set java_home

java_home=d:\oracle\product\10.2.0\db_1\jdk

D:\>cd %oracle_home%\oc4j\j2ee\isqlplus\application-deployments\isqlplus

D:\oracle\product\10.2.0\db_1\oc4j\j2ee\isqlplus\application-deployments\isqlplu

s>

%java_home%\bin\java -Djava.security.properties=%oracle_home%\oc4j\j2ee\home\c

onfig\jazn.security.props -jar %oracle_home%\oc4j\j2ee\home\jazn.jar -user "iSQL

*Plus DBA/admin" -password welcome -shell

JAZN:> adduser "iSQL*Plus DBA" orasoft orasoft

JAZN:> grantrole webDba "iSQL*Plus DBA" orasoft

JAZN:> exit

JAZN:>

D:\oracle\product\10.2.0\db_1\oc4j\j2ee\isqlplus\application-deployments\isqlplu

s>exit

now type following URL or your browser

http://pc-name:port_number/isqlplus/dba

to get your host name type following query on SQL Prompt

select host_name from v$instance;

to get Port number check in file .

oracle_home\install\portlist.ini