Oracle Isql*plus configuration Settings Graphic Description _oracle

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.