EMCA Failing with Invalid Password for Dbsnmp
Error:
Running: <ORACLE_HOME>/bin/emca -config dbcontrol db -repos create
fails with:
Invalid username/password.
Password for DBSNMP user:
A sqlplus connenction with the same user and password works correctly.
SQL> connect dbsnmp/<password>
Connected.
Cause:
There are (at least) 2 possible causes:
1) The password contains special characters or local country character set characters
2) The ORACLE_HOME has a trailing slash.
Solution:
1. Wrap the password in double quotes " " (ie. if the password is dbnmp, use in emca input "dbsnmp")
or
2) Verify the ORACLE_HOME value to match the one in oratab:
ie.:
echo $ORACLE_HOME
/d01/oracle/product/10.2.0/db_1/ -> notice the extra trailing slash /
remove the training slash from ORACLE_HOME
set ORACLE_HOME=/d01/oracle/product/10.2.0/db_1
or
export ORACLE_HOME=/d01/oracle/product/10.2.0/db_1
and retry the EMCA command.
Reference metalink Doc ID 1264024.1
Error:
Running: <ORACLE_HOME>/bin/emca -config dbcontrol db -repos create
fails with:
Invalid username/password.
Password for DBSNMP user:
A sqlplus connenction with the same user and password works correctly.
SQL> connect dbsnmp/<password>
Connected.
Cause:
There are (at least) 2 possible causes:
1) The password contains special characters or local country character set characters
2) The ORACLE_HOME has a trailing slash.
Solution:
1. Wrap the password in double quotes " " (ie. if the password is dbnmp, use in emca input "dbsnmp")
or
2) Verify the ORACLE_HOME value to match the one in oratab:
ie.:
echo $ORACLE_HOME
/d01/oracle/product/10.2.0/db_1/ -> notice the extra trailing slash /
remove the training slash from ORACLE_HOME
set ORACLE_HOME=/d01/oracle/product/10.2.0/db_1
or
export ORACLE_HOME=/d01/oracle/product/10.2.0/db_1
and retry the EMCA command.
Reference metalink Doc ID 1264024.1
No comments:
Post a Comment