Pages

Thursday, December 2, 2010

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

1 comment: