InLinuxInstalled onOracle 10g In the future, we will often useIsqlplusTo executeSQLStatement. But normalIsqlplusThe logon interface only supports Logon as a common user.SysIdentity permission to perform some operations, then how can weSysIdentity to log onIsqlplusWhat about the page?
(1)SetOracleUser'sJavaEnvironment Variable:(Add a line at the bottom of the file)
[Oracle @ ocp ~] Vim. bash_profile ---->Export JAVA_HOME = $ ORACLE_HOME/jdk
(2) Execute the following script program:
[Oracle @ ocp ~] Vim JAZN. sh(The content is as follows,\It is a conversion character. Note whether there are spaces in front of it.)
Cd $ ORACLE_HOME/Solaris/j2ee/isqlplus/Solaris/j2ee/isqlplus/application-deployments/isqlplus
$ JAVA_HOME/bin/java-Djava. security. properties= \
$ ORACLE_HOME/Solaris/j2ee/home/config/jazn. security. props\
-Jar $ ORACLE_HOME/Solaris/j2ee/home/jazn. jar\
-User "ISQL*PLus DBA/admin"\(Note:SQL * PIsUppercaseLetter. If the lower-case program fails)
-Password welcome-shell
[Oracle @ ocp ~] Chmod + x JAZN. sh(Grant a documentExecutable permissions)
[Oracle @ ocp ~] ./JAZN. sh
(3) AddIsqlplusLogged OnDbaUser:ShThe following prompt will appear after the script)
JAZN> Adduser "iSQL * Plus DBA"Websys Oracle(Note:WebsysIs the user name set by yourself,OraclePassword)
(4)WebsysUser authorizationWebDbaAdministrator role:
JAZN>Grantrole webDBa "iSQL * Plus DBA"Websys
JAZN>Exit
(5) LoginIsqlplusManagement Interface:
AEnter the management logon URLHttp://ocp.example.com: 5560/isqlplus/dba
In the dialog box that appears, enter the username you added.WebsysPasswordOracle
B, Will goDbaLogon pageHttp://ocp.example.com: 5560/isqlplus/dba. uix
EnterSysThe user name and password can be"SYSDBA.