04 February 2014

ORA-01017 in emagent.trc

Error

ORA-1017 errors in emagent.trc point usually mean that Grid metric doesn't have good connection string.

 Symptoms:
SQL = "                                                                   OCISessionGet"...
LOGIN = oracle/@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521))(CONNECT_DATA=(SID=DBNAME)))
2014-01-27 10:54:56,633 Thread-2424322368 ERROR vpxoci: ORA-01017: invalid username/password; logon denied
2014-01-27 10:54:56,633 Thread-2424322368 WARN  vpxoci: Login 0x110561f0 failed, error=ORA-01017: invalid username/password; logon denied
2014-01-27 10:54:56,633 Thread-2424322368 ERROR engine: [rac_database,DBNAME,SQLUDMSTR] : nmeegd_GetMetricData failed : ORA-01017: invalid username/password; logon denied

Cause

  • Preferential credential for databases are not correct. Check in Preferences/Preferred Credentials

Fix

  • User Defined metrics don't have correct.
    • Go to the target, i.e the database instance DBNAME, as in the emagent.trc
    • Click "User-Defined Metrics"
    • Edit Definition/Database Credentials - correct the username/password

// posted by Tatjana (Tanja) Kane @ 2/04/2014 0 comments

This page is powered by Blogger. Isn't yours?