Blog

ERROR: “ORA-01012: not logged on” messages reported in the mm.log in Metadata Manager (MM) 9.x

Problem Description
In the mm.log, the following message is seen a number of times:
ORA-01012: not logged on
Because of this error, various operations/tasks do not complete or are hung.

Cause
This issue occurs when the JDBC connection from the MM Service to the MM Repository Database (on Oracle) is IDLE for a long time.

Solution
To resolve this issue, do the following:

• Login to the MM Repository Database Server and execute the following queries:
  a) Find the Profile used by the MM Database user:
  Raw

  SELECT USERNAME,PROFILE FROM DBA_USERS WHERE USERNAME='MM_Database_Username';

  b) Find the idle_time set for the profile in (a)

  Raw

  select * from dba_profiles where resource_name='IDLE_TIME' and profile='Profile_from_a';

• Set the IDLE_TIMEOUT to UNLIMITED, if this is not the current value.
• Restart Database Server if required.
• Restart the MM Service.