Muhammad Abdul Qaium is a Database Engineer/Oracle Apex Developer/BI Developer (in Connecticut, USA) who is an Oracle Certified Cloud Architect Professional, OCI Autonomous DB specialist as well as Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist with extensive expertise in Database design , PL/SQL, Oracle Apex, Microsoft SSIS, ETL, Power BI, Qlik Sense, BI Publisher, Jasper Report, OBIEE. Contact: qaiuminfo@gmail.com
Thursday, August 9, 2018
Create PDB , Alter/Open , TNSNAMES Configer, Drop PDB
CREATE PDB(Plaggable Database)
================================
create pluggable database NAME
admin user
app_admin identified by Password
file_name_convert = ('/pdbseed/', '/NAME/');
alter pluggable database NAME open;
TNSNAMES.ORA
================================
Path:
cd /u01/app/oracle/product/12.1.0/db_1/network/admin/
NAME =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.022)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = NAME)
)
)
DROP PDB
================================
alter pluggable database NAME close;
drop pluggable database NAME including datafiles;
Source: http://www.dba-oracle.com/t_pluggable_database.htm
No comments:
Post a Comment