{"id":42825,"date":"2023-02-04T15:45:03","date_gmt":"2023-11-05T22:37:16","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8%e6%9c%ac%e5%9c%b0%e5%88%9b%e5%bb%baoracle-golden-gate-19%e7%8e%af%e5%a2%83%e7%9a%84%e6%ad%a5%e9%aa%a41%ef%bc%9a%e5%ae%89%e8%a3%85oracle-database-cui%e3%80%82\/"},"modified":"2024-04-29T13:07:00","modified_gmt":"2024-04-29T05:07:00","slug":"%e5%b0%9d%e8%af%95%e5%9c%a8%e6%9c%ac%e5%9c%b0%e5%88%9b%e5%bb%baoracle-golden-gate-19%e7%8e%af%e5%a2%83%e7%9a%84%e6%ad%a5%e9%aa%a41%ef%bc%9a%e5%ae%89%e8%a3%85oracle-database-cui%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8%e6%9c%ac%e5%9c%b0%e5%88%9b%e5%bb%baoracle-golden-gate-19%e7%8e%af%e5%a2%83%e7%9a%84%e6%ad%a5%e9%aa%a41%ef%bc%9a%e5%ae%89%e8%a3%85oracle-database-cui%e3%80%82\/","title":{"rendered":"\u5c1d\u8bd5\u5728\u672c\u5730\u521b\u5efaOracle Golden Gate 19\u73af\u5883\u7684\u6b65\u9aa41\uff1a\u5b89\u88c5Oracle Database CUI"},"content":{"rendered":"<h4>\u53ea\u9700\u8981\u4e00\u4e2a\u9009\u62e9: &#8221;\u76ee\u6807&#8221;<\/h4>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d4eb637434c4406cc16c0\/1-0.png\" alt=\"oracle_gg.PNG\" \/><\/div>\n<h6>\u7b2c\u4e00\u6b65\u3002\u5b89\u88c5Oracle\u6570\u636e\u5e93CUI\uff08\u6b64\u6587\u7ae0\uff09\u3002<\/h6>\n<p>\u7b2c\u4e8c\u6b65\uff1a\u5b89\u88c5Oracle Golden Gate<br \/>\n\u7b2c\u4e09\u6b65\uff1a\u8bbe\u7f6eOracle Golden Gate<br \/>\n\u7b2c\u56db\u6b65\uff1a\u5c1d\u8bd5\u4f7f\u7528Oracle Golden Gate<\/p>\n<h4>\u7248\u672c\u7b49<\/h4>\n<div>\n<div class=\"post-table\">\u5bfe\u8c61\u30d0\u30fc\u30b8\u30e7\u30f3Host OSWindows10Client OS1 (name: myora1)Centos-7.8 on virtual boxClient OS2 (name: myora2)Centos-7.8 on virtual boxVirtual BoxVersion 6.1.26VagrantVersion 2.2.5Ansible (ansible_local)Version 2.9Oracle DB19cOracle Golden Gate19.1.0.0<\/div>\n<\/div>\n<h4>Oracle\u6570\u636e\u5e93\u5b89\u88c5\u6b65\u9aa4<\/h4>\n<p>\uff11\uff0e\u521b\u5efa\uff08\u5c06\u4e24\u53f0\uff09Vagrantfile \u6587\u4ef6<br \/>\n\uff12\uff0e\u521b\u5efa Ansible playbook \u6587\u4ef6<br \/>\n\uff13\uff0e\u4e0b\u8f7d Oracle DB<br \/>\n\uff14\uff0e\u521b\u5efa\u865a\u62df\u73af\u5883 \uff08\u9700\u65f6240\u5206\u949f\uff09<\/p>\n<h5>\u521b\u5efa Vagrantfile\uff08\u5305\u542b\u4e24\u4e2a\u865a\u62df\u673a\u7684\u4e00\u4e2a\u6587\u4ef6\uff09\u3002<\/h5>\n<pre class=\"post-pre\"><code>|-- Vagrantfile\r\n|-- ansible\r\n|   |-- hosts\r\n|   |-- installer\r\n|   |   `-- oracle-database-ee-19c-1.0-1.x86_64.rpm\r\n|   |-- myora1.yml\r\n|   `-- myora2.yml\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>#Vagrant::DEFAULT_SERVER_URL.replace('https:\/\/vagrantcloud.com')\r\n# Vagrantfile\r\n# coding: utf-8\r\n# -*- mode: ruby -*-\r\n# vi: set ft=ruby :\r\n\r\nVagrant.configure(\"2\") do |config|\r\n  # (A) For \/sbin\/mount.vboxsf: mounting failed with the error: No such device\r\n  if Vagrant.has_plugin?(\"vagrant-vbguest\")\r\n    config.vbguest.auto_update = false\r\n  end\r\n\r\n  config.vm.box = \"bento\/centos-7.8\"\r\n  config.vm.box_url = \"https:\/\/app.vagrantup.com\/bento\/boxes\/centos-7.8\"\r\n  # (B) myora1 vm\r\n  config.vm.define \"myora1\" do |server|\r\n    server.vm.hostname = 'myora1'\r\n    server.vm.network :private_network,ip: \"192.168.60.50\"\r\n    server.vm.provider \"virtualbox\" do |vbox|\r\n      vbox.gui = false\r\n      vbox.name = \"CentOs7.8-myora1\"\r\n      vbox.cpus = 2\r\n      vbox.memory = 2048\r\n      vbox.customize [\r\n        \"modifyvm\", :id,\r\n        \"--vram\", \"256\", # video memory for full screen\r\n        \"--clipboard\", \"bidirectional\", # sharing clipboard\r\n        \"--draganddrop\", \"bidirectional\", # enable drag &amp; drop\r\n        \"--cpus\", \"2\", # 2 cpu\r\n        \"--ioapic\", \"on\" # enable I\/O APIC\r\n      ]\r\n    end\r\n\r\n    # (C) ansible\r\n    server.vm.synced_folder \".\/ansible\", \"\/ansible\"\r\n    server.vm.provision \"ansible_local\" do |ansible|\r\n      ansible.playbook       = \"\/ansible\/myora1.yml\"\r\n      ansible.version        = \"latest\"\r\n      ansible.verbose        = false\r\n      ansible.limit          = \"myora1\"\r\n      ansible.inventory_path = \"\/ansible\/hosts\"\r\n    end\r\n  end\r\n\r\n  # (B) myora2 vm\r\n  config.vm.define \"myora2\" do |server|\r\n    server.vm.hostname = 'myora2'\r\n    server.vm.network :private_network,ip: \"192.168.60.60\"\r\n    server.vm.provider \"virtualbox\" do |vbox|\r\n      vbox.gui = false\r\n      vbox.name = \"CentOs7.8-myora2\"\r\n      vbox.cpus = 2\r\n      vbox.memory = 2048\r\n      vbox.customize [\r\n        \"modifyvm\", :id,\r\n        \"--vram\", \"256\", # video memory for full screen\r\n        \"--clipboard\", \"bidirectional\", # sharing clipboard\r\n        \"--draganddrop\", \"bidirectional\", # enable drag &amp; drop\r\n        \"--cpus\", \"2\", # 2 cpu\r\n        \"--ioapic\", \"on\" # enable I\/O APIC\r\n      ]\r\n    end\r\n    # (C) ansible\r\n    server.vm.synced_folder \".\/ansible\", \"\/ansible\"\r\n    server.vm.provision \"ansible_local\" do |ansible|\r\n      ansible.playbook       = \"\/ansible\/myora2.yml\"\r\n      ansible.version        = \"2.9.24\"\r\n      ansible.verbose        = false\r\n      ansible.limit          = \"myora2\"\r\n      ansible.inventory_path = \"\/ansible\/hosts\"\r\n    end\r\n  end\r\nend\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">(A) &#8220;vagrant-vbguest&#8221; \u306e\u81ea\u52d5\u66f4\u65b0\u304c\u6709\u52b9\u306b\u306a\u3063\u3066\u3044\u308b\u3068\u3001\u5931\u6557\u3059\u308b\u3053\u3068\u304c\u3042\u308b\u306e\u3067\u3001\u7121\u52b9\u306b\u3057\u3066\u3044\u308b<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">(B) &#8220;myora1&#8221; \u3068 &#8220;myora2&#8221; \u3068\u3044\u30462\u3064\u306e\u4eee\u60f3\u74b0\u5883\u3092\u5b9a\u7fa9\u3057\u3066\u3044\u308b<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">(C) ansible \u306e playbook \u3092 &#8220;myora1.yml&#8221; \u3068 &#8220;myora2.yml&#8221; \u306e\u305d\u308c\u305e\u308c\u306e\u4eee\u60f3\u74b0\u5883\u6bce\u306b\u7528\u610f\u3057\u3066\u3044\u308b<\/ul>\n<h5>2. \u5236\u4f5cAnsible playbook\u6587\u4ef6<\/h5>\n<p>\u901a\u8fc7\u4ee5\u4e0b\u65b9\u5f0f\u5728\u6e05\u5355\u6587\u4ef6\u4e2d\u6307\u5b9a\uff0c\u4f7f\u5f97\u53ef\u4ee5\u5728\u672c\u5730\u4e3b\u673a\u4e0a\u65e0\u9700SSH\u76f4\u63a5\u6267\u884cAnsible\u3002<\/p>\n<pre class=\"post-pre\"><code>myora1 ansible_connection=local\r\nmyora2 ansible_connection=local\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>- hosts: myora1\r\n  connection: local\r\n  become: yes\r\n  gather_facts: true\r\n\r\n  tasks:\r\n    ## Install Oracle Preinstallation RPM\r\n    - name: Download Oracle preinstall rpm package\r\n      get_url:\r\n        url: https:\/\/yum.oracle.com\/repo\/OracleLinux\/OL7\/latest\/x86_64\/getPackage\/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm\r\n        dest: \/tmp\r\n\r\n    - name: Install Oracle Preinstallation\r\n      yum:\r\n        name: \/tmp\/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm\r\n        state: present\r\n\r\n    - name: Copy file for Oracle installation\r\n      copy:\r\n        src: .\/installer\/oracle-database-ee-19c-1.0-1.x86_64.rpm\r\n        dest: \/tmp\/oracle-database-ee-19c-1.0-1.x86_64.rpm\r\n        mode: 0644\r\n\r\n    - name: Install Oracle DB\r\n      become: true\r\n      yum:\r\n        name: \/tmp\/oracle-database-ee-19c-1.0-1.x86_64.rpm\r\n        state: present\r\n\r\n    ## Require to configure Oracle DB(deny to configure for \"localhost\")\r\n    - name: Replace a localhost ip address\r\n      replace:\r\n        path: \/etc\/hosts\r\n        regexp: '^127.0.0.1'\r\n        replace: '192.168.60.50'\r\n\r\n    - name: Make ansible setup status directory\r\n      file:\r\n        path: \"\/ansible_setup_status\"\r\n        state: directory\r\n        owner: \"root\"\r\n        group: \"root\"\r\n        mode: 0755\r\n\r\n    - name: \"check 'configured_oracle_db' if exist\"\r\n      stat:\r\n        path: \"\/ansible_setup_status\/configured_oracle_db\"\r\n      register: configured_oracle_db_exist\r\n\r\n    - name: Configure Oracle DB\r\n      shell:\r\n        cmd: \/etc\/init.d\/oracledb_ORCLCDB-19c configure\r\n      environment:\r\n        ORACLE_BASE: \/opt\/oracle\r\n        ORACLE_HOME: \/opt\/oracle\/product\/19c\/dbhome_1\r\n        ORACLE_SID: ORCLCDB\r\n      ignore_errors: yes\r\n      when: not configured_oracle_db_exist.stat.exists\r\n\r\n    - name: Put file to indicate completed configure Oracle DB\r\n      file: \r\n        path: \"\/ansible_setup_status\/configured_oracle_db\"\r\n        state: touch\r\n\r\n    - name: bash_profile of oracle user\r\n      ansible.builtin.lineinfile:\r\n        path: \/home\/oracle\/.bash_profile\r\n        state: present\r\n        line: \"{{ item }}\"\r\n      with_items:\r\n      - 'export ORACLE_SID=ORCLCDB'\r\n      - 'export ORACLE_BASE=\/opt\/oracle'\r\n      - 'export ORACLE_HOME=$ORACLE_BASE\/product\/19c\/dbhome_1'\r\n      - 'export PATH=$PATH:$ORACLE_HOME\/bin'\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">(A) &#8220;Oracle DB&#8221; \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u524d\u6e96\u5099\u3068\u3057\u3066\u3001Preinstallation \u3092\u884c\u3046\u3002\u3053\u306eRPM\u30d1\u30c3\u30b1\u30fc\u30b8\u306fOracle\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30da\u30fc\u30b8\u306b\u30b5\u30a4\u30f3\u30a4\u30f3\u3057\u3066\u3044\u306a\u304f\u3066\u3082\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u53ef\u80fd\u306a\u305f\u3081\u3001\u4eee\u60f3\u74b0\u5883\u304b\u3089\u76f4\u63a5\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u3088\u3046\u306b\u3057\u3066\u3044\u308b<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">(B) &#8220;Oracle DB&#8221; \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u306fOracle\u306b\u30b5\u30a4\u30f3\u30a4\u30f3\u3057\u306a\u3044\u3068\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u304c\u3067\u304d\u306a\u3044\u305f\u3081\u3001\u4e88\u3081\u30db\u30b9\u30c8PC\u306b\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u304a\u3044\u305f\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u30b3\u30d4\u30fc\u3059\u308b\u3088\u3046\u306b\u3057\u3066\u3044\u308b<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">(C) IP\u30a2\u30c9\u30ec\u30b9\u306b\u5bfe\u3059\u308b\u30db\u30b9\u30c8\u540d\u3092\u9006\u5f15\u304d\u3057\u305f\u6642\u3001&#8221;localhost&#8221;\u3060\u3068\u3001Oracle configure \u304c\u52d5\u4f5c\u3057\u306a\u3044\u305f\u3081\u3001\u30db\u30b9\u30c8\u540d\u304c\u8fd4\u5374\u3055\u308c\u308b\u3088\u3046\u306b \/etc\/hosts \u3092\u7de8\u96c6\u3057\u3066\u3044\u308b<\/ul>\n<pre class=\"post-pre\"><code>- hosts: myora2\r\n  connection: local\r\n  become: yes\r\n  gather_facts: true\r\n\r\n  tasks:\r\n    ## Install Oracle Preinstallation RPM\r\n    - name: Download Oracle preinstall rpm package\r\n      get_url:\r\n        url: https:\/\/yum.oracle.com\/repo\/OracleLinux\/OL7\/latest\/x86_64\/getPackage\/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm\r\n        dest: \/tmp\r\n\r\n    - name: Install Oracle Preinstallation\r\n      yum:\r\n        name: \/tmp\/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm\r\n        state: present\r\n\r\n    - name: Copy file for Oracle installation\r\n      copy:\r\n        src: .\/installer\/oracle-database-ee-19c-1.0-1.x86_64.rpm\r\n        dest: \/tmp\/oracle-database-ee-19c-1.0-1.x86_64.rpm\r\n        mode: 0644\r\n\r\n    - name: Install Oracle DB\r\n      become: true\r\n      yum:\r\n        name: \/tmp\/oracle-database-ee-19c-1.0-1.x86_64.rpm\r\n        state: present\r\n\r\n    ## Require to configure Oracle DB(deny to configure for \"localhost\")\r\n    - name: Replace a localhost ip address\r\n      replace:\r\n        path: \/etc\/hosts\r\n        regexp: '^127.0.0.1'\r\n        replace: '192.168.60.60'\r\n\r\n    - name: Make ansible setup status directory\r\n      file:\r\n        path: \"\/ansible_setup_status\"\r\n        state: directory\r\n        owner: \"root\"\r\n        group: \"root\"\r\n        mode: 0755\r\n\r\n    - name: \"check 'configured_oracle_db' if exist\"\r\n      stat:\r\n        path: \"\/ansible_setup_status\/configured_oracle_db\"\r\n      register: configured_oracle_db_exist\r\n\r\n    - name: Configure Oracle DB\r\n      shell:\r\n        cmd: \/etc\/init.d\/oracledb_ORCLCDB-19c configure\r\n      environment:\r\n        ORACLE_BASE: \/opt\/oracle\r\n        ORACLE_HOME: \/opt\/oracle\/product\/19c\/dbhome_1\r\n        ORACLE_SID: ORCLCDB\r\n      ignore_errors: yes\r\n      when: not configured_oracle_db_exist.stat.exists\r\n\r\n    - name: Put file to indicate completed configure Oracle DB\r\n      file: \r\n        path: \"\/ansible_setup_status\/configured_oracle_db\"\r\n        state: touch\r\n\r\n    - name: bash_profile of oracle user\r\n      ansible.builtin.lineinfile:\r\n        path: \/home\/oracle\/.bash_profile\r\n        state: present\r\n        line: \"{{ item }}\"\r\n      with_items:\r\n      - 'export ORACLE_SID=ORCLCDB'\r\n      - 'export ORACLE_BASE=\/opt\/oracle'\r\n      - 'export ORACLE_HOME=$ORACLE_BASE\/product\/19c\/dbhome_1'\r\n      - 'export PATH=$PATH:$ORACLE_HOME\/bin'\r\n<\/code><\/pre>\n<p>\u6211\u7684ora1.yml\u4e0e\u4e4b\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\uff0c\u4ec5\u4ec5\u662f\u4e3b\u673a\u540d\u548cIP\u5730\u5740\u4e0d\u540c\u3002<\/p>\n<h5>3. \u4e0b\u8f7d Oracle \u6570\u636e\u5e93<\/h5>\n<p>Oracle\u6570\u636e\u5e93\u53ef\u4ece\u4e0b\u8f7d\u9875\u9762\u4e0b\u8f7d\u5230\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d4eb637434c4406cc16c0\/21-0.png\" alt=\"oracledbdownload.PNG\" \/><\/div>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d4eb637434c4406cc16c0\/22-0.png\" alt=\"oracledbdownload2.PNG\" \/><\/div>\n<p>\u5c06\u4e0b\u8f7d\u7684rpm\u8f6f\u4ef6\u5305\u6309\u4ee5\u4e0b\u65b9\u5f0f\u653e\u7f6e\u3002<\/p>\n<pre class=\"post-pre\"><code>|-- Vagrantfile\r\n|-- ansible\r\n|   |-- hosts\r\n|   |-- installer\r\n|   |   `-- oracle-database-ee-19c-1.0-1.x86_64.rpm\u3000\u2190\u3053\u308c\r\n|   |-- myora1.yml\r\n|   `-- myora2.yml\r\n<\/code><\/pre>\n<h5>\u521b\u5efa\u865a\u62df\u73af\u5883<\/h5>\n<p>\u90a3\u4e48\uff0c\u6211\u4eec\u5c06\u4f7f\u7528\u547d\u4ee4\u6765\u521b\u5efa\u865a\u62df\u73af\u5883\u3002<\/p>\n<p>\u79fb\u52a8\u5230\u5177\u6709Vagrantfile\u7684\u76ee\u5f55\u3002<\/p>\n<pre class=\"post-pre\"><code>$ ls\r\nVagrantfile  ansible\/\r\n<\/code><\/pre>\n<p>\u6267\u884c vagrant up\uff08\u5728\u672c\u5730\u73af\u5883\u5927\u7ea6\u9700\u8981240\u5206\u949f\uff09\u3002<\/p>\n<pre class=\"post-pre\"><code>$ vagrant up --provision\r\n==&gt; vagrant: A new version of Vagrant is available: 2.2.18 (installed version: 2.2.5)!\r\n==&gt; vagrant: To upgrade visit: https:\/\/www.vagrantup.com\/downloads.html\r\n\r\nBringing machine 'myora1' up with 'virtualbox' provider...\r\nBringing machine 'myora2' up with 'virtualbox' provider...\r\n==&gt; myora1: Importing base box 'bento\/centos-7.8'...\r\n(\u7701\u7565)\r\nTASK [bash_profile of oracle user] *********************************************\r\nchanged: [myora2] =&gt; (item=export ORACLE_SID=ORCLCDB)\r\nchanged: [myora2] =&gt; (item=export ORACLE_BASE=\/opt\/oracle)\r\nchanged: [myora2] =&gt; (item=export ORACLE_HOME=$ORACLE_BASE\/product\/19c\/dbhome_1)\r\nchanged: [myora2] =&gt; (item=export PATH=$PATH:$ORACLE_HOME\/bin)\r\n\r\nPLAY RECAP *********************************************************************\r\nmyora2                     : ok=11   changed=9    unreachable=0    failed=0    skipped=0    rescued=0    ignored=0\r\n<\/code><\/pre>\n<p>3. \u767b\u5f55\u865a\u62df\u73af\u5883\u5e76\u4f7f\u7528 SQL \u5ba2\u6237\u7aef\u767b\u5f55\u5230 Oracle \u6570\u636e\u5e93\u3002<\/p>\n<pre class=\"post-pre\"><code>$ vagrant ssh myora1\r\n[vagrant@myora1 ~]$ sudo su - oracle\r\nLast login: Sat Aug 14 02:22:46 UTC 2021\r\n[oracle@myora1 ~]$ sql \/ as sysdba\r\n\r\nSQLcl: Release 19.1 Production on Sat Aug 14 03:22:45 2021\r\n\r\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.3.0.0.0\r\n\r\n\r\nSQL&gt;\r\n<\/code><\/pre>\n<p>4. \u67e5\u770b\u96c6\u88c5\u7bb1<\/p>\n<pre class=\"post-pre\"><code># \u63a5\u7d9a\u4e2d\u306e\u30b3\u30f3\u30c6\u30ca\u78ba\u8a8d\r\nSQL&gt; show con_name\r\nCON_NAME\r\n------------------------------\r\nCDB$ROOT\r\n\r\n# \u5229\u7528\u53ef\u80fd\u306aPDB\u306e\u4e00\u89a7\r\nSQL&gt; show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\n         3 ORCLPDB1                       READ WRITE NO\r\nSQL&gt;\r\n<\/code><\/pre>\n<p>\u4ee5\u4e0a<\/p>\n<h4>\u8bf7\u63d0\u4f9b\u4e00\u7bc7\u5173\u4e8e\u8fd9\u4e2a\u8bdd\u9898\u7684\u521d\u6b65\u53c2\u8003\u3002<\/h4>\n<ul class=\"post-ul\">Oracle 19c\u3092CentOS7\u306bCUI\u304b\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u53ea\u9700\u8981\u4e00\u4e2a\u9009\u62e9: &#8221;\u76ee\u6807&#8221; \u7b2c\u4e00\u6b65\u3002\u5b89\u88c5Oracle\u6570\u636e\u5e93CUI\uff08\u6b64\u6587\u7ae0\uff09\u3002 \u7b2c\u4e8c\u6b65\uff1a [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-42825","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u5c1d\u8bd5\u5728\u672c\u5730\u521b\u5efaOracle Golden Gate 19\u73af\u5883\u7684\u6b65\u9aa41\uff1a\u5b89\u88c5Oracle Database CUI - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u5728\u672c\u5730\u521b\u5efaoracle-golden-gate-19\u73af\u5883\u7684\u6b65\u9aa41\uff1a\u5b89\u88c5oracle-database-cui\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5c1d\u8bd5\u5728\u672c\u5730\u521b\u5efaOracle Golden Gate 19\u73af\u5883\u7684\u6b65\u9aa41\uff1a\u5b89\u88c5Oracle Database CUI\" \/>\n<meta property=\"og:description\" content=\"\u53ea\u9700\u8981\u4e00\u4e2a\u9009\u62e9: &#8221;\u76ee\u6807&#8221; \u7b2c\u4e00\u6b65\u3002\u5b89\u88c5Oracle\u6570\u636e\u5e93CUI\uff08\u6b64\u6587\u7ae0\uff09\u3002 \u7b2c\u4e8c\u6b65\uff1a [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u5728\u672c\u5730\u521b\u5efaoracle-golden-gate-19\u73af\u5883\u7684\u6b65\u9aa41\uff1a\u5b89\u88c5oracle-database-cui\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-05T22:37:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T05:07:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d4eb637434c4406cc16c0\/1-0.png\" \/>\n<meta name=\"author\" content=\"\u79d1, \u96c5\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u79d1, \u96c5\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8%e6%9c%ac%e5%9c%b0%e5%88%9b%e5%bb%baoracle-golden-gate-19%e7%8e%af%e5%a2%83%e7%9a%84%e6%ad%a5%e9%aa%a41%ef%bc%9a%e5%ae%89%e8%a3%85oracle-database-cui%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8%e6%9c%ac%e5%9c%b0%e5%88%9b%e5%bb%baoracle-golden-gate-19%e7%8e%af%e5%a2%83%e7%9a%84%e6%ad%a5%e9%aa%a41%ef%bc%9a%e5%ae%89%e8%a3%85oracle-database-cui%e3%80%82\/\",\"name\":\"\u5c1d\u8bd5\u5728\u672c\u5730\u521b\u5efaOracle Golden Gate 19\u73af\u5883\u7684\u6b65\u9aa41\uff1a\u5b89\u88c5Oracle Database CUI - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-11-05T22:37:16+00:00\",\"dateModified\":\"2024-04-29T05:07:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8%e6%9c%ac%e5%9c%b0%e5%88%9b%e5%bb%baoracle-golden-gate-19%e7%8e%af%e5%a2%83%e7%9a%84%e6%ad%a5%e9%aa%a41%ef%bc%9a%e5%ae%89%e8%a3%85oracle-database-cui%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8%e6%9c%ac%e5%9c%b0%e5%88%9b%e5%bb%baoracle-golden-gate-19%e7%8e%af%e5%a2%83%e7%9a%84%e6%ad%a5%e9%aa%a41%ef%bc%9a%e5%ae%89%e8%a3%85oracle-database-cui%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8%e6%9c%ac%e5%9c%b0%e5%88%9b%e5%bb%baoracle-golden-gate-19%e7%8e%af%e5%a2%83%e7%9a%84%e6%ad%a5%e9%aa%a41%ef%bc%9a%e5%ae%89%e8%a3%85oracle-database-cui%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5c1d\u8bd5\u5728\u672c\u5730\u521b\u5efaOracle Golden Gate 19\u73af\u5883\u7684\u6b65\u9aa41\uff1a\u5b89\u88c5Oracle Database CUI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a\",\"name\":\"\u79d1, \u96c5\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g\",\"caption\":\"\u79d1, \u96c5\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/keya\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8%e6%9c%ac%e5%9c%b0%e5%88%9b%e5%bb%baoracle-golden-gate-19%e7%8e%af%e5%a2%83%e7%9a%84%e6%ad%a5%e9%aa%a41%ef%bc%9a%e5%ae%89%e8%a3%85oracle-database-cui%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5c1d\u8bd5\u5728\u672c\u5730\u521b\u5efaOracle Golden Gate 19\u73af\u5883\u7684\u6b65\u9aa41\uff1a\u5b89\u88c5Oracle Database CUI - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u5728\u672c\u5730\u521b\u5efaoracle-golden-gate-19\u73af\u5883\u7684\u6b65\u9aa41\uff1a\u5b89\u88c5oracle-database-cui\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5c1d\u8bd5\u5728\u672c\u5730\u521b\u5efaOracle Golden Gate 19\u73af\u5883\u7684\u6b65\u9aa41\uff1a\u5b89\u88c5Oracle Database CUI","og_description":"\u53ea\u9700\u8981\u4e00\u4e2a\u9009\u62e9: &#8221;\u76ee\u6807&#8221; \u7b2c\u4e00\u6b65\u3002\u5b89\u88c5Oracle\u6570\u636e\u5e93CUI\uff08\u6b64\u6587\u7ae0\uff09\u3002 \u7b2c\u4e8c\u6b65\uff1a [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u5728\u672c\u5730\u521b\u5efaoracle-golden-gate-19\u73af\u5883\u7684\u6b65\u9aa41\uff1a\u5b89\u88c5oracle-database-cui\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-11-05T22:37:16+00:00","article_modified_time":"2024-04-29T05:07:00+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d4eb637434c4406cc16c0\/1-0.png"}],"author":"\u79d1, \u96c5","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u79d1, \u96c5","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"6 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8%e6%9c%ac%e5%9c%b0%e5%88%9b%e5%bb%baoracle-golden-gate-19%e7%8e%af%e5%a2%83%e7%9a%84%e6%ad%a5%e9%aa%a41%ef%bc%9a%e5%ae%89%e8%a3%85oracle-database-cui%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8%e6%9c%ac%e5%9c%b0%e5%88%9b%e5%bb%baoracle-golden-gate-19%e7%8e%af%e5%a2%83%e7%9a%84%e6%ad%a5%e9%aa%a41%ef%bc%9a%e5%ae%89%e8%a3%85oracle-database-cui%e3%80%82\/","name":"\u5c1d\u8bd5\u5728\u672c\u5730\u521b\u5efaOracle Golden Gate 19\u73af\u5883\u7684\u6b65\u9aa41\uff1a\u5b89\u88c5Oracle Database CUI - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-11-05T22:37:16+00:00","dateModified":"2024-04-29T05:07:00+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8%e6%9c%ac%e5%9c%b0%e5%88%9b%e5%bb%baoracle-golden-gate-19%e7%8e%af%e5%a2%83%e7%9a%84%e6%ad%a5%e9%aa%a41%ef%bc%9a%e5%ae%89%e8%a3%85oracle-database-cui%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8%e6%9c%ac%e5%9c%b0%e5%88%9b%e5%bb%baoracle-golden-gate-19%e7%8e%af%e5%a2%83%e7%9a%84%e6%ad%a5%e9%aa%a41%ef%bc%9a%e5%ae%89%e8%a3%85oracle-database-cui%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8%e6%9c%ac%e5%9c%b0%e5%88%9b%e5%bb%baoracle-golden-gate-19%e7%8e%af%e5%a2%83%e7%9a%84%e6%ad%a5%e9%aa%a41%ef%bc%9a%e5%ae%89%e8%a3%85oracle-database-cui%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5c1d\u8bd5\u5728\u672c\u5730\u521b\u5efaOracle Golden Gate 19\u73af\u5883\u7684\u6b65\u9aa41\uff1a\u5b89\u88c5Oracle Database CUI"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a","name":"\u79d1, \u96c5","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g","caption":"\u79d1, \u96c5"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/keya\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8%e6%9c%ac%e5%9c%b0%e5%88%9b%e5%bb%baoracle-golden-gate-19%e7%8e%af%e5%a2%83%e7%9a%84%e6%ad%a5%e9%aa%a41%ef%bc%9a%e5%ae%89%e8%a3%85oracle-database-cui%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=42825"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42825\/revisions"}],"predecessor-version":[{"id":85452,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42825\/revisions\/85452"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=42825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=42825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=42825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}