Oracle cloud control 12c 如何修改sysman密码

简介:     前阵子在虚拟机部署了Oracle Cloud Control 12c,事别几日,竟然忘记了登陆密码。主要是因为现在的Oracle有关的Software比之前提供更强的安全机制。
    前阵子在虚拟机部署了Oracle Cloud Control 12c,事别几日,竟然忘记了登陆密码。主要是因为现在的Oracle有关的Software比之前提供更强的安全机制。什么简单的"oracle"之类的pwd不再支持了。这不过一阵子就搞忘了。这年头的,账户多,密码多,就是米不多,哈哈。。。下面说说其解决办法吧。

一、emctl命令
emctl命令想必大家都见过,DB console时代经常会用到,现在功能是越来越强大了,下面仅仅列出有关修改pwd的部分
emctl config oms -change_repos_pwd [-old_pwd <old_pwd>] [-new_pwd <new_pwd>] [-use_sys_pwd [-sys_pwd <sys_pwd>]] 
Note: Steps in changing Enterprise Manager Root (SYSMAN) password are:
      1) Stop all the OMSs using 'emctl stop oms'
      2) Run 'emctl config oms -change_repos_pwd' on one of the OMS
      3a) Restart AdminServer and all the OMSs using 'emctl stop oms -all' and 'emctl start oms'
      3b) If BI Publisher is installed, restart the BI Publisher managed server(s) named 'BIP####'

二、修改步骤
下面简要列出一下其修改步骤:
1) Stop OMS (leaving the Admin Server up)
2) Modify SYSMAN password
3) Stop all OMS components
4) Start OMS
5) Login to Oracle EMCC-12c with the new password

三、修改sysman登陆密码
#下面是其具体演示
[oracle@oel63 ~]$ $OMS_HOME/bin/emctl stop oms 
Oracle Enterprise Manager Cloud Control 12c Release 3  
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
Oracle Management Server is Down

[oracle@oel63 ~]$ $OMS_HOME/bin/emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd oracle -new_pwd Oracle123
Oracle Enterprise Manager Cloud Control 12c Release 3  
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.

Changing passwords in backend ... 
Passwords changed in backend successfully.
Updating repository password in Credential Store...
Successfully updated Repository password in Credential Store.
Restart all the OMSs using 'emctl stop oms -all' and 'emctl start oms'.
Successfully changed repository password.

[oracle@oel63 ~]$ $OMS_HOME/bin/emctl stop oms -all
Oracle Enterprise Manager Cloud Control 12c Release 3  
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Already Stopped
AdminServer Successfully Stopped
Oracle Management Server is Down

[oracle@oel63 ~]$ $OMS_HOME/bin/emctl start oms
Oracle Enterprise Manager Cloud Control 12c Release 3  
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
Starting Oracle Management Server...
>Starting WebTier...
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up

#Author : Leshami
#Blog   : http://blog.csdn.net/leshami
#再次登陆OK

四、有关CC 12c密码修改Doc
12c Cloud Control: How to Modify the Password for SYSMAN and other Enterprise Manager Users at the OMS Level and Repository Database? (Doc ID 1365930.1) To BottomTo Bottom
Modified:14-Jan-2014Type:HOWTO
Language:

Rate this document Email link to this document Open document in new window Printable Page

In this Document
Goal
Solution
  If the current SYSMAN password is known
  If the current SYSMAN password is unknown
 
References
APPLIES TO:

Enterprise Manager Base Platform - Version 12.1.0.1.0 and later
Information in this document applies to any platform.
GOAL

This article provides steps for modifying the password of SYSMAN and other Enterprise Manager users at the OMS/WLS level and the Repository database in a Cloud Control setup. 
Simply changing the password in the repository database is not sufficient as the password is also stored in the WLS credential store. The OMS uses sysman account to login into the repository database and if there is a mis-match in the password at the database level and the OMS configuration, the OMS cannot start and function properly.

For steps to follow in the earlier Enterprise Manager versions, refer to:
Note 270516.1: How to Change the Password of SYSMAN User in 10g and 11g Grid Control?

Note:

From 12c onwards, directly modifying the password for sysman or any other repository user at the Repository Database is not recommended.
Hence, ensure that the passwords are changed only using one of the below listed methods.
SOLUTION

If the current SYSMAN password is known

1. Stop all the OMS:

cd <OMS_HOME>/bin
emctl stop oms
Execute the same command on all the OMS machines including the primary OMS machine. Do not include '-all' as the Admin Server needs to be up during this operation.

2. Modify the SYSMAN password:

cd <OMS_HOME>/bin
emctl config oms -change_repos_pwd

Note: 

- The above command will prompt you for the current password of the SYSMAN user and the new password.
- The password will be modified at the Repository Database as well as the WLS Credential store and the monitoring credentials for the 'OMS and Repository' target.
- Along with the SYSMAN password, this command will modify the password for the EM users (SYSMAN_MDS, BIP, SYSMAN_OPSS, SYSMAN_APM, SYSMAN_RO) created in the Repository Database.

Example output:

emctl config oms -change_repos_pwd
Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
Enter Repository User's Current Password :
Enter Repository User's New Password :

Changing passwords in backend ...
Passwords changed in backend successfully.
Updating repository password in Credential Store...
Successfully updated Repository password in Credential Store.
Restart all the OMSs using 'emctl stop oms -all' and 'emctl start oms'.

Successfully changed repository password.

3. Stop the Admin server on the primary OMS machine and re-start all the OMS:

cd <OMS_HOME>/bin
emctl stop oms -all
emctl start oms
If the current SYSMAN password is unknown

1. Stop all the OMS:

cd <OMS_HOME>/bin
emctl stop oms
Execute the same command on the primary OMS machine as well. Do not include '-all' as the Admin Server needs to be up during this operation.

If the version of OMS is 12.1.0.1 and if the password has been manually changed at the Database level, apply the Patch 13697830 to the OMS Home and then run the command below to get the password updated in all configurations.
 
2. Modify the SYSMAN password:

cd <OMS_HOME>/bin
emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd <sys user password> -new_pwd <new sysman password>
Note:

- The '-use_sys_pwd' is used to connect to the database as a SYS user and modify the sysman password in the Repository database.
-  The current sysman password is not prompted for and only the new password needs to be entered. This will allow the reset of the old password to the new password entered.
- The password will be modified at the Repository Database as well as the WLS Credential store and the monitoring credentials for the 'OMS and Repository' target.
- Along with the SYSMAN password, this command will modify the password for the EM users (SYSMAN_MDS, BIP, SYSMAN_OPSS, SYSMAN_APM, SYSMAN_RO) created in the Repository Database.

Example output:

emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd oracle123 -new_pwd oracle12
Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.

Changing passwords in backend ...
Passwords changed in backend successfully.
Updating repository password in Credential Store...
Successfully updated Repository password in Credential Store.
Restart all the OMSs using 'emctl stop oms -all' and 'emctl start oms'.
Successfully changed repository password.

3. Stop the Admin server on the primary OMS machine and re-start all the OMS:


cd <OMS_HOME>/bin
emctl stop oms -all
emctl start oms

Reference:

Oracle Enterprise Manager Cloud Control Administrator's Guide 12c Release 1 (12.1.0.2)

Chapter 13.8.1 Changing the SYSMAN and MGMT_VIEW Passwords

Known Issues

1. Problem: Modifying the sysman password fails with "java.io.IOException":

cd <OMS_HOME>/bin
emctl config oms -change_repos_pwd
Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
Enter Repository User's Current Password :
Enter Repository User's New Password :
java.io.IOException
Error occurred. Check the log
Cause: The above error occurs if the Admin server is not running when the sysman password is being modified.
Solution: As advised in the sections above, the Admin Server needs to be up and running when the sysman password is being modified. So, the OMS should not be stopped using 'emctl stop oms -all'.

cd <OMS_HOME>/bin
emctl start oms
emctl stop oms
emctl config oms -change_repos_pwd
REFERENCES

NOTE:1511014.1 - 12c: After changing the SYSMAN password directly into the DB, OMS status shows "Connection to the repository failed. Verify that the repository connection information provided is correct"


鹏城DBA总群

目录
相关文章
|
6月前
|
存储 Oracle 关系型数据库
Oracle 12c支持哪些数据类型?
【7月更文挑战第20天】Oracle 12c支持哪些数据类型?
121 2
|
6月前
|
SQL Oracle 关系型数据库
Oracle 12c有哪些新特性?
【7月更文挑战第20天】Oracle 12c有哪些新特性?
90 2
|
8月前
|
监控 Oracle 关系型数据库
Oracle 12c的Adaptive执行计划:数据的“聪明导航员”
【4月更文挑战第19天】Oracle 12c的Adaptive执行计划是数据库查询的智能优化工具,能根据实际运行情况动态调整执行策略。它像一个聪明的导航系统,不仅生成初始执行计划,还能实时监控并适应统计信息和资源变化,例如自动切换索引或调整并行度。此外,它支持自适应连接和统计信息收集,提升处理复杂查询和变化数据环境的能力。数据管理员应充分利用这一特性来优化查询性能和用户体验。
|
8月前
|
存储 NoSQL Oracle
Oracle 12c的内存列存储:数据的“闪电侠”
【4月更文挑战第19天】Oracle 12c的内存列存储以超高速度革新数据处理,结合列存储与内存技术,实现快速查询与压缩。它支持向量化查询和并行处理,提升效率,但需合理配置以平衡系统资源。作为数据管理员,应善用此功能,适应业务需求和技术发展。
|
8月前
|
存储 Oracle 关系型数据库
Oracle 12c的多重索引:数据的“多维导航仪”
【4月更文挑战第19天】Oracle 12c的多重索引提升数据查询效率,如同多维导航仪。在同一表上创建针对不同列的多个索引,加速检索过程。虽然过多索引会增加存储和维护成本,但合理选择和使用索引策略,结合位图、函数索引等高级特性,能优化查询,应对复杂场景。数据管理员应善用这些工具,根据需求进行索引管理,支持企业数据分析。
|
8月前
|
存储 Oracle 安全
Oracle 12c的不可见字段:数据的“隐形斗篷”
【4月更文挑战第19天】Oracle 12c引入了不可见字段,这是一种隐藏数据列的特性,用于增强数据安全性和实现业务逻辑。不可见字段在常规查询中不显示,但参与数据操作,适合存储敏感信息或内部元数据。创建时只需在列定义中指定“INVISIBLE”属性。虽然有其限制,如特定查询可能暴露,但正确使用能有效提升数据安全性。了解和利用这一功能对数据管理员至关重要。
|
8月前
|
运维 Oracle 安全
Oracle的三重奏:密码文件、警告文件与跟踪文件
【4月更文挑战第19天】Oracle数据库的三大守护者:密码文件保护系统免受未经授权访问,如同宝藏的“密码锁”;警告文件似“哨兵”,记录错误信息,助于及时解决问题;跟踪文件扮演“侦探”角色,详尽记录操作,便于性能优化和故障排查。这三份文件共同确保数据王国的安全与稳定。作为管理员,重视并善用它们是关键。
|
8月前
|
Oracle 关系型数据库 数据安全/隐私保护
oracle 19c 密码字段
oracle 19c 密码字段
72 0
|
8月前
|
SQL Oracle 关系型数据库
Oracle 12c的TOP N语句:数据排名的“快速通道”
【4月更文挑战第19天】Oracle 12c的TOP N语句是用于快速获取数据集排名前N的记录的SQL查询方法,特别适合寻找最具代表性的数据。通过指定排序条件和数量,TOP N能高效筛选出所需信息,例如最高销售额产品或最大访问量网页。在Oracle 12c中,查询优化器对TOP N查询进行了优化,保证快速返回结果,并提供丰富的排序和过滤选项。基本用法如`SELECT ... ORDER BY ... FETCH FIRST N ROWS ONLY`,还可结合`OFFSET`进行分页查询或用`WITH TIES`保持结果完整性。掌握TOP N语句能提升数据分析效率,助力企业决策。
|
8月前
|
存储 Oracle 关系型数据库
Oracle 12c的临时UNDO:数据的“临时保镖”
【4月更文挑战第19天】Oracle 12c引入的临时UNDO为数据安全提供新保障。它为临时操作和特定事务提供独立UNDO空间,避免共享UNDO带来的性能瓶颈和管理复杂性。临时UNDO随事务开始分配,记录修改历史,事务结束后自动释放。优点包括提高性能、简化管理及保证数据一致性。但需注意手动配置、监控和优化,以防长时间占用资源。了解其工作原理和最佳实践是提升数据库性能的关键。

热门文章

最新文章

推荐镜像

更多