viernes, 24 de febrero de 2023

ODA CREAR INSTANCIAS

 CREATE DATABASE

19C

# oakcli create database -db desindra -oh /u01/app/oracle/product/19.0.0.0/dbhome_1/ -storage ACFS

# oakcli create database -db dbbi -oh /u01/app/oracle/product/19.0.0.0/dbhome_1/ 

12C

# oakcli create database -db orcl -oh /u01/app/oracle/product/12.2.0.1/dbhome_1

oakcli create database -db dbdigit -oh /u01/app/oracle/product/12.2.0.1/dbhome_1


11G 

 oakcli create database -db snc101p -oh /u01/app/oracle/product/11.2.0.4/dbhome_1 -storage ACFS

 oakcli create database -db sncpre101 -oh /u01/app/oracle/product/11.2.0.4/dbhome_1 -storage ACFS


BORRAR ORACLE HOME

# delete dbhome -oh /u01/app/oracle/product/12.2.0.1/dbhome_2

BORRAR SNAPSHOT

acfsutil snap delete snc101  /u02/app/oracle/oradata/datastore

acfsutil snap delete snc101  /u02/app/oracle/oradata/flashdata

 acfsutil snap create -w sigq /u02/app/oracle/oradata/datastore

acfsutil snap create -w sigq /u02/app/oracle/oradata/flashdata


BORRAR DATABASE DESDE ORACLE_HOME

./srvctl remove database  -d snc101