OracleCDC

[oracle@a9113e4ba60b /]$ export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2
[oracle@a9113e4ba60b /]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu May 26 08:20:36 2022

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn /as sysdba
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


SQL> conn /as sysdba
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


SQL> ^C^H^H

SQL> exit
[oracle@a9113e4ba60b /]$ export ORACLE_SID=helowin
[oracle@a9113e4ba60b /]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu May 26 08:22:45 2022

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2213776 bytes
Variable Size             436209776 bytes
Database Buffers         1157627904 bytes
Redo Buffers                7360512 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> select dest_id,name from v$archived_log;

no rows selected

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2213776 bytes
Variable Size             436209776 bytes
Database Buffers         1157627904 bytes
Redo Buffers                7360512 bytes
Database mounted.
SQL> select log_mode from v$database;

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

SQL> select dest_id,name from v$archived_log;

no rows selected

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

Database altered.

SQL> ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE
*
ERROR at line 1:
ORA-01109: database not open


SQL> alter database open;

Database altered.

SQL>  select dest_id,name from v$archived_log;

no rows selected

SQL>  ALTER SYSTEM SWITCH LOGFILE;

System altered.

SQL> CREATE USER 'jiangzz' IDENTIFIED BY '123456'
  2  ;
CREATE USER 'jiangzz' IDENTIFIED BY '123456'
            *
ERROR at line 1:
ORA-01935: missing user or role name


SQL> CREATE USER jiangzz IDENTIFIED BY 1232456
  2  ;

User created.

SQL> GRANT create session, alter session, execute_catalog_role, select any transaction, select any table to jiangzz
  2  ;

Grant succeeded.

SQL> GRANT select on GV_$DATABASE to jiangzz;

Grant succeeded.

SQL> GRANT select on GV_$ARCHIVED_LOG to jiangzz;

Grant succeeded.

SQL> GRANT select on V_$LOGMNR_CONTENTS to jiangzz;

Grant succeeded.

SQL> GRANT select on *.* TO jiangzz;
GRANT select on *.* TO jiangzz
                *
ERROR at line 1:
ORA-00903: invalid table name


SQL> GRANT select on dev.t_user TO jiangzz;

Grant succeeded.

SQL> grant create session, alter session, execute_catalog_role, select any transaction, select any table to jiangzz;

Grant succeeded.

SQL> EXECUTE DBMS_LOGMNR_D.BUILD(OPTIONS=> DBMS_LOGMNR_D.STORE_IN_REDO_LOGS);

PL/SQL procedure successfully completed.

GRANT CREATE SESSION TO jiangzz;
GRANT SELECT ON V_$DATABASE to jiangzz ;
GRANT FLASHBACK ANY TABLE TO jiangzz;
GRANT SELECT ANY TABLE TO jiangzz;
GRANT SELECT_CATALOG_ROLE TO jiangzz
GRANT EXECUTE_CATALOG_ROLE TO jiangzz;
GRANT SELECT ANY TRANSACTION TO jiangzz;
GRANT CREATE TABLE TO jiangzz;
GRANT LOCK ANY TABLE TO jiangzz ;
GRANT CREATE SEQUENCE TO jiangzz;
GRANT EXECUTE ON DBMS_LOGMNR TO  jiangzz;
GRANT SELECT ON V_$LOG TO jiangzz;
GRANT SELECT ON V_$LOG_HISTORY TO jiangzz;
GRANT SELECT ON V_$LOGMNR_LOGS TO jiangzz;
GRANT SELECT ON V_$LOGMNR_CONTENTS TO jiangzz;
GRANT SELECT ON V_$LOGMNR_PARAMETERS TO jiangzz;
GRANT SELECT ON V_$LOGFILE TO jiangzz;
GRANT SELECT ON V_$ARCHIVED_LOG TO jiangzz;
GRANT SELECT ON V_$ARCHIVE_DEST_STATUS TO jiangzz;
GRANT SELECT ON V_$LOGFILE TO jiangzz;
alter user jiangzz quota unlimited on users;