ISQL * PLUS is a new feature provided by ORACLE9i. It is a Web form of SQL * PLUS (not supported by ORACLE11g). It is designed based on a three-tier structure.
ISQL * PLUS is a new feature provided since ORACLE 9i. It is a Web form of SQL * PLUS (which is not supported by ORACLE 11g). It is designed based on a three-tier structure.
Introduction to iSQL * PLUS
ISQL * PLUS is a new feature provided since ORACLE 9i and is a Web form of SQL * PLUS (not supported by ORACLE 11g ). It is designed based on a three-tier structure. Its client, middle, and server can be located on the same machine or on different machines. ISqlPlus does not need to be installed independently. With isqlplus, you can use SQL * PLUS in a browser to perform data operations and database management without installing any ORACLE client. Common database users can log in directly through the isqlplus URL http: // ip: port/isqlplus. After entering this URL, the database user login interface is directly displayed, use a common user in the database to log on. However, if you are a DBA user logging on to isqlpus, you must first configure the iSQL * plus dba user and password, and then enter the URL http: // ip: port/isqlplus/dba, the iSQL * PLUS application server requires the user and password before the iSQL * PLUS logon interface is displayed. You can enter the sys or system user to log on to the database for management. To log on to isqlplus as a DBA, you must configure the Solaris User first. Use xml configuration file authentication. This configuration file is located at $ ORACLE_HOME/Solaris/j2ee/isqlplus/application-deployments/isqlplus/config, but the password in this configuration file is encrypted, so we cannot manually modify this file, it is configured through Java AuthoriZatioN. JAZN is a JASS (Java Authentication and Authorization Service) tool provided by ORACLE.
How do I enter the JAZN command environment?
1. Go to the $ ORACLE_HOME/productname/j2ee/isqlplus/application-deployments/isqlplus/directory, as shown below:
[Oracle @ DB-Server isqlplus] $ pwd
/Database/product/dbhome_1/productname/j2ee/isqlplus/application-deployments/isqlplus
[Oracle @ DB-Server isqlplus] $ ls
Application. log config isqlplus orion-application.xml
2. Make sure that the JAVA_HOME environment variable points to the correct jdk (requires more than 1.4) path. You can use the jdk that comes with ORACLE, which is located at $ ORACLE_HOME/jdk.
3. Execute the following command
[Oracle @ DB-Server isqlplus] $ ORACLE_HOME/jdk/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"-password welcome-shell
Realm = iSQL * Plus DBA, user = admin. You can see from the xml configuration file that the default admin password is welcome, but the admin user does not have the webDba permission by default, you cannot directly log on to isqlplus. You can complete the following tasks through the JAZN:
1: Set the kerry password of the new user to etl123! @#
JAZN:> adduser "iSQL * Plus DBA" kerry etl123! @#
2: List users
View users in this group
JAZN:> listusers "iSQL * Plus DBA"
Admin
Kerry
JAZN:> listusers
ISQL * Plus DBA/admin
ISQL * Plus DBA/kerry
3. Grant kerry DBA Permissions
JAZN:> grantrole webDba "iSQL * Plus DBA" kerry
4. revoke the permission of the user kerry DBA
JAZN:> revokerole webDba "iSQL * Plus DBA" kerry
5. View roles
JAZN:> listroles
ISQL * Plus DBA/webDba
ISQL * Plus DBA/admin
6. delete a user
JAZN:> remuser "iSQL * Plus DBA" kerry
7. Change User Password
JAZN:> setpasswd "iSQL * Plus DBA" kerry etl123! @# 123456
8. Exit the JAZN command environment
JAZN:> exit
We created a user kerry with the password etl123! @ #, And the webDba permission has been granted. Then restart isqlplus Application Server isqlplusctl stop, isqlplusctl start
Go to the http: // ip: 5560/isqlplus/dba website. In the displayed dialog box, enter kerry and etl123! @ #, You can log on to the database logon page and select sysdba or sysoper.
Start iSQL * PLUS
If the isqlplus page cannot be opened (error reported): http: // ip: 5560/isqlplus/, first check whether the isqlplus Service is started, and then check the port
[Oracle @ DB-Server ~] $ Isqlplusctl start
ISQL * Plus 10.2.0.1.0
Copyright (c) 2003,200 5, Oracle. All rights reserved.
Getnameinfo failed
Getnameinfo failed
Starting iSQL * Plus...
ISQL * Plus started.
[Oracle @ DB-Server ~] $ Netstat-an | grep 5560
Tcp 0 0 0.0.0.0: 5560 0.0.0.0: * LISTEN
Stop iSQL * PLUS
[Oracle @ DB-Server ~] $ Isqlplusctl stop
ISQL * Plus 10.2.0.1.0
Copyright (c) 2003,200 5, Oracle. All rights reserved.
Getnameinfo failed
Getnameinfo failed
ISQL * Plus instance on port 5560 is not running...
Log Information
ISQL * PLUS uses Log4j as follows:
[Oracle @ DB-Server isqlplus] $ cd $ ORACLE_HOME/productname/j2ee/oc4j_applications/applications/isqlplus/WEB-INF/classes
[Oracle @ DB-Server classes] $ ls
Log4j. properties oracle
[Oracle @ DB-Server classes] $ more log4j. properties
# Log4j configuration file.
# Set root logger level and its only appender to A1.
# Log4j. rootLogger = ALL, A1
# Log4j. rootLogger = DEBUG, A1
# Log4j. rootLogger = INFO, A1
# Log4j. rootLogger = WARN, A1
# Log4j. rootLogger = ERROR, A1
Log4j. rootLogger = FATAL, A1
# Log4j. rootLogger = OFF, A1
# A1 is set to be a ConsoleAppender.
Log4j. appender. A1 = org. apache. log4j. leleappender
# A1 uses PatternLayout.
Log4j. appender. A1.layout = org. apache. log4j. PatternLayout
Log4j. appender. A1.layout. ConversionPattern = % d {ISO8601} %-5.5 p [% t] %-runtime 20c {2}-% m % n
# R is a rolling log file appender
Log4j. appender. R = org. apache. log4j. RollingFileAppender
Log4j. appender. R. File = isqlplus. log
Log4j. appender. R. MaxFileSize = 100KB
# Keep one backup file
Log4j. appender. R. MaxBackupIndex = 1
Log4j. appender. R. layout = org. apache. log4j. PatternLayout
Log4j. appender. R. layout. ConversionPattern = % d {ISO8601} %-5.5 p [% t] %-runtime 20c {2}-% m % n
[Oracle @ DB-Server classes] $
In the $ oracle_home/Solaris/j2ee/isqlplus/log directory of ORACLE 10 Gb, you can see the following logs:
The log file is located at $ ORACLE_HOME/Solaris/j2ee/isqlplus/application-deployments/isqlplus/application. log.
[Oracle @ DB-Server WEB-INF] $ cd $ ORACLE_HOME/productname/j2ee/isqlplus/application-deployments/isqlplus
[Oracle @ DB-Server isqlplus] $ ls
Application. log config isqlplus orion-application.xml
[Oracle @ DB-Server isqlplus] $ more application. log
12/04/22 13:31:07 Started
12/04/22 13:31:09 isqlplus: jsp: init
12/04/22 13:31:09 isqlplus: config: init
12/04/22 13:31:09 isqlplus: uix: init
12/04/22 13:31:09 isqlplus: 9.0.4.1.0 Started
12/04/22 14:07:13 isqlplus: config: destroy
12/04/22 14:07:13 isqlplus: 9.0.4.1.0 Stopped
12/04/22 14:07:13 Stopped (JVM termination)
12/09/27 17:23:21 Started
12/09/27 17:23:29 isqlplus: jsp: init
12/09/27 17:23:30 isqlplus: config: init
12/09/27 17:23:31 isqlplus: uix: init
12/09/27 17:23:31 isqlplus: 9.0.4.1.0 Started
The help logs are recorded in:
$ ORACLE_HOME/productname/j2ee/isqlplus/application-deployments/isqlplushelp/application. log
[Oracle @ DB-Server log] $ ls
Global-application.log http-web-access.log rmi. log server. log
[Oracle @ DB-Server log] $ more rmi. log
12/04/22 13:31:07 9.0.4.1.0 Started
12/04/22 14:07:13 9.0.4.1.0 Stopped (JVM termination)
12/09/27 17:23:19 9.0.4.1.0 Started
12/11/08 17:43:38 9.0.4.1.0 Started
12/11/08 17:54:01 9.0.4.1.0 Stopped (Shutdown executed by jazn.com/admin from 127.0.0.1 (localhost), 2)
12/11/08 17:55:42 9.0.4.1.0 Started
[Oracle @ DB-Server log] $ more server. log
12/04/22 13:31:07 9.0.4.1.0 Started
12/04/22 13:31:07 9.0.4.1.0 Started
12/04/22 14:07:13 9.0.4.1.0 Stopped (JVM termination)
12/09/27 17:23:19 9.0.4.1.0 Started
12/09/27 17:23:21 9.0.4.1.0 Started
12/11/08 17:43:37 9.0.4.1.0 Started
12/11/08 17:43:38 Forced or abrupt (crash etc) server shutdown detected, starting recovery process...
12/11/08 17:43:38 Recovery completed, 0 connections committed and 0 rolled back...
12/11/08 17:43:38 9.0.4.1.0 Started
12/11/08 17:54:01 9.0.4.1.0 Stopped (Shutdown executed by jazn.com/admin from 127.0.0.1 (localhost), 2)
12/11/08 17:55:42 9.0.4.1.0 Started
12/11/08 17:55:42 9.0.4.1.0 Started
[Oracle @ DB-Server logs] $ more http-web-access.log
172.20.61.185--[27/Sep/2012: 17: 24: 39 + 0800] "GET/isqlplus/HTTP/1.1" 200 9154
172.20.61.185--[27/Sep/2012: 17: 24: 39 + 0800] "GET/isqlplus/cabo/styles/cache/blaf-A0-zh_CN-ie-windows.css HTTP/1
. 1 "200 13850
172.20.61.185--[27/Sep/2012: 17: 24: 39 + 0800] "GET/isqlplus/cabo/images/cache/c-ghss.gif HTTP/1.1" 200 97
172.20.61.185--[27/Sep/2012: 17: 24: 39 + 0800] "GET/isqlplus/images/logo.gif HTTP/1.1" 200 7361
172.20.61.185--[27/Sep/2012: 17: 24: 39 + 0800] "GET/isqlplus/cabo/images/t.gif HTTP/1.1" 200 85
172.20.61.185--[27/Sep/2012: 17: 24: 39 + 0800] "GET/isqlplus/images/help.gif HTTP/1.1" 200 288
172.20.61.185--[27/Sep/2012: 17: 24: 40 + 0800] "GET/isqlplus/cabo/jsLibs/MarlinCoreA4.js HTTP/1.1" 200 26036
172.20.61.185--[27/Sep/2012: 17: 24: 40 + 0800] "GET/isqlplus/cabo/images/cache/c-ghsc.gif HTTP/1.1" 200 72
172.20.61.185--[27/Sep/2012: 17: 24: 40 + 0800] "GET/isqlplus/cabo/images/cache/c-ghe.gif HTTP/1.1" 200 85
172.20.61.185--[27/Sep/2012: 17: 24: 40 + 0800] "GET/isqlplus/cabo/images/cache/c-ghse.gif HTTP/1.1" 200 219
172.20.61.185--[27/Sep/2012: 17: 24: 40 + 0800] "GET/isqlplus/cabo/images/cache/c-ghc.gif HTTP/1.1" 200 133
172.20.61.185--[27/Sep/2012: 17: 24: 40 + 0800] "GET/isqlplus/cabo/images/cache/zhs/b-login.gif HTTP/1.1" 200 715
172.20.61.185--[27/Sep/2012: 17: 24: 40 + 0800] "GET/isqlplus/cabo/images/cache/c-skir.gif HTTP/1.1" 200 66
172.20.61.185--[27/Sep/2012: 17: 24: 43 + 0800] "GET/favicon. ico HTTP/1.1" 404 135
172.20.61.185--[27/Sep/2012: 17: 24: 52 + 0800] "POST/isqlplus/login. uix HTTP/1.1" 200 11618
172.20.61.185--[27/Sep/2012: 17: 24: 52 + 0800] "GET/isqlplus/cabo/images/t.gif HTTP/1.1" 304 0
172.20.61.185--[27/Sep/2012: 17: 24: 52 + 0800] "GET/isqlplus/images/logo.gif HTTP/1.1" 304 0
172.20.61.185--[27/Sep/2012: 17: 24: 52 + 0800] "GET/isqlplus/cabo/jsLibs/MarlinCoreA4.js HTTP/1.1" 304 0
172.20.61.185--[27/Sep/2012: 17: 24: 52 + 0800] "GET/isqlplus/images/logout.gif HTTP/1.1" 200 360
172.20.61.185--[27/Sep/2012: 17: 24: 52 + 0800] "GET/isqlplus/cabo/styles/cache/blaf-A0-zh_CN-ie-windows.css HTTP/1
. 1 "304 0
172.20.61.185--[27/Sep/2012: 17: 24: 52 + 0800] "GET/isqlplus/cabo/images/cache/c-ghss.gif HTTP/1.1" 304 0
172.20.61.185--[27/Sep/2012: 17: 24: 52 + 0800] "GET/isqlplus/cabo/images/cache/zhs/tb-56-0.gif HTTP/1.1" 200 971
172.20.61.185--[27/Sep/2012: 17: 24: 52 + 0800] "GET/isqlplus/images/help.gif HTTP/1.1" 304 0
172.20.61.185--[27/Sep/2012: 17: 24: 52 + 0800] "GET/isqlplus/cabo/images/cache/c-ghsc.gif HTTP/1.1" 304 0
172.20.61.185--[27/Sep/2012: 17: 24: 52 + 0800] "GET/isqlplus/cabo/images/cache/c-ghc.gif HTTP/1.1" 304 0
172.20.61.185--[27/Sep/2012: 17: 24: 52 + 0800] "GET/isqlplus/cabo/images/cache/c-ghse.gif HTTP/1.1" 304 0
172.20.61.185--[27/Sep/2012: 17: 24: 52 + 0800] "GET/isqlplus/cabo/I
[Oracle @ DB-Server logs] $ more global-application.log
12/04/22 13:31:07 Started
12/04/22 13:31:08 defawebwebapp: jsp: init
12/04/22 13:31:08 defawebwebapp: 9.0.4.1.0 Started
12/04/22 14:07:13 defawebwebapp: 9.0.4.1.0 Stopped
12/04/22 14:07:13 Stopped (JVM termination)
12/09/27 17:23:20 Started
12/09/27 17:23:27 defawebwebapp: jsp: init
12/09/27 17:23:27 defawebwebapp: 9.0.4.1.0 Started
12/11/08 17:43:38 Started
12/11/08 17:43:39 defawebwebapp: jsp: init
12/11/08 17:43:39 defawebwebapp: 9.0.4.1.0 Started
12/11/08 17:54:01 defawebwebapp: 9.0.4.1.0 Stopped
12/11/08 17:54:01 Stopped (Shutdown executed by jazn.com/admin from 127.0.0.1 (localhost), 2)
12/11/08 17:55:42 Started
12/11/08 17:55:43 defawebwebapp: jsp: init
12/11/08 17:55:43 defawebwebapp: 9.0.4.1.0 Started
Configuration problems
1: Change the validity period of the session:
In the web. xml file under the $ ORACLE_HOME/Solaris/j2ee/oc4j_applications/applications/isqlplus/WEB-INF.
Settings:
15
Minutes.
2: Restrict Logon
[Oracle @ DB-Server WEB-INF] $ vi web. xml
ISQL * Plus
ISQL * Plus Configuration File
Config
Oracle. sqlplus. iplus. core. Config
ISQLPlusAllowUserMarkup
None
Valid values are: none | all
ISQLPlusConnectIdList
Wgods; bics; orcl
The database (s) to which iSQL * Plus users are restricted. The list shoshould contain the Oracle SIDs or SERVICE NAMEs
, Separated by a semicolon (;). If there are no entries, database access is not restricted through iSQL * Plus.
The Represents the name in $ ORACLE_HOME/network/admin/tnsnames. ora. If you set a service name, you can only select it from the drop-down list.
If If no value is set, enter the SID manually. As follows:
3: Modify the iSQL * PLUS Port
Go to $ ORACLE_HOME/Solaris/j2ee/isqlplus/config to edit the http-web-site.xml File
FAQ
1: Chinese environment, garbled button font. Available Site Selection languages. Switch to the English environment to see the font of the button
Solution:
[Oracle @ DB-Server zhs] $ cd $ ORACLE_HOME/jdk/jre/lib
[Oracle @ DB-Server lib] $ ls
Audio font. properties. ja. Redhat6.2 font. properties. zh_CN.Redhat2.1 images
Charsets. jar font. properties. ja. Redhat7.2 font. properties. zh_CN.Sun jce. jar
Cmm font. properties. ja. Redhat7.3 font. properties. zh_CN_UTF8.Sun jsse. jar
Content-types.properties font. properties. ja. Redhat8.0 font. properties. zh_HK.Sun jvm.hprof.txt
Ext font. properties. ja. Turbo font. properties. zh_HK_UTF8.Sun jvm.jcov.txt
Flavormap. properties font. properties. ja. Turbo6.0 font. properties. zh_HK_UTF8.Sun2003 locale
Font. properties font. properties. ko_KR.Sun font. properties. zh. Turbo logging. properties
Font. properties_back font. properties. ko_KR_UTF8.Sun font. properties. zh_TW.Redhat plugin. jar
Font. properties. ja font. properties. ko_KR_UTF8.Sun2003 font. properties. zh_TW.Redhat2.1 psfontj2d. properties
Font. properties. ja_JP.Sun font. properties. ko. Redhat font. properties. zh_TW.Sun psfont. properties. ja
Font. properties. ja_JP.Sun2003 font. properties. ko. Redhat2.1 font. properties. zh_TW_UTF8.Sun rt. jar
Font. properties. ja_JP_UTF8.Sun font. properties. Redhat6.1 font. properties. zh_TW_UTF8.Sun2003 security
Font. properties. ja_JP_UTF8.Sun2003 font. properties. Redhat8.0 fonts sunrsasign. jar
Font. properties. ja. Redhat3 font. properties. SuSE8.0 i386 zi
Font. properties. ja. Redhat6.1 font. properties. zh_CN.Redhat im
[Oracle @ DB-Server lib] $
Back up font. properties
[Oracle @ DB-Server lib] $ cp font. properties font. properties_back
[Oracle @ DB-Server lib] $ cp font. properties. zh_CN.Redhat font. properties
View the font. properties file and check that the specified font file zysong. ttf exists in the system. Modify this file or install this font if it does not exist.
[Oracle @ DB-Server lib] $ tail-10 font. properties
Fontset. dialoginput. plain = \
-B & h-luxi mono-medium-r-normal -- *-% d-*-m-*-iso8859-1 ,\
-Isas-song ti-medium-r-normal -- *-% d-*-c-*-gb2312.1980-0
Fontset. default = \
-B & h-luxi sans-medium-r-normal -- *-% d-*-p-*-iso8859-1 ,\
-Isas-song ti-medium-r-normal -- *-% d-*-c-*-gb2312.1980-0
Filename.-misc-zysong18030-medium-r-normal -- *-% d-*-c-*-iso10646-1 =/usr/share/fonts/zh_CN/TrueType/zysong. ttf
[Oracle @ DB-Server lib] $
Go to the/usr/share/fonts directory and find that there is no zh_CN directory. Create the directory zh_CN/TrueType and download the fonts zysong from the Internet. ttf is stored in the/usr/share/fonts/zh_CN/TrueType directory.
Then
[Oracle @ DB-Server fonts] $ cd $ ORACLE_HOME/productname/j2ee/oc4j_applications/applications/isqlplus/cabo/images/cache/zhs/
[Oracle @ DB-Server zhs] $ ls
B-0dac.gif b-54.gif b-cancel.gif b-execute.gif b-login.gif b-save.gif
B-0dac.imx b-54.imx b-cancel.imx b-execute.imx b-login.imx b-save.imx
[Oracle @ DB-Server zhs] $ rm *
[Oracle @ DB-Server zhs] $ isqlplusctl stop
ISQL * Plus 10.2.0.1.0
Copyright (c) 2003,200 5, Oracle. All rights reserved.
Getnameinfo failed
Getnameinfo failed
Stopping iSQL * Plus...
ISQL * Plus stopped.
[Oracle @ DB-Server zhs] $ isqlplusctl start
ISQL * Plus 10.2.0.1.0
Copyright (c) 2003,200 5, Oracle. All rights reserved.
Getnameinfo failed
Getnameinfo failed
Starting iSQL * Plus...
ISQL * Plus started.
[Oracle @ DB-Server zhs] $
2: When you log on with a DBA account, if you do not specify a connection identifier, the following error is reported: ORA-12154: TNS: cocould not resolve the connect identifier specified.