Oracle 10g中iSQLPlus的相关配置详细指导参见《SQLPlusUser'sGuideAndReference.pdf》
iSQLPlus设置主要是对于使用DBA进行iSQLPlus,这需要一些配置,熟悉几个目录信息就明白了配置的步骤。
1. 首先,要求isqlplus服务器开启
C:\Documents and Settings\Administrator>isqlplusctl start
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Starting iSQL*Plus ...
iSQL*Plus started.
2. 测试http://localhost:5560/isqlplus
3. 访问iSQL*Plus DBA URL,必须设置OC4J用户管理,OC4J有两种身份认证方式:
The XML-based provider type, jazn-data.xml(基于XML的配置文件)
The LDAP-based provider type, Oracle Internet Directory(基于LDAP)
现在只采用第一种方式,该配置文件位于$ORACLE_HOME\oc4j\j2ee\isqlplus\application-deployments\isqlplus\config目录下,但是该配置文件中的密码是加密过的,所以我们不能手动修改该档,而是通过JAZN(Java AuthoriZatioN)来配置。JAZN是oracle提供的一个JASS(Java Authentication and Authorization Service)工具,通过JAZN,可以完成以下任务:
Create users
List users
Grant the webDba role
Remove users
Revoke the webDba role
Change user passwords
以上任务,可以先进入JAZN命令环境后再执行,也可以直接通过一条完整的命令行实现。
4. 确定进入目录$ORACLE_HOME\oc4j\j2ee\isqlplus\application-deployments\isqlplus
5. 运行命令:
D:\oracle\product\10.2.0\db_1\oc4j\j2ee\isqlplus\application-deployments\isqlplus>java -Djava.security.properties=D:/ora
cle/product/10.2.0/db_1/sqlplus/admin/iplus/provider -jar D:/oracle/product/10.2.0/db_1/oc4j/j2ee/home/jazn.jar -user "i
SQL*Plus DBA/admin" -password "welcome" -shell
JAZN:> adduser "iSQL*Plus DBA" sys Fih123456
JAZN:> grantrole webDba "iSQL*Plus DBA" sys
JAZN:> exit
进行JAZN:>提示符,可以去掉-user "iSQL*Plus DBA/admin" -password admin_password,但会提示输入用户名和密码,默认用户和密码分别为admin和welcome.
注:1> 在config目录下的jazn.xml、jazn-data.xml文件是jazn工具的配置信息,有时候不存在jazn-data.xml文件,可以用相同版本的文件,附件中为此文件的内容;
2> 要设定好java的环境变量JAVA_HOME,可以使用oracle中的$ORACLE_HOME/jdk
3> 在JAZN:>提示符下创建一个管理员,用adduser "iSQL*Plus DBA" username password命令。
4> 用grantrole webDba "iSQL*Plus DBA" username命令给上面创建的用户给定管理员角色。
6. 重启isqlplus
C:\Documents and Settings\Administrator>isqlplusctl start
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Starting iSQL*Plus ...
iSQL*Plus stoped.
C:\Documents and Settings\Administrator>isqlplusctl start
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Starting iSQL*Plus ...
iSQL*Plus started.
7. 查看$ORACLE_HOME\oc4j\j2ee\isqlplus\config下的http-web-site.xml文件,可以看到iSQLPlus所使用的端口号,这个可以确定iSQLPlus访问的URL:http://machine_name.domain:5560/isqlplus/dba
8. 完成上面创建用户后,重启iSQLPlus服务,利用这个网址可以打开iSQLPlus,在选择SYSDBA进入时会出现一个对话框,然后使用上面创建的用户和密码。
在配置过程中出错如下错误:
1. 在jazn-data.xml文件有问题时,做如下连接会出现错误
D:\oracle\product\10.2.0\db_1\oc4j\j2ee\isqlplus\application-deployments\isqlplus>D:\oracle\product\10.2.0\db_1\jdk\bin\
java -Djava.security.properties=D:/oracle/product/10.2.0/db_1/sqlplus/admin/iplus/provider -jar D:/oracle/product/10.2.0
/db_1/oc4j/j2ee/home/jazn.jar -shell
RealmLoginModule username: admin
RealmLoginModule password:********
*Authentication Failed
2. 运行isqlplusctl stop后再用isqlplusctl start后,出现如下错误
未解决,能否尝试重启计算机可解决?
附:Jazn-data.xml文件内容
<?xml version="1.0" encoding="UTF-8" standalone='yes'?>
<!-- JAZN Realm Data -->
iSQL*Plus DBA
admin
Realm Administrator
Administrator for this realm.
{903}ubtKEVZPHqBXthQMG2Pi5mnwWzjLlPHX
admin
Realm Admin Role
Administrative role for this realm.
user
admin
webDba
<!-- JAZN Policy Data -->
iSQL*Plus DBA
role
oracle.security.jazn.spi.xml.XMLRealmRole
iSQL*Plus DBA/admin
oracle.security.jazn.realm.RealmPermission
iSQL*Plus DBA
modifyrealmmetadata
oracle.security.jazn.realm.RealmPermission
iSQL*Plus DBA
droprealm
oracle.security.jazn.realm.RealmPermission
iSQL*Plus DBA
createrealm
oracle.security.jazn.policy.RoleAdminPermission
iSQL*Plus DBA/*
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$createrealm
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$droprealm
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$createrole
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$droprole
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$modifyrealmmetadata
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.policy.RoleAdminPermission$iSQL*Plus DBA/*$
iSQL*Plus DBA
role
oracle.security.jazn.spi.xml.XMLRealmRole
iSQL*Plus DBA/admin
oracle.security.jazn.realm.RealmPermission
iSQL*Plus DBA
modifyrealmmetadata
oracle.security.jazn.realm.RealmPermission
iSQL*Plus DBA
droprealm
oracle.security.jazn.policy.RoleAdminPermission
iSQL*Plus DBA/*
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$createrealm
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$droprealm
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$createrole
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$droprole
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$modifyrealmmetadata
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.policy.RoleAdminPermission$iSQL*Plus DBA/*$
iSQL*Plus DBA
role
oracle.security.jazn.spi.xml.XMLRealmRole
iSQL*Plus DBA/admin
oracle.security.jazn.realm.RealmPermission
iSQL*Plus DBA
modifyrealmmetadata
oracle.security.jazn.policy.RoleAdminPermission
iSQL*Plus DBA/*
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$createrealm
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$droprealm
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$createrole
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$droprole
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$modifyrealmmetadata
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.policy.RoleAdminPermission$iSQL*Plus DBA/*$
iSQL*Plus DBA
role
oracle.security.jazn.spi.xml.XMLRealmRole
iSQL*Plus DBA/admin
oracle.security.jazn.policy.RoleAdminPermission
iSQL*Plus DBA/*
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$createrealm
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$droprealm
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$createrole
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$droprole
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$modifyrealmmetadata
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.policy.RoleAdminPermission$iSQL*Plus DBA/*$
iSQL*Plus DBA
role
oracle.security.jazn.spi.xml.XMLRealmRole
iSQL*Plus DBA/admin
oracle.security.jazn.policy.RoleAdminPermission
iSQL*Plus DBA/*
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$droprealm
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$createrole
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$droprole
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$modifyrealmmetadata
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.policy.RoleAdminPermission$iSQL*Plus DBA/*$
iSQL*Plus DBA
role
oracle.security.jazn.spi.xml.XMLRealmRole
iSQL*Plus DBA/admin
oracle.security.jazn.policy.RoleAdminPermission
iSQL*Plus DBA/*
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$createrole
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$droprole
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$modifyrealmmetadata
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.policy.RoleAdminPermission$iSQL*Plus DBA/*$
iSQL*Plus DBA
role
oracle.security.jazn.spi.xml.XMLRealmRole
iSQL*Plus DBA/admin
oracle.security.jazn.policy.RoleAdminPermission
iSQL*Plus DBA/*
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$createrole
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$droprole
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.policy.RoleAdminPermission$iSQL*Plus DBA/*$
iSQL*Plus DBA
role
oracle.security.jazn.spi.xml.XMLRealmRole
iSQL*Plus DBA/admin
oracle.security.jazn.policy.RoleAdminPermission
iSQL*Plus DBA/*
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.realm.RealmPermission$iSQL*Plus DBA$droprole
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.policy.RoleAdminPermission$iSQL*Plus DBA/*$
iSQL*Plus DBA
role
oracle.security.jazn.spi.xml.XMLRealmRole
iSQL*Plus DBA/admin
oracle.security.jazn.policy.RoleAdminPermission
iSQL*Plus DBA/*
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.policy.RoleAdminPermission$iSQL*Plus DBA/*$
iSQL*Plus DBA
role
oracle.security.jazn.spi.xml.XMLRealmRole
iSQL*Plus DBA/admin
oracle.security.jazn.policy.AdminPermission
oracle.security.jazn.policy.RoleAdminPermission$iSQL*Plus DBA/*$
<!-- Permission Class Data -->
<!-- Principal Class Data -->
<!-- Login Module Data -->
oracle.security.jazn.tools.Admintool
oracle.security.jazn.realm.RealmLoginModule
required
debug
false
addAllRoles
true
oracle.security.jazn.oc4j.JAZNUserManager
oracle.security.jazn.realm.RealmLoginModule
required
addAllRoles
true
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9932141/viewspace-614476/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9932141/viewspace-614476/