Sunday, November 27, 2016

Non-Ignorable Error: ORA-01917: user or role 'ODS' does not exist

2016-11-27 15:56:27.339 INCIDENT_ERROR rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: Failed to execute method: Excepton: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:510) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLSyntaxErrorException: ORA-01917: user or role 'ODS' does not exist at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:299) at oracle.ias.version.SchemaVersion.grantRegistryAccess(SchemaVersion.java:2688) at oracle.ias.version.SchemaVersion.grantRegistryAccessToComponent(SchemaVersion.java:2632) at oracle.ias.version.SchemaVersionUtil.utilSetComponentValid(SchemaVersionUtil.java:419) ... 6 more 2016-11-27 15:56:27.341 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: ORA-01917: user or role 'ODS' does not exist Solution : orpidm@pidmdb01:/u01pd/DB/oracle/product/12.1.0/dbhome_1/network/admin$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Sun Nov 27 15:57:09 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options SQL> alter profile default limit PASSWORD_VERIFY_FUNCTION null; Profile altered. SQL> commit; Commit complete. SQL>

No comments:

Post a Comment