Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01531: a database already open by the instance


SQL> select supplemental_log_data_min from v$database;

SUPPLEME
--------
YES

SQL> show parameter utl_file_dir

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
utl_file_dir                         string
SQL> Create Pfile from SPfile;

File created.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> select name, value from v$parameter where name like 'utl_file_dir';
select name, value from v$parameter where name like 'utl_file_dir'
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


ERROR:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> startup mount
ORACLE instance started.

Total System Global Area 5117050880 bytes
Fixed Size                  3056232 bytes
Variable Size            1040190872 bytes
Database Buffers         4060086272 bytes
Redo Buffers               13717504 bytes
Database mounted.
SQL> select name, value from v$parameter where name like 'utl_file_dir';

NAME
--------------------------------------------------
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
utl_file_dir



SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup pfile='C:\app\Oracle12\product\12.1.0\dbhome_1\database\INItorcl.ORA';
ORACLE instance started.

Total System Global Area 5117050880 bytes
Fixed Size                  3056232 bytes
Variable Size            1040190872 bytes
Database Buffers         4060086272 bytes
Redo Buffers               13717504 bytes
Database mounted.
Database opened.
SQL> show parameter utl_file_dir

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
utl_file_dir                         string      C:\app\backup\logmnr
SQL> select supplemental_log_data_min from v$database;

SUPPLEME
--------
YES

SQL> show parameter db_recovery_file_dest;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer 0
SQL> Alter system set db_recovery_file_dest_size=20G;

System altered.

SQL> Alter system set db_recovery_file_dest='C:\app\backup';

System altered.

SQL> begin
  2    dbms_logmnr_d.build(
  3            dictionary_filename   => 'dictionary.ora',
  4            dictionary_location   => 'C:\app\backup\logmnr',
  5            options               => dbms_logmnr_d.store_in_flat_file);
  6  end;
  7  /

PL/SQL procedure successfully completed.

SQL> conn test/test@pdborcl
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0


Warning: You are no longer connected to ORACLE.
SQL> conn test/test@pdborcl
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0


SQL> conn sys as sysdba
Enter password:
Connected.
SQL> conn sys@pdborcl as sysdba
Enter password:
Connected.
SQL> Create user test identified by test
  2  Default tablespace users
  3  Temporary tablespace temp
  4  Quota unlimited on users;
Create user test identified by test
                               *
ERROR at line 1:
ORA-01109: database not open


SQL> Grant create session, create procedure to test;
Grant create session, create procedure to test
*
ERROR at line 1:
ORA-01109: database not open


SQL> Grant execute on list_libraries to test;
Grant execute on list_libraries to test
*
ERROR at line 1:
ORA-01109: database not open


SQL> alter pluggable database pdborcl open read write;

Pluggable database altered.

SQL> conn test/test@pdborcl
Connected.
SQL> exec sys.list_libraries('NOUSER''||test.get_dba() --');
BEGIN sys.list_libraries('NOUSER''||test.get_dba() --'); END;

*
ERROR at line 1:
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "TEST.GET_DBA", line 1
ORA-06512: at "SYS.LIST_LIBRARIES", line 9
ORA-06512: at line 1


SQL> conn sys as sysdba
Enter password:
Connected.
SQL> alter system switch logfile;

System altered.

SQL> begin
  2    dbms_logmnr.add_logfile( LogFileName =>’C:/app/backup/archive/ARC0000000240_0922032286.0001’,
  3                              options     => DBMS_LOGMNR.NEW);
  4  end;
  5  /

PL/SQL procedure successfully completed.

SQL> begin
  2    dbms_logmnr.add_logfile(  LogFileName =>
  3  ' C:/app/backup/CDB1/archivelog/2016_10_31/ ARC0000000241_0922032286.0001',
  4                              options     => DBMS_LOGMNR.ADDFILE);
  5  end;
  6  /
begin
*
ERROR at line 1:
ORA-01284: file  C:/app/backup/CDB1/archivelog/2016_10_31/ ARC0000000241_0922032286.0001 cannot be opened
ORA-00308: cannot open archived log ' C:/app/backup/CDB1/archivelog/2016_10_31/ ARC0000000241_0922032286.0001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 123) The filename, directory name, or volume label syntax is incorrect.
ORA-06512: at "SYS.DBMS_LOGMNR", line 68
ORA-06512: at line 2


SQL> begin
  2    dbms_logmnr.add_logfile(  LogFileName =>
  3  'C:/app/backup/archive/ARC0000000241_0922032286.0001',
  4                              options     => DBMS_LOGMNR.ADDFILE);
  5  end;
  6  /

PL/SQL procedure successfully completed.

SQL> begin
  2    dbms_logmnr.add_logfile(  LogFileName =>
  3  'C:/app/backup/archive/ARC0000000242_0922032286.0001',
  4                              options     => DBMS_LOGMNR.ADDFILE);
  5  end;
  6  /

PL/SQL procedure successfully completed.

SQL> begin
  2    dbms_logmnr.start_logmnr( options =>  dbms_logmnr.dict_from_redo_logs +
  3                                          dbms_logmnr.ddl_dict_tracking +
  4                                          dbms_logmnr.print_pretty_sql);
  5  end;
  6  /
begin
*
ERROR at line 1:
ORA-01371: Complete LogMiner dictionary not found
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
ORA-06512: at line 2


SQL> Execute dbms_logmnr.start_logmnr( -
> DICTFILENAME => 'C:\app\backup\logmnr\dictionary.ora');

PL/SQL procedure successfully completed.

SQL> Select username, operation, sql_redo, sql_undo from v$logmnr_contents where username =’TEST’;

no rows selected

SQL>