Errors When Starting Oracle 12c OMS

Our resource had taken leave and I had to stand in for him at one of our clients that is using Oracle 12C OMS. They are currently running 11g Databases on an Exadata Machine and they are basically using OMS to monitor the environment.

So one early morning I came in and tried to log on to OMS to check the status of my database and I got an error that I cannot be logged in and have to contact my administrator and unfortunately in this case I was the Administrator so I had to solve the issue.

Symptoms/Errors

I connect to the server and only to find out that there was no space on the /u01 drive and I quickly cleaned the space and checked if the services are running and they were down, so all I had to do was to start the services and I am good to go,so I quickly went to the handover file and I got the procedure to start the services and…..


[oracle@ora-emcc log]$ $OMS_HOME/bin/emctl status oms

Oracle Enterprise Manager Cloud Control 12c Release 2

Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.

WebTier is Up

Oracle Management Server is not functioning because of the following reason:

Failed to connect to repository database. OMS will be automatically restarted once it identifies that database and listener are up.

So I checked the error and realized that the listener might be down checked the listener and listener is up, restarted the listener got same error checked the Db and the Db is also up.

Solution

I found that there FRA was low on space and the quickest way to solve this was to increase the db_recovery_file_dest_size parameter which is a dynamic parameter and my problems were solved


ALTER SYSTEM SET db_recovery_file_dest_size=25G SCOPE=BOTH ;

Author: Stanley