Oracle Automation / Cloud

Delete ASM Cloud FileSystem volumes Open a terminal window on your first node as the grid user and set the environment and run ASMCA Set up environment -    [grid@racdb01 ~]$ . oraenv ORACLE_SID = [grid] ? +ASM1 The Oracle base has been set to /u01/app/grid From the terminal window, run asmca  [grid@racdb01 ~]$ asmca Select ACFS File systems, right click and select option delete select yes. Then disable ACFS volume from all the nodes - Now Delete the ACFS Volume Dismount ACFS diskgroups - Then Drop ACFS disk group - Done. 

Oracle DBA - Automation with Ansible (Setup ASM Cloud File System Oracle 18c ) I am running running playbook "racdatabase.yml" which has enabled role "racdb_acfs" - to create ACFS. Tree structure for this  role "racdb_acfs" Variables for this role are as below - Running Playbook with step option Playbook for this role is as below: [root@oel75 roles]# cat racdb_acfs/tasks/main.yml --- - name: List Current ASM diskgroups for ACFS   become_user: "{{ superuser }}"   action: shell export GRID_HOME={{ grid_home }}; {{ grid_home }}/bin/srvctl status diskgroup -g {{ acfsdiskgroup }}   tags: acfs - name: ACFS/ADVM modules installation   action: shell export GRID_HOME={{ grid_home }}; {{ grid_home }}/bin/acfsroot install - name: Start ACFS modules   become_user: "{{ superuser }}"   action: shell export GRID_HOME={{ grid_home }}; {{ grid_home }}/bin/acfsload start   tags: acfs - name: Create an ASM volume ...

Install Or acle 18c Grid Infrastructure for RAC Follow the link

Testing transport tablespace - Migrating an Oracle 12c Database to a 18c Pluggable Database in the Oracle Cloud ++++++++++++++++++++++ On-premises 12cR2 database   ++++++++++++++++++++++ Create a tablespace CREATE SMALLFILE TABLESPACE TESTTBS     DATAFILE         '/opt/oracle/oradata/TSOC/tstdb01.dbf' SIZE 300M AUTOEXTEND ON NEXT 1 MAXSIZE 500M  SEGMENT SPACE MANAGEMENT AUTO     EXTENT MANAGEMENT LOCAL AUTOALLOCATE;             Tablespace created. Create the user test in the tablespace SYS@TSOC > CREATE USER test IDENTIFIED BY test DEFAULT TABLESPACE "TESTTBS" TEMPORARY TABLESPACE "TEMP";  2    3 User created. SYS@TSOC >  ALTER USER test QUOTA UNLIMITED ON TESTTBS; User altered. SYS@TSOC > GRANT CONNECT, RESOURCE to test; Grant succeeded.   Create a TEST TABLE ...

Oracle 18c : Database creation using DBCA Click below link -  Oracle18c create-database-using-dbca

Recovering Pluggable Database (PDB) table in Container Database (CDB) Connect to the PDB and create a test table  SQL> connect HR/Password#123@pdb1 Connected. SQL> set echo on SQL> create table EMPLOYESS_TEST as select * from EMPLOYEES; Table created. SQL> select count (*) from EMPLOYESS_TEST;   COUNT(*) ----------        107 SQL> alter session set container=pdb1; Session altered. SQL> select timestamp_to_scn(sysdate) from v$database; TIMESTAMP_TO_SCN(SYSDATE) -------------------------                   3337108 SQL> SELECT NAME, CURRENT_SCN FROM V$DATABASE; NAME      CURRENT_SCN --------- ----------- TESTDB03      3337119 NOTE this SCN which will be used to recover the table. Take an RMAN Backup of the PDB  SQL> ho [oracle@TESTDB03 ~]$  rman target / Recovery Manager: ...

18c- Install Sample Schema  This document is relate to create sample schema under pluggable database. SQL> alter session set container=PDB1; Session altered. Create a tablespace to use for sample schema SQL> create tablespace example01 datafile '/u02/app/oracle/oradata/TESTDB03/PDB1/example01.dbf' size 100M autoextend on next 10M maxsize 500M; Tablespace created. Here I am creating HR sample schema SQL> @?/demo/schema/human_resources/hr_main.sql specify password for HR as parameter 1: Enter value for 1: Password#123 specify default tablespeace for HR as parameter 2: Enter value for 2: example01 specify temporary tablespace for HR as parameter 3: Enter value for 3: TEMP specify log path as parameter 4: Enter value for 4: /u02/app/oracle/oradata/TESTDB03/PDB1 PL/SQL procedure successfully completed. User created. User altered. User altered. Grant succeeded. Grant succeeded. Session...