$ vi .bash_profile
export JAVA_HOME=$ORACLE_HOME/jdk
:wq
$ . .bash_profile
----------------------------------------------------------------------
$ vi jazn.sh
#!/bin/sh
pushd .
cd $ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/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
popd
:wq
----------------------------------------------------------------------
$ chmod 744 jazn.sh
$ ./jazn.sh
-- add user
JAZN> adduser "iSQL*Plus DBA" expert expert
-- grant webDba role to user
JAZN> grantrole webDba "iSQL*Plus DBA" expert
-- webDba 권한자 list
JAZN> listusers "iSQL*Plus DBA"
-- drop user
JAZN> remuser "iSQL*Plus DBA" username
-- revoke webDba role
JAZN> revokerole webDba "iSQL*Plus DBA" username
-- change password
JAZN> setpasswd "iSQL*Plus DBA" username old_password new_password
-- register
JAZN> exit
http://192.168.100.100:5560/isqlplus/dba > expert/expert
'소설과 만화' 카테고리의 다른 글
SQL*Net & Other Waits (0) | 2011.06.18 |
---|---|
ORACLE+PL/SQL (0) | 2011.06.18 |
EM(database control) & iSQL*Plus (0) | 2011.06.18 |
오라클 옵티마이저의 기본 원리 (0) | 2011.06.18 |
Parameter file (0) | 2011.06.18 |