by Maciej Tokar | May 5, 2016 | Oracle 12c R1, Oracle Database, Other, RMAN
1. Introduction I have been looking lately for the best solution in Oracle 12c to relocate database from one server to another with minimum downtime and hassle. I had a few requirements: The method should provide minimum downtime for the service affected. A MUST HAVE:...
by Maciej Tokar | May 1, 2016 | Enterprise Edition, Multitenancy, Oracle 12c R1, Oracle Database
Requirements: The source must be opened in read-only mode. CDB that is to accommodate the remote PDB must have the database link defined to the remote database. It can point either to the CDB that the source PDB belongs to or directly to the source PDB. User in the...
by Maciej Tokar | May 1, 2016 | Enterprise Edition, Multitenancy, Oracle 12c R1, Oracle Database
This is an example based on Oracle 12c 12.1.0.2 with PSU July 2015 Single PDB configuration. I found last week some objects in my PDBs related to the auditing that were not compiled and in INVALID state. OBJECT_TYPE OWNER OBJECT_NAME -------------- ------- -----------...
by Maciej Tokar | May 1, 2016 | Oracle Database
Changing a database name for Oracle database is a quite simple task, but I had been doing it manually until I have been shown the nid tool. Manually – I mean I had always been doing this by recreating a controlfile with the new database name. I tried the nid...
by Maciej Tokar | May 1, 2016 | Installation, Oracle 11g R2, Oracle 12c R1, Oracle Database, Real Application Cluster
This is short but I hope useful post on how to check if your Oracle software for database has got the RAC option enabled, how to enable and disable the option How to quickly check if you have RAC enabled Change directory to your database software...