Entradas

MANUAL DATABASE (CDB AND PDB) CREATION VIA SQL*PLUS

Imagen
A NOT SO STRAIGHTFORWARD APPROACH TO MANUAL DATABASE (CDB AND PDB) CREATION VIA SQL*PLUS While beginning my tinkering with Database 12c, I was curious to create the container database via SQL*Plus. Below are the steps I followed. Set your environment variable for  ORACLE_SID . It’s a given that you need  ORACLE_HOME   set  J [oracle@collabn1 dbs]$ ORACLE_SID=beans [oracle@collabn1 dbs]$ export ORACLE_SID Edit your initialization parameter file. It is important to note, for the  CREATE DATABASE  script to create the SEED database, the  ENABLE_PLUGGABLE_DATABASE   parameter must be set to  TRUE . To simplify my creation, I enabled Oracle Managed Filsystem (OMF) by setting  db_create_file_dest .  [oracle@collabn1 dbs]$ ls -lhtr total 16K -rw-r--r-- 1 oracle oinstall 3.0K Feb 3 2012 init.ora -rw-r----- 1 oracle oinstall 33 Sep 1 16:15 initrac1.ora -rw-r----- 1 oracle oinstall 0 Sep 2 14:05 lkinstslob -rw-rw---- 1 oracle oinstall 1.6K Sep 2 14:05 hc_slob.dat -rw-rw-
Publicar un comentario
Leer más

How To Move AUD$ Table To Another Tablespace Using DBMS_AUDIT_MGMT

Auditing is always about accountability, and is frequently done to protect and preserve privacy for the information stored in databases. Concern about privacy policies and practices has been rising steadily with the ubiquitous use of databases in businesses and on the Internet. Oracle Database provides a depth of auditing that readily enables system administrators to implement enhanced protections, early detection of suspicious activities, and finely-tuned security responses. If your  AUD$  table is in  SYSTEM  and  SYSTEM  tablespace, Then it is advised to move the  AUD$ to a dedicated tablespace. Use steps to move AUD$. 1 2 3 4 5 select owner , segment_name , segment_type , tablespace_name , bytes / 1024 / 1024 from dba_segments where segment_name = 'AUD$'   OWNER   SEGMENT_NAME     SEGMENT_TYPE   TABLESPACE_NAME   BYTES / 1024 / 1024 -- -- -- - -- -- -- -- -- -- -    -- -- -- -- -- --    -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- SYS
Publicar un comentario
Leer más