- OAC has been working fine for….180 days….and now won’t start!
- Service appears to come up OK, but no services accessible & reboots don’t fix it.
- The short answer – DBCS “as provisioned” has a 180 day expiry on all schemas – and officially there’s no way to unexpire the accounts without changing the passwords, which’ll break “everything”.
- This post shows how to identify & debug the problem, fix it quickly and simply, and then prevent it happening again!
It’s interesting that the ancient Greeks understood that the revelations of the Oracles were not seen as the objective truth and they were fully aware of the unknowability of the divine. I think everyone went to the Oracle Analytics Partner Forum in Athens with some trepidation about what the future holds for Analytics & the Cloud @ Oracle Corporation. The news is good….
I was in a conference yesterday and there was some lively debate about the pros and cons of APEX vs Oracle Analytics Cloud, OBIEE & BICS. I thought I’d drill in to this a little further and explore what role does Oracle Application Express plays in a Business Analytics environment and should (or could) Application Express be used instead of Oracle Analytics Cloud?