同学笔记:OracleAS 10g(9.0.4) Administrator's Guide

Puber

Table6-1-2

Puber

Table6-1-3

Puber

Table6-1-4

Puber

[B]6.2.1 Changing Schema Password Using the Application Server Control Console[/B]
某些schemas将password也存放在Oracle Internet Directory中. 你必须用Application Server Control Console来修改其password.这样才能同时更新到OID和Metadata Repository.
用Application Server Control Console修改某schema的password滴步骤如下:
-1. 先确定schema,并按Table6-1找到对应的middle-tier instance或Infrastructure滴home page.
-2. 在home page中,点击Infrastructure.
-3. 在Infrastructure page, 点击[B]Change Schema Password[/B].
-4. 在Change Schema Password page,选择想更改的schema,并在Password and Confirm Password域中输入new password.点击[B]OK[/B].


[B]6.2.2 Changing Schema Passwords Using SQL*Plus[/B]
某些schemas是可以使用SQL*PLUS直接改password滴.这时的schema就和普通的database schema没什么差别[/COLOR].操作步骤如下:
以SYSDBA或其它足够权限的用户登录到Metadata Repository Database.运行以下命令:
SQL> ALTER USER [I]schema[/I] identified by [I]new_password[/I][/COLOR]
例如,将SCOTT schema的password改为"abc123":
SQL> ALTER USER SCOTT IDENTIFIED BY abc123;[/COLOR]

Puber

[B]6.2.3 Viewing and Changing Schema Passwords in Oracle Internet Directory[/B]
有几个schema(DCM, IP, OWF_MGR)需要手动更新Metadata Repository和Oracle Internet Directory中的password.
下面的步骤讲述如何在Oracle Internet Direcotory中修改和查看他们的password.
-1. 用以下命令启动Oracle Directory Manager:
$ORACLE_HOME/bin/oidadmin[/COLOR]
-2. 用orcladmin用户登录到Oracle Directory Manager.
-3. 在System Objects框中,展开[B]Entry Management[/B],展开[B]cn=OracleContext[/B],展开[B]cn=Products[/B],展开[B]cn=IAS[/B],展开[B]cn=IAS Infrastructure Databases[/B],展开对应Metadata Repository的orclReferenceName.
-4. 在OrclResourceName中选择想改password滴schema.
-5. 在Properties tab,你可在orclpasswordattribute域查看并修改密码.
-6. 改完后点击Apply.

Puber

[B]6.3. Changing the Character Set of the Metadata Repository[/B]
先按普通的Oracle Database更改Metadata Repository滴CharacterSet滴(这在itpub中查找一下,会找到很多.建议之前先去www.eygle.com去看一篇关于数据库字符集的文章.)
改完后,再按以下步骤配置middle-tier和infrastructure.
-1. 修改所有访问此Metadata Repository滴Database Access Descriptors(DADs),使用新的database character set.
--1.1 运行Oracle Application Server Control Console,打开middle-tier instance home page.
--1.2 在System Component段,点击HTTP_Server.
--1.3 在HTTP_Server home page,点击Adminstration.
--1.4 在HTTP_Server Administration page, 选择"PL/SQL Properties". 将会打开mod_plsql Service page.
--1.5 在DADs段,点击你想配置的DAD的名称.将会出现Edit DAD page.
--1.6 在NLS Language域,输入新的character set(与Metadata Repository一致).
--1.7 点击OK.
--1.8 重复以上步骤去更改其它访问些Metadata Repository滴DADs.


-2. 在$ORACLE_HOME/ultrasearch/admin目录下有两个SQL语句: wk0prefcheck.sql和wk0idxcheck.sql.运行他们,则可重新配置Ultra Search index.
这两个SQL的作用如下:
--2.1 wk0prefcheck.sql is invoked under wksys to reconfigure default cache character set and index preference.

--2.2 wk0idxcheck.sql is needed for reconfiguring instance(s) created before database character set change, e.g., the default instance. This script must be invoked by the instance owner and wk0prefcheck.sql must be run first as it depends on reconfigured default setting generated by wk0prefcheck.sql.

--2.3 运行wk0idxcheck.sql会drop并recreate用于Ultra Search的Oracle Text index. So if there are already data source indexed then user must force recrawl all of the data sources.

--2.4 wk0idxcheck.sql只能每个instance运行一次.如果有两个名称为"inst1"和"inst2"的instances,分别属于"owner1"和"owner2",则相应地应该运行wk0idxcheck.sql两次.一次处理"owner1",另一次处理"owner2".

Puber

[B]6.4 Renaming and Relocating Datafiles[/B]
这几天被一patch整个半死,下班前来轻松一下.[/COLOR]
关于本段,不多看.如果Metadata Repository是缺省安装的话,其数据文件滴目录是$ORACLE_HOME/oradata/SID.
至于说redirect和rename data files.这个和普通的数据库没啥两样.
只需先停止所有middle-tier intances和infrastructure instance. 还有Oracle Application Server Control Console,OPMN-managed processes.
总之,所有使用到Metadata Repository滴应用全停止.
下面就是标准滴Oracle database 操作了.(最好操作前后,对Metadata Repository做个full backup).
处理完了再按Metadata Repository --> Infrastructure Instance --> Middle_tier Instances这个顺序来启动整个系统.

Puber

[B]6.5 Specifying Segment Space Management When Creating Tablespaces[/B]
这段讲滴是Metadata Repository在使用LMT的tablespaces时,究竟该用[B]MANUAL[/B]还是[B]AUTO[/B]模式的SEGMENT SPACE MANAGEMENT.
除了以下三个tablespaces用AUTO之外,其它的tablespaces都用MANUAL:
■ OLTS_ATTRSTORE
■ OLTS_CT_STORE
■ OLTS_DEFAULT
如果打算自已创建tablespaces,并将其它metadata repository的dump file中导入到其中,则需遵守此规则.
(偶认为,Metadata Repository没有什么可能产生大量workload的contention,全用ASSM就行了.没啥大不了).
但文档上又强调,其它tablespaces不能用ASSM.昏ing.



又结束了一章节.这一chapter中的password相关比较有用.

Puber

[B]A.3 Changing the ias_admin Password[/B][/COLOR]
[B]Changing the Password Using the emctl Command-Line Tool[/B]
To change the ias_admin user password using a command-line tool:
-1. Enter the following command in the Oracle home of your Oracle Application
Server installation:

ORACLE_HOME/bin/emctl set password old_password new_password[/COLOR]
For example:
ORACLE_HOME/bin/emctl set password m5b8r5 b8s0d9[/COLOR]

-2. Restart the Application Server Control Console.
Restart the Application Server Control Console
emctl stop iasconsole
emctl start iasconsole
[/COLOR]