How to log into the Isqlplus page as sys in Oracle 10g

Once the Oracle 10g is installed 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 we sometimes have to use the SYS identity to perform certain operations, so how to log in as Sys What about the Isqlplus page?

(1) set the Java environment variable for the Oracle user : (Add a line at the bottom of the file)

[Email protected]~] Vim.bash_profile

Exportjava_home= $ORACLE _HOME/JDK

Exportpath= $PATH: $JAVA _home/bin

Save Exit ,

[[Email protected]~] source. bash_profile

(2)

(The contents are as follows,\ is a career change character, note that there are no spaces ahead )

[Email protected]~]cd $ORACLE _home/oc4j/j2ee/isqlplus/application-deployments/isqlplus[[email Protected]~]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 Sql*p to uppercase, if the lowercase program goes wrong)

appear Jazn:> Prompt

Or

[Email protected]~]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

appear Jazn:> Prompt

Jazn:>listusers "Isql*plus DBA"

Lists the current DBA User Admin

(3) Add DBA user for Isqlplus login:

Jazn:> adduser "Isql*plus DBA" Foway Oracle

( Note:foway is the user name that you set,Oracle is the password )

(4) to Grant the Foway user the role of the WEBDBA administrator:

jazn:> grantrole webdba "ISQL*PLUSDBA" Fowayjazn:>exit

(5) Login isqlplus Management interface:

A, enter the management login URL http://foway.uplooking.com:5560/isqlplus/dba

in the pop-up window, enter the user name you added earlier foway password Oracle

B, will go to dba login Interface Http://foway.uplooking.com:5560/isqlplus/dba.uix

Enter the user name and passwordof Sys here to log in as "SYSDBA".

How to log on to the Isqlplus page as sys in Oracle 10g