oracle

简介: 1、Schemas oracle ebs 系统下的schema可以被分为如下几类: 1、所有数据库(不论是否是ebs 数据库)都有的schema:如SYS,SYSTEM 2、oracle ebs组件特有的schema:如 APPLSYSPUB,APPLS...

1、Schemas

oracle ebs 系统下的schema可以被分为如下几类:

1、所有数据库(不论是否是ebs 数据库)都有的schema:如SYS,SYSTEM

2、oracle ebs组件特有的schema:如 APPLSYSPUB,APPLSYS,APPS

3、ebs单个产品对应的schema:如AR,AP,GL,ZX等

4、第三方或者数据库可选特性的schema:如CTXSYS,MDSYS,ORDSYS,SCOTT


2、密码管理

有个命令行工具:FNDCPASS 和 AFPASSWD ,这两个密令都可以改变注册到ebs表里的密码 和 数据库内的方案的密码。

注意:

1、改变schema的面貌前,ebs系统必须关闭。

2、如果ebs user的密码被改变了,相关用户就不能登录了。

3、在任何密码修改之前,FND_USER 和 FND_ORACLE_USERID表应该备份。

修改APPLSYS密码步骤:

Whenever you use FNDCPASS to change the APPLSYS password, you must also perform the following actions. Important: These steps must be carried out on the run file system:
1. Shut down the application tier services using the   $INST_TOP/admin/scripts/adstpall.sh script.


2. Change the APPLSYS password, as described in the previous section.


3. Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh  script. Do not start any other application tier services.


4. Change the "apps" password in WLS Datasource as follows:

1. Log in to WLS Administration Console.

2. Click Lock & Edit in Change Center.

3. In the Domain Structure tree, expand Services, then select Data Sources.

4. On the "Summary of JDBC Data Sources" page, select EBSDataSource.

5. On the "Settings for EBSDataSource" page, select the Connection Pool tab.

6. Enter the new password in the "Password" field.

7. Enter the new password in the "Confirm Password" field.

8. Click Save.

9. Click Activate Changes in Change Center

5. Start all the application tier services using the$INST_TOP/admin/scripts/adstrtal.sh script.
6. Verify the WLS Datastore changes as follows:

1. Log in to WLS Administration Console.

2. In the Domain Structure tree, expand Services, then select Data Sources.

3. On the "Summary of JDBC Data Sources" page, select EBSDataSource.

4. On the "Settings for EBSDataSource" page, select Monitoring > Testing.

5. Select "oacore_server1".

6. Click Test DataSource

7. Look for the message "Test of EBSDataSource on server oacore_server1 wassuccessful".

Important: Steps 4, 5 and 6 are only applicable when changing theAPPLSYS password. They are not applicable when changing passwords for product schemas or the SYSTEM schema.








相关文章
|
9月前
|
SQL Oracle 关系型数据库
|
消息中间件 NoSQL Oracle
Oracle 惨不忍睹!
Oracle 惨不忍睹!
|
Oracle 关系型数据库
oracle练习03
oracle练习03
75 0
|
Oracle 关系型数据库 数据库
|
Oracle 关系型数据库 数据库
|
Oracle 关系型数据库 数据库
|
Oracle 关系型数据库 数据库
|
Oracle 关系型数据库
|
SQL 存储 监控
|
SQL Oracle 关系型数据库