Oracle Team

Oracle on Windows Server Core

By Franck Pachot . If SQL Server, the database for GUI fans, goes to Linux then Oracle, the database for command line fans, can go to Windows. Ok, that's not new. But I'm not talking about the Windows with media(…)

EM13c and postgres plugin

As an Oracle DBA I use Enterprise Manager to monitor Oracle databases at my client’s sites. I also administer more and more Postgres databases. I decided to download the Blue Medora plugin in order to monitor the postgresql databases with(…)

EM 13c corrective actions

With Enterprise Manager 13c, we have the possibility to define corrective actions. Let me show you how to use it. From the Enterprise à Monitoring select Corrective Actions : Choose Add Space to Tablespace in the Create Library Corrective(…)

Where is the ASM SPFILE?

By Franck Pachot . In the previous blog post, to the question "where is the ASM SPFILE" I answered by running 'asmcmd spget'. But this is available only if the ASM instance is started. If you(…)

Install Oracle 12c Flex Cluster Easily

By Mouhamadou Diaw To install a flex cluster (or a flex ASM)  Grid Naming Service (GNS) is required. A GNS can be configured with dynamic public networks (DHCP) for VIP. This method is suitable for a big number of nodes.In(…)

Learning and troubleshooting: Follow the path

By Franck Pachot . You query a simple table to get its rows. Did you ever ask yourself how oracle knows which blocks to read from disk? Let's question everything and follow the path to dictionary, bootstrapping, spfile,... up to(…)

Extended clusters and asm_preferred_read_failure_groups

By Franck Pachot . When you have 2 sites that are not too far you can build an extended cluster. You have one node on each site. And you can also use ASM normal redundancy to store data on each(…)

DB_FLASHBACK_RETENTION_TARGET may hang your database

By Franck Pachot . DB_FLASHBACK_RETENTION_TARGET is set to keep enough flashback logs to be able to flashback database within the specified retention window. But it's supposed to be a target only, meaning that on space pressure some files can be(…)

Which patchset for 12.1.0.2 ?

By Franck Pachot . When you want to download the latest patchset of the latest release, 12.1.0.2, you can find two patchsets referenced: 17694377 and 21419221. The short answer is: download p21419221 and add latest(…)

SYS password on Oracle Cloud Service managed database

By Franck Pachot . When you create a DBaaS on the Oracle Cloud services you have to provide an administration password in the database configuration form. You do not need a password to connect to the VM. You use SSH(…)