When you've installed Oracle Enterprise Manager Grid Control and you have configured Management Agents for database monitoring, all your databases will show up in the Grid Control application.
We have found a 'glitch' in this behaviour that in my opinion is very misleading.
When a database target is added/discovered in Grid Control, all possible Packs are enabled by default. This means that if you're running Standard Edition databases, you're violating the SE-license using e.g. the Diagnostic Pack as soon as your database is discovered in Grid Control.
Most of the Oracle DBAs just rely on the command line RMAN interface ( $ORACLE_HOME/bin/rman ) to perform the rman backup and recovery commands. Every rman backup file (backup piece) generated is also called a backup piece handle. Some of the rman operations can be performed via the little documented DBMS_BACKUP_RESTORE package also and it turns out to be a quite useful in some
A DBA is kinda like a chauffeur, he doesn’t own the car but it would be nice to drive one that has Electronic stability control or Anti-lock braking system or airbags, etc… For SQL server editions, it’s nice to have the Enterprise edition especially with big databases, we can use online index operations, fast recovery, [...]
From 11gR2, Oracle introduced “Out-of-Place” upgrade, where during the upgrade we install the patch set into a new, separate Oracle home, and its best practices recommendation, as minimizes the downtime.Once, the patch set installation is complete in the new Oracle Home location, we can perform the upgrade using DBUA or manual method. So, can’t we
There seems to be a misunderstanding that a MOUNT actually verifies datafiles. A STARTUP MOUNT (or STARTUP NOMOUNT followed by ALTER DATABASE MOUNT) does *NOT* read the datafiles and/or verify them. It does read the controlfile(s).
Here's a simple test :
I have a tablespace with a datafile that is "ONLINE".
Recently came across a situation, in which someone Due to some security issue someone wanted to bypass OBIEE’s default ports. After looking at multiple places, I could put all information together. I thought it would be a great share.
Even out of the box installation lets you change the configuration, during installation.
As reported in a few posts earlier, DDLs always commit when beginning execution, even if they subsequently fail execution. Here is a demonstration of a DROP TABLESPACE INCLUDING CONTENTS causing segments in the tablespace to be dropped even if the DROP TABLESPACE fails. Furthermore, segments dropped by a DROP TABLESPACE are no longer in the recyclebin !