实验环境准备

深碍√TFBOYSˉ_ 2022-09-11 03:18 132阅读 0赞

### 目录 ###

*   *  源端
     *  目标端
     *  TNS配置
     *  PDB用户
     *  环境变量
     *  固化sqlplus参数

## 源端 ##

Hostname : cdb 
    CDB : cdb
    PDB : source
    OS : Red Hat Enterprise Linux Server release 7.4 (Maipo)
    DB : Version 19.12.0.0.0
    Filesystem: /opt/oracle /data /redo /archive 
    8core 16G

dbca -silent -createDatabase -templateName General_Purpose.dbc -responseFile NO_VALUE \
    -gdbname cdb -sid cdb \
    -createAsContainerDatabase TRUE \
    -numberOfPDBs 1 \
    -pdbName source \
    -pdbAdminPassword oracle \
    -sysPassword oracle -systemPassword oracle \
    -datafileDestination '/data' \
    -recoveryAreaDestination '/archive' \
    -redoLogFileSize 50 \
    -storageType FS \
    -characterset AL32UTF8 -nationalCharacterSet AL16UTF16 \
    -sampleSchema true \
    -totalMemory 8192 \
    -databaseType OLTP  \
    -emConfiguration NONE

## 目标端 ##

Hostname :cdbtest
    CDB : cdbtest
    PDB : target
    OS : Red Hat Enterprise Linux Server release 7.4 (Maipo)
    DB : Version 19.12.0.0.0
    Filesystem: /opt/oracle /data /redo /archive 
    8core 16G

dbca -silent -createDatabase -templateName General_Purpose.dbc -responseFile NO_VALUE \
    -gdbname cdbtest -sid cdbtest \
    -createAsContainerDatabase TRUE \
    -numberOfPDBs 1 \
    -pdbName target \
    -pdbAdminPassword oracle \
    -sysPassword oracle -systemPassword oracle \
    -datafileDestination '/data' \
    -recoveryAreaDestination '/archive' \
    -redoLogFileSize 50 \
    -storageType FS \
    -characterset AL32UTF8 -nationalCharacterSet AL16UTF16 \
    -sampleSchema true \
    -totalMemory 8192 \
    -databaseType OLTP  \
    -emConfiguration NONE

## TNS配置 ##

tns
    cat >> tnsnames.ora
    SOURCE =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = cdb)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = SOURCE)
        )
      )
        
    TARGET =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = cdbtest)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = TARGET)
        )
      )
        
    tnsping source
    tnsping target

## PDB用户 ##

alter session set container=source;
    create user source identified by source;
    grant dba, sysdba to source;
    
    alter session set container=target
    create user target identified by target;
    grant dba, sysdba to target;

## 环境变量 ##

alias target='rlwrap sqlplus target/target@target'
    alias source='rlwrap sqlplus source/source@source'
    
    alias udump='cd $ORACLE_BASE/diag/rdbms/cdb/cdb/trace'
    alias alert='tail -1000f cd $ORACLE_BASE/diag/rdbms/cdb/cdb/trace/alert_cdb.log'

## 固化sqlplus参数 ##

*  [glogin.sql][]

[glogin.sql]: https://blog.csdn.net/hezuijiudexiaobai/article/details/119898831