主题: Problem: EMCA : Invalid DBSNMP password [ ORA-01034: ORACLE not available ]
Cause
1. Incorrect settings of environment variables like ORACLE_HOME, PATH
2. Incorrect value of ORACLE_HOME in $ORACLE_HOME/bin/emca script
3. listener.ora contains SID in Upper Case (TEST) and SID while running emca is provided as Lower Case (test)
4. Owner of the database ORACLE_HOME is not a member of DBA Group
Solution
1. Verify ORACLE_HOME and PATH environment variables do not have a trailing "/"
for example :
ORACLE_HOME=/u00/oracle/product/10.2.0/db_1/
Remove appended "/" if any
ORACLE_HOME=/u00/oracle/product/10.2.0/db_1
2. Verify ORACLE_HOME is set correctly in $ORACLE_HOME/bin/emca script
Make sure the ORACLE_HOME path is correct (could be incorrect for a cloned DB
and there is no trailing "/")
for example :
ORACLE_HOME=/u00/oracle/product/10.2.0/db_1/
Remove appended "/" if any
ORACLE_HOME=/u00/oracle/product/10.2.0/db_1
3. Verify the value of SID_NAME in listener.ora file. If it is in Upper Case (TEST).
When executing the EMCA command, provide the SID in same case (TEST and not test).
for example :
$ ./emca -config dbcontrol db -repos create
STARTED EMCA at Oct 31, 2006 10:36:21 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: TEST
4. This problem can occur when the owner of the Database $ORACLE_HOME is no longer a member of the DBA Group. This lack of permissions prevents connections to the database via the bequeath adapter.
- Assign the DBA Group back to the OS user that owns the database $ORACLE_HOME
- Re-run the EMCA commands
阅读(1454) | 评论(0) | 转发(0) |
