Isql*plus Introduction
Isql*plus is a new feature offered from Oracle 9i and is a sql*plus Web form (Oracle 11g is not supported). is based on a three-tier structure. Its client, middle, and server can be located on the same machine or on a different machine. Isqlplus does not need to be installed separately, through Isqlplus, users can use Sql*plus for data manipulation and database management without the need to install any Oracle clients. Ordinary database users can directly through the Isqlplus Web site Http://ip:port/isqlplus Landing, access to the site will be directly into the database user login interface, the use of ordinary users in the database can log in, but if the DBA user login Isqlpus, You need to first configure the Isql*plus DBA user and password, and then enter the URL http://ip:port/isqlplus/dba, the first pop-up will be a landing box, requiring the first input Isql*plus DBA user and password, Note that this is not a database user, but Isql*plus application server requirements of the user and password, and then the Isql*plus login interface, you can enter the SYS or system users, log into the database for management. To login to Isqlplus as a DBA, you must first configure the oc4j user. The way to use XML config file authentication. The profile is located in $oracle_home/oc4j/j2ee/isqlplus/application-deployments/isqlplus/config but the password in the profile is encrypted, so we cannot modify the file manually. Instead, it is configured through the JAZN (Java AuthoriZatioN). JAZN is a jass (Java authentication and Authorization Service) tool provided by Oracle.
How do I get into the JAZN command environment?
1. Enter the directory $oracle_home/oc4j/j2ee/isqlplus/application-deployments/isqlplus/, as follows:
[Oracle@db-server isqlplus]$ pwd
/database/product/dbhome_1/oc4j/j2ee/isqlplus/application-deployments/isqlplus
[Oracle@db-server isqlplus]$ ls
Application.log config Isqlplus orion-application.xml
2. Ensure that the JAVA_HOME environment variable points to the correct JDK (requires more than 1.4) paths, you can use ORACLE's own JDK, located in $ORACLE_HOME/JDK
3. Execute the following command
[Oracle@db-server isqlplus]$ $ORACLE _home/jdk/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
where Realm=isql*plus dba,user=admin, which can be seen from the XML configuration file, admin's default password is welcome, but the Admin user does not have WEBDBA permissions by default and cannot be used directly for landing isqlplus. With JAZN, you can complete the following tasks
1: New user Kerry password set to etl123!@#
Jazn:> adduser "Isql*plus DBA" Kerry etl123!@#
2: List Users
View users of this group
Jazn:> listusers "Isql*plus DBA"
Admin
Kerry
Jazn:> Listusers
Isql*plus Dba/admin
Isql*plus Dba/kerry
3. Grant the user the right to Kerry dba
jazn:> grantrole webdba "Isql*plus DBA" Kerry
4. Revoke the privileges 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 User
Jazn:> remuser "Isql*plus DBA" Kerry
7. Modify User Password
Jazn:> setpasswd "Isql*plus DBA" Kerry etl123!@# 123456
8. Exit JAZN Command Environment
Jazn:> exit
Above we created a user Kerry, the password is etl123!@#, and has been granted WEBDBA permissions. Next, restart the Isqlplus application Server Isqlplusctl stop, isqlplusctl start
Then enter the URL http://ip:5560/isqlplus/dba, in the pop-up dialog box to enter Kerry and etl123!@#, you can enter the database login interface, choose to SYSDBA or sysoper identity landing.
Start Isql*plus
If the login Isqlplus page is not open (error): http://ip:5560/isqlplus/, first check the Isqlplus service startup did not, and then check the port
[Oracle@db-server ~]$ isqlplusctl start
Isql*plus 10.2.0.1.0
Copyright (c) 2003, +, 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, +, Oracle. All rights reserved.
Getnameinfo failed
Getnameinfo failed
Isql*plus instance on port 5560 are not running ...
Log information
Isql*plus uses log4j, as follows:
[Oracle@db-server isqlplus]$ CD $ORACLE _home/oc4j/j2ee/oc4j_applications/applications/isqlplus/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 it 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.consoleappender
# A1 uses Patternlayout.
Log4j.appender.a1.layout=org.apache.log4j.patternlayout
log4j.appender.a1.layout.conversionpattern=%d{iso8601}%-5.5p [%t]%-20.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.5p [%t]%-20.20c{2}-%m%n
[Oracle@db-server classes]$
In the Oracle 10g $oracle_home/oc4j/j2ee/isqlplus/log directory, you can see some of the following logs:
Log files are located in $oracle_home/oc4j/j2ee/isqlplus/application-deployments/isqlplus/application.log
[Oracle@db-server web-inf]$ CD $ORACLE _home/oc4j/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
Log of Help is recorded in:
$ORACLE _home/oc4j/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 log]$ 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 log]$ more Global-application.log
12/04/22 13:31:07 started
12/04/22 13:31:08 DefaultWebApp:jsp:init
12/04/22 13:31:08 defaultwebapp:9.0.4.1.0 started
12/04/22 14:07:13 defaultwebapp: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 DefaultWebApp:jsp:init
12/09/27 17:23:27 defaultwebapp:9.0.4.1.0 started
12/11/08 17:43:38 started
12/11/08 17:43:39 DefaultWebApp:jsp:init
12/11/08 17:43:39 defaultwebapp:9.0.4.1.0 started
12/11/08 17:54:01 defaultwebapp: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 DefaultWebApp:jsp:init
12/11/08 17:55:43 defaultwebapp:9.0.4.1.0 started
Configuration issues
1: Change the duration of the session:
In the Web.xml file under $oracle_home/oc4j/j2ee/oc4j_applications/applications/isqlplus/isqlplus/web-inf.
Set up:
<session-config>
<session-timeout>15</session-timeout>
</session-config>
is the minute state.
2: Restrict Login
[Oracle@db-server web-inf]$ VI Web.xml
<?xml Version = ' 1.0 ' encoding = ' windows-1252 '?>
<! DOCTYPE Web-app Public "-//sun Microsystems, INC.//DTD Web Application 2.3//en" "Http://java.sun.com/dtd/web-app_2_3. DTD ">
<web-app>
<display-name>iSQL*Plus</display-name>
<description>isql*plus Configuration file</description>
<servlet>
<servlet-name>config</servlet-name>
<servlet-class>oracle.sqlplus.iplus.core.Config</servlet-class>
<init-param>
<param-name>iSQLPlusAllowUserMarkup</param-name>
<param-value>none</param-value>
<description>valid Values Are:none | All</description>
</init-param>
<init-param>
<param-name>iSQLPlusConnectIdList</param-name>
<param-value>wgods;bics;orcl</param-value>
<description>the database (s) to which isql*plus users are restricted. The list should contain the Oracle SIDs or SERVICE NAMEs
, separated by a semicolon (;). If There are no entries, database access is not restricted through isql*plus.</description>
</init-param>
The <param-value> represents the name in $oracle_home/network/admin/tnsnames.ora and can only be selected from the Drop-down box if the service name is set.
If <param-value> does not set a value, you can enter the SID manually. As shown below:
3: Modify the Isql*plus port
Go to $oracle_home/oc4j/j2ee/isqlplus/config, edit Http-web-site.xml file
Problem Kam Set
1: Chinese environment, button fonts appear garbled. You can locate the language. Switch to the English environment to see the button's font
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]$
Backup 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 to confirm that the font file specified in the file Zysong.ttf exists within the system. If there is no need to modify this file or install this font
[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/usr/share/fonts directory, found no ZH_CN directory, new directory zh_cn/truetype, to download fonts online Zysong.ttf placed in the/usr/share/fonts/zh_cn/truetype directory.
And then
[Oracle@db-server fonts]$ CD $ORACLE _home/oc4j/j2ee/oc4j_applications/applications/isqlplus/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, +, 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, +, Oracle. All rights reserved.
Getnameinfo failed
Getnameinfo failed
Starting Isql*plus ...
Isql*plus started.
[Oracle@db-server zhs]$
2: If you do not specify a connection identifier when you log on as a DBA account, you will report the following error: Ora-12154:tns:could not resolve the connect identifier specified.