Shulou(Shulou.com)06/01 Report--

After installing Oracle 10g on linux, we often use isqlplus to execute SQL statements. But the normal isqlplus login interface only supports logging in as an ordinary user, and sometimes we have to use the permission of sys to perform certain operations, so how can we log in to the isqlplus page as sys?

(1) set the java environment variable for oracle users: (add a line at the bottom of the file)

[oracle@foway~] vim.bash_profileexportJAVA_HOME=$ORACLE_HOME/jdkexportPATH=$PATH:$JAVA_HOME/bin

Save exit

[oracle@foway~] source .bash _ profile

(2)

(the content is as follows,\ is a line-breaking character, pay attention to whether there is a space in front of it)

[oracle@foway~] cd $ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus [oracle@foway~] 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

(note that SQL*P is uppercase, if the lowercase program will make an error)

The JAZN: > prompt appears

Or

[oracle@foway~] java-Djava.security.properties=\ $ORACLE_HOME/sqlplus/admin/iplus/provider\-jar $ORACLE_HOME/oc4j/j2ee/home/jazn.jar\-user "iSQL*Plus DBA/admin"\-password welcome-shell

The JAZN: > prompt appears

JAZN: > listusers "iSQL*Plus DBA"

List the current DBA user admin

(3) add dba users logged in by isqlplus:

JAZN: > adduser "iSQL*Plus DBA" foway oracle

(note: foway is the user name set by yourself, oracle is the password)

(4) Grant the role of webDba administrator to foway users:

JAZN: > grantrole webDba "iSQL*PlusDBA" fowayJAZN: > exit

(5) Log in to the management interface of isqlplus:

Enter the management login URL http://foway.uplooking.com:5560/isqlplus/dba

Enter the user name foway password oracle that you added earlier in the pop-up window

B. will go to the dba login interface http://foway.uplooking.com:5560/isqlplus/dba.uix

Enter the user name and password of sys here to log in as "SYSDBA".

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.