12c New features changed from licensing option to free to use! When Oracle 12c was released one of the new features was privilege analysis, this is a great features, but initially required additional licensing. But recently (November 2018) this license is not longer required. Which is very nice from Oracle. What is privilege analysis?
Below are the steps how to clone a pluggable database from another container. The steps are used during a migration from 12.1 to 12.2, but will also work for later releases. Create a Database link in the target container Create a database link in the ROOT container and validate the link. Perform the action
During the upgrade from 188.8.131.52 to 184.108.40.206 we received an error. In the created logfile located in /u01/app/oracle/cfgtoollogs/dbua/logs the following was reported: UPGRADE_PROGRESS : 36% XDB component upgrade error: ORA-24328: illegal attribute value When checking out the details in the /u01/app/oracle/cfgtoollogs/dbua/EDBA7_01/upgrade1/catupgrd0.log It reports: 15:29:21 SQL> Rem Ensure that all XDB$RESOURCE dependencies are validated
A prerequisite for the installation of Grid Infrastructure is to configure passwordless SSH connectivity. This can be accomplished in using the following statements: [grid@server52 ~]$ ssh-keygen -t rsa [grid@server53 ~]$ ssh-keygen -t rsa [grid@server52 ~]$ ssh-copy-id grid@server52 [grid@server52 ~]$ ssh-copy-id grid@server53 [grid@server53 ~]$ ssh-copy-id grid@server52 [grid@server53 ~]$ ssh-copy-id grid@server53 So far so good. When
ORA-28305: WALLET_LOCATION in sqlnet.ora file for container database is not supported. Based on the Oracle documentation and bug 17758886 we need to remove the wallet_location from our sqlnet.ora Checking the Oracle documentation the following is mentioned: All the PDBs in a CDB have the same database unique name. By placing wallets in the default location,
Starting with Oracle RDBMS 12.1 the syntax for srvctl is changed, instead of the abbreviations you can now use the new full names. The old syntax is still valid. For example: srvctl status database -d <your dbname> will now become srvctl status database -db <your dbname>. This is a simple example but if we look
In Oracle 12.1 it is not possible to flashback a pluggable database, but starting with 12.2 it is. Here we start with a demo on how this taks can be accomplished: First we connect to the pluggable and want to create a restore point. SQL> alter session set container=pdbproda; Session altered. SQL> create restore point
During the installation of pushing an Oracle agent from Enterprise Manager 13c to a host the initiaal handshake failed, PROV-16011: Algorithm negotiation fail
Below you will find a script which I created for a customer, due to the fact we needed to have an overview of the flash cache usage after enable write back mode. In a table the storage cell, allocated flash cache, used and dirty is provide. Very useful to see in one run the current
Namens het gehele GRID-IT team bedanken wij onze klanten voor het vertrouwen wat u ons heeft gegeven in het afgelopen jaar en we hopen onze kennis en kunde ook in 2016 voor u te mogen inzetten. Daar naast wensen wij u en uw naaste een goed maar vooral gezond 2016!