Graphic description of oracleiSQL * PLUS configuration settings

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.