Oracle Team

vagrant up – get your Oracle infrastructure up an running

By using Vagrant to manage your Virtual Machines and Ansible for configuration management and provisioning you can easily automate the setup of your whole test environment in a standardized way. If you have never heard about Ansible and Vagrant(…)

Dataguard Oracle 12.2 : Support for Multiple Observers

By Mouhamadou Diaw With Oracle 12cR2 it is now possible to configure multiple observers within a single Oracle Data Guard broker configuration. Multiple observers provide an immediate benefit for High Availability. If one observer fails, there are additional observers(…)

ORA-12801 and ORA-12154 with OracleRestart / GRID / RAC on Oracle Database 12c

ORA-12801 and ORA-12154 with OracleRestart / GRID / RAC on Oracle Database 12c Symptom/Analysis: Using Oracle 12c in a RAC environment, you may encounter the following errors: ORA-12801: error signaled in parallel query server P000, instance rac2.localdomain:DBRAC2 (2) ORA-12154:(…)

12cR2: no cardinality feedback for small queries

By Franck Pachot . This follows the comments on Clemens Bleile post about SQL Plan Directives in Oracle 12.2 where he discovered a new behavior that is not documented. The feature is good: bypass the cardinality feedback overhead when the(…)

NLS defaults for LANGUAGE and TERRITORY

By Franck Pachot . When you set NLS_LANGUAGE then the values of NLS_DATE_LANGUAGE and NLS_SORT are set to their defaults for the LANGUAGE you set. When you set NLS_TERRITORY then values of NLS_DATE_FORMAT, NLS_NUMERIC_CHARACTERS, NLS_CURRENCY and NLS_ISO_CURRENCY are set to(…)

Oracle 12cR2 – DataGuard Switchover with Oracle Wallets

By William Sescu I would like to make my DataGuard environment more secure, by eliminating the typing of “connect sys/Manager1” for my DGMGRL commands. Especially the ones, that I have in my scripts. For example: oracle@dbidg01:/home/oracle/ [DBIT122] dgmgrl <<-EOF >(…)

Oracle 12cR2 – How to Setup DataGuard observer with Oracle Wallets

By William Sescu I am not a big fan of having passwords in clear text laying around. This applies not only to application servers, but also for my Data Guard observer. I do have a script for starting the observer(…)

Oracle 12cR2 – DataGuard and TCP.VALID_NODE_CHECKING

By William Sescu Security is a quite important topic, especially when running Oracle in the cloud. To make your DataGuard a little bit more secure, you can enable the TCP.VALIDNODE_CHECKING feature. I call it SQL*Net Firewall. Enabling the SQL*Net Firewall(…)

Oracle 12cR2: AWR views in multitenant

By Franck Pachot . In a previous post I explained how the AWR views have changed between 12.1.0.1 and 12.1.0.2 and now in 12.2.0.1 they have changed again. This is a good illustration of multitenant object(…)

RMAN> TRANSPORT TABLESPACE

By Franck Pachot . In a previous post I explained how to use transportable tablespace from a standby database. Here I'm showing an alternative where you can transport from a backup instead of a standby database.