Infrastructure at your Service

dbi services BLOG

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

Daniel Westermann

OGG: Unable to lock file “/xxx/de000000″ (error 11, Resource temporarily unavailable).

By | Database Administration & Monitoring | No Comments
 

 When you see the above message in the GoldenGate logfile there are usually orphan processes that prevent GoldenGate from locking the file (typically when your trail files are on NFS). In a case I had at a customer last week this was not the case. It could be confirmed that there are no other processes sitting on the file by doing an fuser on the file on all nodes of the cluster (This was an…

Read More
Franck Pachot

12cR2: lockdown profiles and ORA-01219

By | Database Administration & Monitoring | No Comments
 

 When you cannot open a database, you will get some users unhappy. When you cannot open multitenant database, then the number of unhappy users is multiplied by the number of PDBs. I like to encounter problems in my lab before seeing them in production. Here is a case where I’ve lost a file. I don’t care about the tablespace, but would like to put it offline and at least be able to open the database.

Read More
Mouhamadou Diaw

Dataguard Oracle 12.2: Keeping Physical Standby Sessions Connected During Role Transition

By | Database Administration & Monitoring | No Comments
 

 As of Oracle Database 12c Release 2 (12.2.0.1), when a physical standby database is converted into a primary you have the option to keep any sessions connected to the physical standby, without disruption, during the switchover/failover. When the database is reopened as the primary, the suspended sessions resume their operations as if nothing had happened. If the database (or an individual PDB) is not opened in the primary role, the sessions will be terminated. To…

Read More
William Sescu

Oracle 12c – How to correct the error: “RMAN-20005: target database name is ambiguous”

By | Database Administration & Monitoring, Database management | No Comments
 

 I do have a Data Guard environment, where I have configured the RMAN DB_UNIQUE_NAME persistent setting for my primary and the standby. With the RMAN DB_UNIQUE_NAME settings I am able to run reports my Oracle Data Guard environment from any database. I could e.g. list all archivelogs for SITE1 from SITE2 or the other ways around. Or I could show all persistent settings for SITE1 from SITE2 and of course the other way around. The…

Read More
Daniel Westermann

Converting a column from one data type to another in PostgreSQL

By | Database Administration & Monitoring | 2 Comments
 

 Last week at a customer the following question came up: We have a varchar2 column in Oracle that contains a date but actually is stored as a string. When we want to convert this column to be a real date data type in Oracle we can use dbms_redefinition. How can we do that in PostgreSQL? The first answer that came to me mind is: Add a new column (of data type date) and populate it…

Read More
Franck Pachot

12cR2 real-time materialized view (on query computation)

By | Database Administration & Monitoring | 2 Comments
 

 Materialized views is a very old feature (you may remember that it was called snapshots a long time ago). It has all advantages of a view, as you can define any select statement that joins, filters, aggregates, and see it as one table. It has all advantages of a table, as it is stored in one segment, can be indexed, partitioned, have constraints, be compressed, etc. It looks like indexes as it stores data redundantly,…

Read More
William Sescu

Oracle 12c – Combining Flashback Drop and Flashback Query

By | Database Administration & Monitoring, Database management | No Comments
 

 If you think that Flashback Drop feature just brings back your table, then this is only half of the story. It does much more than that. Besides undropping the table, it also brings back your constraints, your indexes, your trigger, your grants and the statistics as well. The ugly part is, that the flashback drop brings back some strange object names e.g. your indexes and constraints with names like “BIN$…” or alike. Maybe something you…

Read More
William Sescu

OEL 7 – How to disable IPv6 on Oracle Linux 7 – Follow Up

By | Operation systems | No Comments
 

 This is a follow up to the Blog were I explained how to disable IPv6 on Oracle Linux 7. If you have done all the steps which I have explained here http://blog.dbi-services.com/oel-7-how-to-disable-ipv6-on-oracle-linux-7/  then you have already IPv6 successfully disabled. However, some tools require some special attention afterwards if you want to avoid some ugly warning or error messages. There are so many tools that can use IPv4 and IPv6, but it is impossible to mention…

Read More
David Barbarin

SQL Server Failover Cluster on Linux and synchronizing uids/gids across nodes

By | Database Administration & Monitoring | No Comments
 

 In my previous blog post, I talked about SQL Server on Linux and high availability. During my test, I used a NFS server to share disk resources between my cluster nodes as described in the Microsoft documentation. A couple of days ago, I decided to add a fourth node (LINUX04) to my cluster infrastructure and I expected to do this work easily. But no chance, I faced a problem I never had before on this…

Read More
Stéphane Savorgnano

Windows Server 2016 RTM and Docker

By | Technology Survey | No Comments
 

 I wrote some months ago several blog posts about the new Container feature of Windows Server 2016. Here is the list: Windows Server 2016: Containers Windows Containers: Migration Windows Container: installation and utilization Today, I will install the Container feature, install Docker and deploy a container. First of all, I need to enable the Container and the Hyper-V feature, take care if you use VirtualBox because after having enable Hyper-V this won’t work anymore. Windows…

Read More
William Sescu

Oracle 12c – Issues with the HEATMAP Segment even if the heat map feature is not used

By | Database Administration & Monitoring, Database management | No Comments
 

 When I don’t need I feature, I don’t turn it on, or do not use it because it reduces the possibility to run into issues. Most of the times this is true, however, during the preparation for an RMAN workshop, the RMAN list failure command showed me the following dictionary issue. RMAN> list failure; using target database control file instead of recovery catalog Database Role: PRIMARY List of Database Failures ========================= Failure ID Priority Status…

Read More
Franck Pachot

12cR2 DBCA can create a standby database

By | Database Administration & Monitoring | No Comments
 

 Do you like DBCA to create a database from command line, with -silent -createDatabase? On a simple command line you can provision a database, with oratab, tnsnames.ora directory creation and any setting you want. And you can even call a custom script to customize further. But if you want to put it in Data Guard, you have to do the duplicate manually with RMAN. This evolves in 12.2 with a new option in DBCA to…

Read More