oracle admin database drop create - ghdrako/doc_snipets GitHub Wiki

Drop database

shutdown immediate;
startap restrict mount;
drop database;

Create databse

dbca

• https://docs.oracle.com/en/database/oracle/oracle-database/21/multi/dbca-command.html#GUID-0A94814D-032B-4F6A-8B54-A35223A1E3EF

dbca -silent \
  -createDatabase \
  -templateName General_Purpose.dbc \
  -gdbname noCBM \
  -sid noCBM \
  -responseFile NO_VALUE \
  -characterSet AL32UTF8 \
  -nationalCharacterSet=AL16UTF16
  -sysPassword Oracle \
  -systemPassword Oracle \
  -createAsContainerDatabase false \
  -databaseType MULTIPURPOSE \
  -memoryMgmtType auto_sga \
  -memoryPercentage 30 \
  -storageType FS \
  -datafileDestination /u01/app/oracle/oradata \
  -redoLogFileSize 50 \
  -emConfiguration NONE

$ dbca -silent -createDatabase \
 -templateName General_Purpose.dbc \
 -gdbname cdb3 -sid cdb3 -responseFile NO_VALUE \
 -characterSet AL32UTF8 \
 -sysPassword OraPasswd1 \
 -systemPassword OraPasswd1 \
 -createAsContainerDatabase true \
 -numberOfPDBs 1 \
 -pdbName pdb3 \
 -pdbAdminPassword OraPasswd1 \
 -databaseType MULTIPURPOSE \
 -memoryMgmtType auto_sga \
 -totalMemory 1536 \
 -storageType FS \
 -datafileDestination "/u01/app/oracle/oradata/" \
 -redoLogFileSize 50 \
 -emConfiguration NONE \
 -ignorePreReqs

dbca -createDatabase \
     -silent \ 
     -responseFile /media/sf_staging/oradb-noncdb.rsp \
     -dbOptions JSERVER:true,DV:false,APEX:false,OMS:false,SPATIAL:false,IMEDIA:false,ORACLE_TEXT:false,CWMLITE:false \
     -sampleSchema true

responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0
gdbName=###ORACLE_SID###
sid=###ORACLE_SID###
databaseConfigType=SI
createAsContainerDatabase=true
numberOfPDBs=1
pdbName=###ORACLE_PDB###
pdbAdminPassword=###ORACLE_PWD###
templateName=General_Purpose.dbc
sysPassword=###ORACLE_PWD###
systemPassword=###ORACLE_PWD###
emConfiguration=DBEXPRESS
emExpressPort=5500
dbsnmpPassword=###ORACLE_PWD###
storageType=FS
characterSet=###ORACLE_CHARACTERSET###
nationalCharacterSet=AL16UTF16
automaticMemoryManagement=FALSE
totalMemory=1536
# Some init.ora parameters - disable auditing to save space, enable FS optimizations
initParams=audit_trail=none,audit_sys_operations=false,filesystemio_options=setall,commit_logging=batch,commit_wait=nowait

Manula (sqlplus)

export ORACLE_SID=noCBM
sqlplus / as sysdba

STARTUP NOMOUNT;

CREATE DATABASE noCBM
   USER SYS IDENTIFIED BY Oracle123
   USER SYSTEM IDENTIFIED BY Oracle123
   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/noCBM/redo01.log') SIZE 50M,
           GROUP 2 ('/u01/app/oracle/oradata/noCBM/redo02.log') SIZE 50M
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXDATAFILES 100
   CHARACTER SET AL32UTF8
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE '/u01/app/oracle/oradata/noCBM/system01.dbf' SIZE 700M REUSE
   SYSAUX DATAFILE '/u01/app/oracle/oradata/noCBM/sysaux01.dbf' SIZE 550M REUSE
   DEFAULT TABLESPACE users
      DATAFILE '/u01/app/oracle/oradata/noCBM/users01.dbf' SIZE 200M REUSE
   UNDO TABLESPACE undotbs1
      DATAFILE '/u01/app/oracle/oradata/noCBM/undotbs01.dbf' SIZE 200M REUSE
   DEFAULT TEMPORARY TABLESPACE temp
      TEMPFILE '/u01/app/oracle/oradata/noCBM/temp01.dbf' SIZE 100M REUSE;

Uruchom skrypty inicjalizujące katalogi:

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/sqlplus/admin/pupbld.sql

weryfikacja

SELECT name FROM v$database;

Dodaj do pliku oratab (Linux):

noCBM:/u01/app/oracle/product/19.0.0/dbhome_1:Y