Infrastructure at your Service

Oracle 12c Archives - Blog dbi services

Franck Pachot

12cR2 needs to connect with password for Cross-PDB DML

By | Database management | No Comments

In a previous post, I explained that Cross-PDB DML, executing an update/delete/insert with the CONTAINERS() clause, seems to be implemented with implicit database links. Connecting through a database link requires a password and this blog post is about an error you may encounter: ORA-01017: invalid username/password; logon denied This blog post also explains a consequence of this implementation, the big inconsistency of CONTAINERS() function because the implementation is completely different for queries (select) and for…

 
Read More
Franck Pachot

random “ORA-01017: invalid username/password” in 12cR2

By | Database management | 2 Comments

Since 12cR2 is out, we give our 12c new feature workshop with hands-on exercises on 12.1 and 12.2 releases. When I gave it last month, I had a small problem when doing demos: sometimes the connections as sysdba failed with “ORA-01017: invalid username/password”. It was at random, about one every 5 login attempts and I was sure that the password did not change. As I give another of this training next week, I tried to…

 
Read More
Franck Pachot

12cR2 Cross-container DML – insert into container()

By | Database management | No Comments

Multitenant has been introduced in 12.1.0.1 with the goal to share resources but isolate data. However, having all PDBs in the same root may be convenient to manipulate data in multiple PDBs. In the first patchset, 12.1.0.2, a way to query cross-container has been introduced for the CDB administrator to see data in other containers. In the second release, 12.2.0.1, this goes further with the introduction of Application Containers and cross-PDB DML. Currently, not all…

 
Read More
Pierre Sicot

Grid Infrastructure Installation on SLES 12 SP1

By | Database Administration & Monitoring | 2 Comments

This week I needed to install Oracle Grid Infrastructure 12c release 1 in a SLES 12 SP1 environment. Everything worked fine until I ran the root.sh at the end of the installation. Here’s a quick description of the problem and the workaround. The root.sh script ran into error and the installation was completely unsuccessfull: oracle:/u00/app/grid/12.1.0.2 # /u00/app/grid/12.1.0.2/root.sh Performing root user operation.   The following environment variables are set as:     ORACLE_OWNER= grid     ORACLE_HOME=  /u00/app/grid/12.1.0.2…

 
Read More
Franck Pachot

12c nologging and Data Guard

By | Database management | 3 Comments

The title sounds weird because Data Guard synchronisation is based on the redo stream, so it makes no sense to do nologging operations on the primary. And this is the reason why we set FORCE LOGGING on a Data Guard configuration. However, to lower the downtime of a migration done with Data Pump, you may want to import with minimal logging and then re-synchronize the standby. This post is about the re-synchronisation in 12.1  

 
Read More
Pierre Sicot

Oracle 12.2 tables, indexes new features

By | Database Administration & Monitoring | No Comments

The Oracle 12.2.0.1 version has some interesting new features  concerning tables or indexes. The first new feature is about the online table move. In 12.2 version Oracle offers now the possibility to move non-partitioned tables without blocking any DML operations. To realise this operation, we must use the ONLINE keyword and/or the UPDATE_INDEXES clause. If you remember, in the previous Oracle version, we encountered the classical ORA-01502 error. If you remember in version 12.1, we have…

 
Read More
Franck Pachot

12cR2 RMAN> REPAIR

By | Database management | One Comment

Do you know the RMAN Recovery advisor? It detects the problems, and then you: RMAN> list failure; RMAN> advise failure; RMAN> repair failure; You need to have a failure detected. You can run Health Check if it was not detected automatically (see https://blog.dbi-services.com/oracle-12c-rman-list-failure-does-not-show-any-failure-even-if-there-is-one/). In 12.2 you can run the repair directly, by specifying what you want to repair.  

 
Read More