I was trying to execute script in mysql from server level, was stuck at displaying hostname in output file. Many of you must have faced similar situation, here are different ways to achieve the same.
I have listed number of methods for the displaying hostname/server name while logged in mysql database but please note that this is not the limit, you...
Oracle 12c: Starting and Stopping PDB
In this article we will learn how to start and stop 12c database having multitenant databases.
For shutting down and starting container database, method is same as standalone database like 11g. Connect to container database(cdb$root) with sysdba and check the status of PDB's
SQL>
show pdbs
CON_ID CON_NAME
...
Warning: PDB altered with errors- opening PDB in Oracle 12.1
I was facing below error while opening pluggable database created on 12.1.0.2 using SEED PDB
SQL> show pdbs
CON_ID CON_NAME
OPEN MODE RESTRICTED
----------
------------------------------ ---------- ----------
...
Create Pluggable Database (PDB) in Oracle 12c
We have gone through features of 12c Multitenant database.
Now we will have discussion on create pluggable databases (PDB). There are
different ways to create pluggable database
We will discuss on below methods
1. Using SEED pdb
2. Using XML file
3. By Cloning
a. Local PDB
b. Remote...