Having questions about automatic startup and shutdown is quite common when dealing with new environments or configurations. There is more than one way to implement this depending on the environment configuration, licensing and version. So, here is a summary: 1….Read More >
We have all set up automatic startup and shutdown of an Oracle Database on Linux at some point. I, myself, have made some scripts to do it in the past. However, did you know there is an official way/script for…Read More >
Hello all! So, a client asked me to check why his database was not starting with CRS after a reboot. I started investigating and noticed this: On Oracle 11.2, the database auto-start policy in the Clusterware is “restore”, which means…Read More >
I recently came across a very unusual situation. During an upgraded review, I noticed the dba_registry_sqlpatch was empty when it shouldn’t be: SQL> select patch_id, patch_uid, version, action, action_time, status, description from dba_registry_sqlpatch; no rows selected SQL> The expected output…Read More >
So, after an abnormally quiet weekend, I was being paged: Oracle Management Services (OMS) was down! Well, this requires monitoring the monitoring, right? So, how to monitor the monitoring? Oracle Enterprise Manager (OEM) 13c has a feature called Out of…Read More >
We often manage services over EC2, this is not news. But when migrating to Amazon RDS, it’s usual for new users to have issues with performing some administrative actions on the database, especially when it’s done via internal Oracle procedures…Read More >
Are you manually (or via a script) killing idle sessions on your database? As a consequence, your users are getting error “ORA-00028: your session has been killed” and probably getting angry at you. What about doing it automatically, in a…Read More >
Now that we are fully into database upgrades, here is an important item to be aware of: As you may know, the Database Vault (DV) option could be reported as not installed in source when converting non-CDB to PDB, and…Read More >
When planning a patch for a client’s OMS, I found the following: OMSPatcher finds that previous patching session is not yet completed. Please refer log file “/u01/app/oracle/middleware/cfgtoollogs/omspatcher/28018178/omspatcher_2019-07-09_23-44-58PM_deploy.log” for the previous session and execute the script “/u01/app/oracle/middleware/.omspatcher_storage/oms_session/scripts_2019-07-09_23-44-39PM/run_script_singleoms_resume.sh” to complete the previous…Read More >
Have you received this error on OMS 18.104.22.168? “Metric evaluation error start – Get dynamic property error,” After performing some research on MOS and a confirmation SR, it seems related to Bug 17575631 CLUSTER DB HOME PAGE ERRORS- REGIONS FETCH…Read More >
© Copyright 2020 Pythian Group Inc. ® ALL RIGHTS RESERVED.
PYTHIAN®, LOVE YOUR DATA®, and ADMINISCOPE® are trademarks and registered trademarks owned by Pythian in North America and certain other countries, and are valuable assets of our company. Other brands, product and company names on this website may be trademarks or registered trademarks of Pythian or of third parties. Use of trademarks without permission is strictly prohibited.