오라클/Admin1

Enabling iSQL*Plus DBA Access

빵순이^^ 2010. 6. 15. 13:04
[oracle@localhost ~]$ cd $ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus
[oracle@localhost isqlplus]$ export JAVA_HOME=$ORACLE_HOME/jdk
[oracle@localhost isqlplus]$ $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

JAZN:> adduser "iSQL*Plus DBA" oradba oracle
JAZN:> listusers "iSQL*Plus DBA"
admin
oradba

JAZN:> grantrole webDba "iSQL*Plus DBA" oradba
JAZN:> setpasswd "iSQL*Plus DBA" admin welcome oracle
JAZN:> setpasswd "iSQL*Plus DBA" oradba oracle oracle
JAZN:> exit

[oracle@localhost config]$ cd $ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus/config
[oracle@localhost config]$ more jazn-data.xml

# Web browser : http://192.168.0.10:5560/isqlplus/dba

     Username           : sys
     Password           : oracle
     Connect Identifier : b

     shutdown abort
     startup

출처 : http://dba-services.berkeley.edu/docs/oracle/manual-10gR2/server.102/b14357/ch2.htm#sthref475