启动命令：Oracle数据库和OGG服务（docker）

启动命令：Oracle数据库和OGG服务（docker）

使用VMWare 启动node1.itcast.cn虚拟机，使用root用户（密码123456）登录

1) 启动容器

# 查看容器
[root@node1 ~]# docker ps -a
cb7a41433712        kungkk/oracle11g_centos7:latest   "/bin/bash"              myoracle

# 启动容器
[root@node1 ~]# docker start myoracle
myoracle

# 容器状态
[root@node1 ~]# docker ps
cb7a41433712        kungkk/oracle11g_centos7:latest   Up 39 seconds       0.0.0.0:1521->1521/tcp   myoracle

# 进入容器
[root@node1 ~]# docker exec -it myoracle /bin/bash
[root@server01 oracle]# 

2) 启动Oracle数据库服务

# 进入容器
[root@node1 ~]# docker exec -it myoracle /bin/bash
[root@server01 oracle]# 

# 切换用户oracle
[root@server01 oracle]# su - oracle
Last login: Mon Dec 28 06:20:10 UTC 2020 on pts/0
-bash: warning: setlocale: LC_ALL: cannot change locale (en_US): No such file or directory
-bash: warning: setlocale: LC_ALL: cannot change locale (en_US): No such file or directory
[oracle@server01 ~]$ 

# sqlplus命令位置
[oracle@server01 ~]$ which sqlplus
/u01/app/oracle/product/11.2.0/bin/sqlplus

# 以DBA角色登录sqlplus
[oracle@server01 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 30 15:54:07 2020
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> 

# 启动数据库服务
SQL> startup

# 当监听服务启动以后，执行SQL
SQL> select instance_name AS "SID",host_name,version  from v$instance;
SID
--------------------------------
HOST_NAME
--------------------------------------------------------------------------------
VERSION
----------------------------------
orcl
server01
11.2.0.1.0

3) 启动Oracle监听服务

# 进入容器
[root@node1 ~]# docker exec -it myoracle /bin/bash
[root@server01 oracle]# 

# 切换用户oracle
[root@server01 oracle]# su - oracle
Last login: Mon Dec 28 06:20:10 UTC 2020 on pts/0
-bash: warning: setlocale: LC_ALL: cannot change locale (en_US): No such file or directory
-bash: warning: setlocale: LC_ALL: cannot change locale (en_US): No such file or directory
[oracle@server01 ~]$ 

# 切换到oracle bin 目录
[oracle@server01 ~]$ cd $ORACLE_HOME/bin 
[oracle@server01 bin]$ 

# 启动监听
[oracle@server01 bin]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 30-DEC-2020 15:57:08
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
Starting /u01/app/oracle/product/11.2.0//bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/server01/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server01)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                30-DEC-2020 15:57:10
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/server01/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server01)(PORT=1521)))
The listener supports no services
The command completed successfully

4) 启动OGG服务

切换到 oracle 账号，并且启动Oracle数据库
第一步：启动源端mgr进程
[root@node1 ~]# docker exec -it myoracle /bin/bash
[root@server01 oracle]# su - oracle
[oracle@server01 ~]$ cd $OGG_SRC_HOME
[oracle@server01 src]$ ./ggsci	
GGSCI (server01) 1> info all
GGSCI (server01) 2> start mgr

第二步：启动目标端mgr进程
[root@node1 ~]# docker exec -it myoracle /bin/bash
[root@server01 oracle]# su - oracle
[oracle@server01 ~]$ cd $OGG_TGR_HOME
[oracle@server01 tgr]$ ./ggsci
GGSCI (server01) 1> start mgr
GGSCI (server01) 2> info all

第三步：启动源端extract进程
GGSCI (server01) 4> start extkafka

第四步：启动源端pump进程
GGSCI (server01) 5> start pukafka

第五步：启动目标端replicate进程
GGSCI (server01) 7> start rekafka