- 浏览: 1000969 次
- 性别:
- 来自: 北京
文章分类
- 全部博客 (529)
- 服务器 (8)
- jsp (1)
- java (6)
- AIX (1)
- solaris (3)
- linux学习 (53)
- javaScript (2)
- hibernate (1)
- 数据库 (74)
- sql语句 (8)
- oracle 学习 (75)
- oracle 案例 (42)
- oracle 管理 (42)
- Oracle RAC (27)
- oracle data guard (12)
- oracle 参数讲解 (14)
- Oracle 字符集 (8)
- oracle性能调优 (24)
- oracle备份与恢复 (12)
- oracle Tablespace (9)
- oracle性能诊断艺术 (1)
- oracle 11g学习 (5)
- oracle streams (1)
- oracle upgrade and downgrade (4)
- db2学习 (13)
- db2命令学习 (2)
- mysql (28)
- sql server (30)
- sql server 2008 (0)
- 工具 (10)
- 操作系统 (3)
- c++ (1)
- stock (1)
- 生活 (5)
- HADOOP (2)
最新评论
-
massjcy:
...
如何将ubuntu文件夹中文名改为英文 -
skypiea:
谢谢。。。
终于解决了。。。
Oracle 10.2.0.4(5)EM不能启动的解决方案(Patch 8350262) -
qwe_rt:
引用vi /etc/sysconfig/network 请问 ...
Linux操作系统下配置静态IP上网 -
liuqiang:
sudo killall -9 apache2
ps 和 kill 命令详解 -
dazuiba:
引用*绝杀 kill -9 PID 当使用此命令时,一定要通过 ...
ps 和 kill 命令详解
What to do when Enterprise Manager is not able to connect to
the database instance (ORA-28001)
the database instance (ORA-28001)
If you are trying to connect to the Oracle enterprise Manger and you get the following errors:
Enterprise Manager is not able to connect to the database instance.
And in t
Enterprise Manager is not able to connect to the database instance.
Enterprise Manager is not able to connect to the database instance.
And in the “Agent connection to instance” section:
Status: Failed
Details: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)
Details: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)
One of the reasons could be that the password for the SYSMAN user is expired. However, changing the password alone will not solve this issue. Several additional steps are required in order to make Oracle Enterprise Manager connect:
Before you start: Verify that ORACLE_HOME, ORACLE_SID environment variables are set. – If not, set them using as environment variables or open a command line and type SET ORACLE_SID=<The database SID>
1. Stop the dbconsole: emctl stop dbconsole (dos and Unix) or using the windows services stop the OrcleDBConsole<The database SID>.
2. Connect to the database as a user with DBA privilege with SQL*Plus
and run the following command:
and run the following command:
alter user sysman identified by <the new password> ;
3. Verify that the new password works
SQL> connect sysman/<the new password>
SQL> connect sysman/<the new password>
4. Go to ORACLE_HOME/<HostName_SID>/sysman/config and save a backup of the emoms.properties file.
a) Open the file emoms.properties and search for:
oracle.sysman.eml.mntr.emdRepPwd= <some encrypted value>
oracle.sysman.eml.mntr.emdRepPwd= <some encrypted value>
Replace the encrypted value with the new password value
b) Search for oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
and change TRUE to FALSE
and change TRUE to FALSE
c) Save and close emoms.properties
5. Restart the dbconsole:
emctl start dbconsole (dos and Unix) or using the windows services start the OrcleDBConsole<The database SID>.
6. Open emoms.properties again and Search for:
a)oracle.sysman.eml.mntr.emdRepPwd=
verify that the password is encrypted
a)oracle.sysman.eml.mntr.emdRepPwd=
verify that the password is encrypted
b) oracle.sysman.eml.mntr.emdRepPwdEncrypted=
verify that the value is set to TRUE
verify that the value is set to TRUE
7. Refresh Oracle Enterprise Manager
发表评论
-
sys.dbms_transaction.local_transaction_id出现的问题
2012-07-20 11:54 3288何時會觸發DBMS_TRANSACTION.LOCAL_TRA ... -
ORACLE 11GR2 OEM配置出错解决
2012-07-14 19:21 5079错误描述如下: 2012-7-14 18:23:11 ... -
ORA11G ORA-00845 错误
2012-06-26 13:39 829Oracle 11g的Linux版本在修改了MEMORY_TA ... -
oracle.net.common.NetGetEnv.getDNSDomain
2012-06-07 01:48 1140今天安装LINUX AS 4和ORACLE 10.2,安装成功 ... -
Oracle 10.2.0.4(5)EM不能启动的解决方案(Patch 8350262)
2011-05-20 17:29 6958报错信息如下: 2011-03-09 11:06:10 Th ... -
Oracle HowTo:如何在Linux上扩展SGA超过1.7G
2011-03-24 01:28 920今天一台Linux服务器扩展了一下内存,达到4G,开发的人自己 ... -
error while loading shared libraries: libclntsh.so.10.1: cannot open shared 问题解决
2011-01-21 16:23 119921.运行csscan命令显示如下错误 [oracle@rac ... -
“Error in invoking target ‘client_sharedlib’ of makefile ‘/home/oracle/oracle/pr
2011-01-13 17:35 11892今天同事在安装oracle的时候总是报这个错误: &qu ... -
如何处理Oracle中的坏块[ZT]
2010-12-19 21:56 1218一. 什么是数据库的坏 ... -
bug 7716219 hash group by显示消耗大量的temp 表空间
2010-12-07 17:47 2141SQL> set autotrace traceonly ... -
ORA-08102: TRYING TO MANIPULATE A JOB IN DBA_JOBS [ID 1036858.6]
2010-12-03 23:52 1256***Checked for relevance on 17- ... -
ORA-14074: partition bound must collate higher than that of the last partition
2010-10-09 16:26 36461. 创建分区表 create table zhanglei ... -
ora-12560问题解决
2010-09-16 11:30 15861.监听服务没有起起来 ... -
ORA-20000故障排除手记
2010-09-02 01:43 23461、发现故障。 在Oracle10.2.0.1的aler ... -
ORA-17502 与 ORA-15173 错误解决
2010-05-21 17:27 3945用rman恢复spfile时,报错误如下: RM ... -
Dropping A Disk From ASM Diskgroup Does Not Remove It From v$ASM_DISK
2010-05-21 10:42 1488Applies to: Oracle Serv ... -
ORA-19599 When backing up an archivelog that is corrupt [ID 461239.1]
2010-05-13 13:56 2666Applies to: Oracle Server - E ... -
ASMCMD fails to start on module libnnz10.so, permission denied
2010-05-13 01:14 2526ASMCMD fails to start on modu ... -
Errors ORA-00600 [kclchkblk_4] and ORA-00600 [2662] After Recovery of Datab
2010-05-12 15:45 1725Applies to: Oracle Server - E ... -
ORA-29701: unable to connect to Cluster Manager
2010-04-15 14:55 3888今天启动ASM报错了,ORA-29701: unable ...
相关推荐
一种方法:先解压缩patch 8350262,然后把解压缩后的文件(解压缩后根目录下的文件及文件夹零散拷出来,不要拷目录)拷到oracle安装目录下的Opatch下,然后运行cmd>opatch apply,如果提示没有oracle home,执行set ...
#!/bin/bash # chkconfig: 345 99 10 # description: Startup Script for Oracle...su - $ORA_OWNR -c "$ORACLE_HOME/bin/emctl start dbconsole" #su - $ORA_OWNR -c "$ORACLE_HOME/bin/isqlplusctrl start" echo "OK
$ emctl start dbconsole 使用 SRVCTL 启动/停止所有实例 启动/停止所有实例及其启用的服务。我只是觉得有意思就把此步骤作为关闭所有实例的一种方法加进来了! $ srvctl start database -d orcl $ srvctl ...
这些遇到问题的解决办法使用过,但是很久没折腾就忘记了,今天把这些问题和解决方法记录在此。 1、网络环境变化导致无法启动 这个问题的现象是无法启动OEM。使用命令行如下: 代码如下: C:/Users/Administrator>set ...
mv 11.txt /usr/ 移动 rm -rf tt.txt 删除不提示 rm tt.txt删除带提示 ifconfig 查看IP信息 export PATH=$PATH:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/opt /bin:/usr/i686-pc-linux-gnu/...
控制器emctl:开启、关闭OEM平台,默认端口1158 [oracle@dbserver ~]$ lsnrctl status [oracle@dbserver ~]$ emctl stop dbconsole [oracle@dbserver ~]$ dbshut $ORACLE_HOME [oracle@dbserver ~]$ dbstart $...
oracle10g em 重新配置 emca -repos drop emca -repos create 建议 emca -repos recreate (当时用create 出现莫名错误,但没注意错误日志) emca -config dbcontrol db ...emctl start dbconsole
。Oracle Enterprise Manager 12c 提 供的云服务作为一项开创性的技术,通过满足各种多租户架构的资源池模型,让企业用户自 助部署 IT 资源。数据库即服务 (DBaaS) 是一种范式,最终用户(DBA、开发人员、QA 工 ...
【OEM】OEM安装维护.pdf【OEM】OEM安装维护.pdf【OEM】OEM安装维护.pdf
ORACLE EMCTL,默认的端口号为1158; Oracle XDB( XML 数据库),默认的端口号为8080; Oracle XDB FTP服务,默认的端口号为2100; MS SQL*SERVER数据库server,默认的端口号为1433/tcp 1433/udp; MS SQL*SERVER...
Enterprise Manage 配置成功,出现以下警告: 启动 Database Control 时出错。请执行以下命令。 1)将环境变量 ORACLE_UNQNAME设置为...2)C:\app\Administrator\product\11.2.0\dbhome_1\bin\emctl.bat start dbconsole
在很多情况下,或无法使用dbca工具的时候,我们需要手动来删除数据库。对此,可以借助drop database命令来实现,下面的描述中给出... $ emctl stop dbconsole 2.获得数据文件,日志文件及控制文件的相关信息,