EMCA fails with error "ORA-01017: invalid username/password; logon denied"
来源:互联网 发布:我是直播歌手网络赛 编辑:程序博客网 时间:2024/05/17 07:50
Creation of dbcontrol repository fails when execute
With error:
Some of the possible reasons may be:
1) Listener port 1521 provided is incorrect. Provide the correct port.
2) Listener is not up. Start the Listener.
3) Database service <DBSID> is not registered with listener. Register the database service.
4) Listener is up on physical host and ORACLE_HOSTNAME environment variable is set to virtual host. Unset ORACLE_HOSTNAME environment variable.
5) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=<virtual host>.
6) /etc/hosts does not have correct entry for hostname.
In emca_.log file:
CONFIG: isLocalConnectionRequired: true
Sep 24, 2014 9:30:56 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Sep 24, 2014 9:30:56 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: , oracleHome: /u01/app/oracle/product/11.2.0.3/db_1, and user: SYS
Sep 24, 2014 9:30:56 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Sep 24, 2014 9:30:56 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: ORA-01017: invalid username/password; logon denied
Sep 24, 2014 9:30:56 AM oracle.sysman.emcp.EMConfig perform
SEVERE:
Database connection through listener failed. Fix the error and run EM Configuration Assistant again.
Some of the possible reasons may be:
1) Listener port 1521 provided is incorrect. Provide the correct port.
2) Listener is not up. Start the Listener.
3) Database service is not registered with listener. Register the database service.
4) Listener is up on physical host and ORACLE_HOSTNAME environment variable is set to virtual host. Unset ORACLE_HOSTNAME environment variable.
5) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=.
6) /etc/hosts does not have correct entry for hostname.
Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/emca_2014_09_24_09_26_58.log for more details.
Sep 24, 2014 9:30:56 AM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException:
Database connection through listener failed. Fix the error and run EM Configuration Assistant again.
Some of the possible reasons may be:
1) Listener port 1521 provided is incorrect. Provide the correct port.
2) Listener is not up. Start the Listener.
3) Database service is not registered with listener. Register the database service.
4) Listener is up on physical host and ORACLE_HOSTNAME environment variable is set to virtual host. Unset ORACLE_HOSTNAME environment variable.
5) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=.
6) /etc/hosts does not have correct entry for hostname.
Cause
SYS password is invalid.
Solution
1) drop existing dbcontrol
$ emca -deconfig dbcontrol db -repos drop
2) reset SYS password (also in password file, if using)
3) create the dbcontrol
$ emca -config dbcontrol -repos create
尝试上述步骤无效后,发现remote_login_passwordfile参数在之前的测试中被修改了,改回后终于成功
SQL> show parameter remote
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_dependencies_mode string TIMESTAMP
remote_listener string
remote_login_passwordfile string NONE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
result_cache_remote_expiration integer 0
SQL> alter system set remote_login_passwordfile='exclusive';
alter system set remote_login_passwordfile='exclusive'
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
SQL> alter system set remote_login_passwordfile='exclusive' scope=spfile;
System altered.
SQL> shutdown immediate
- EMCA fails with error "ORA-01017: invalid username/password; logon denied"
- ORA-01017: invalid username /password;logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017: invalid username /password;logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017 invalid username/password; logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017:invalid username/password; logon denied
- ORA-01017 invalid username/password;logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-0107 invalid username/password;logon denied
- 解决方法:ORA-01017: invalid username/password; logon denied错误
- Cannot create PoolableConnectionFactory (ORA-01017: invalid username/password; logon denied
- java.sql.SQLException: ORA-01017: invalid username/password; logon denied
- ORA-01017 invalid username/password;logon denied (密码丢失解决方案)
- ORA-01017 invalid username/password;logon denied" (密码丢失解决方案)
- 求斐波那契数列
- 程序员必读经典书籍 (转)
- Linux Root密码重置
- code search
- Mac终端 常用命令
- EMCA fails with error "ORA-01017: invalid username/password; logon denied"
- 使用NSClassFromString
- 近期qt/cocos笔记
- SizeClass和AutoLayout
- java 多线程的发展史
- Redmine艰辛安装过程和邮件配置
- Word解除文档保护
- 做一个可删除的淘宝购物页面
- Spring配置Quartz例子