Tuesday, April 12, 2016

EMCA Failing with Invalid Password for Dbsnmp

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

No comments:

Post a Comment