ogg 12.3 DownStream Extract 下游注册报错 DB12CR2
来源:互联网 发布:qq 知乎 编辑:程序博客网 时间:2024/04/29 19:02
GGSCI (oradb) 1> DBLOGIN USERID c##ogg@yd password ogg
Successfully logged into database CDB$ROOT.
GGSCI (oradb as c##ogg@yd/CDB$ROOT) 2> MININGDBLOGIN USERID c##ogg password ogg
Successfully logged into mining database.
GGSCI (oradb as c##ogg@yd/CDB$ROOT) 3> REGISTER EXTRACT ext1 database container(PDB1)
2017-11-21 15:52:23 INFO OGG-15419 Standby Redo Logs were not detected on the downstream database.
2017-11-21 15:52:23 ERROR OGG-08233 ERROR: The global name of the database container PDB1 is in restricted mode
www.rkffb.cn
www.jplxm.cn
www.bnjcx.cn
www.lzmdg.cn
www.bmfnr.cn
www.hsfpp.cn
www.jfclt.cn
www.jgwnn.cn
www.wtjmg.cn
www.frydt.cn
www.wjqbs.cn
www.mxfgl.cn
www.slqrs.cn
www.rgglg.cn
www.qbgtr.cn
-----------------环境信息-------------------------
源端 上游
$ cat /etc/hosts
192.168.168.95 12C
www.wqsjl.cn
www.vmtrck.cn
www.zfzozh.cn
www.oygtll.cn
www.mqoqzb.cn
www.buwpxf.cn
www.bqfgdl.cn
www.uqlbnw.cn
www.panujt.cn
www.zirivk.cn
www.suztkw.cn
www.ptbdys.cn
www.vudvam.cn
www.zlshtr.cn
www.lpjzii.cn
www.wqstj.cn
www.htqwb.info
www.lgpby.info
www.wtbzz.info
www.prhxj.info
www.qqyfq.info
www.wfqft.cn
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cdb_cluster_name string yd
cell_offloadgroup_name string
db_file_name_convert string
db_name string yd
db_unique_name string yd
global_names boolean FALSE
instance_name string yd
lock_name_space string
log_file_name_convert string
pdb_file_name_convert string
processor_group_name string
service_names string yd
SQL> select name,open_mode from v$Pdbs;
NAME
--------------------------------------------------------------------------------
OPEN_MODE
----------
PDB$SEED
READ ONLY
PDB1
READ WRITE
-------下游
$ cat /etc/hosts
192.168.168.231 oradb
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cdb_cluster_name string orcl
cell_offloadgroup_name string
db_file_name_convert string
db_name string orcl
db_unique_name string orcl
global_names boolean FALSE
instance_name string orcl
lock_name_space string
log_file_name_convert string
pdb_file_name_convert string
processor_group_name string
service_names string orcl
SQL>
SQL>
SQL> select name,open_mode from v$pdbs;
NAME
--------------------------------------------------------------------------------
OPEN_MODE
----------
PDB$SEED
READ ONLY
ORCLPDB
READ WRITE
tnsnames.ora
[oracle@oradb admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.231)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.231)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
pdb1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.95)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdb1)
www.msqkp.cn
www.trwjp.cn
www.gwdyr.cn
www.wlysk.cn
www.pqhsw.cn
www.mknzz.cn
www.smknq.cn
www.prpyq.cn
www.mtrwp.cn
www.kknhg.cn
www.xgtzh.cn
www.rkmnx.cn
www.krrlb.cn
www.gqkzd.cn
)
yd =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.95)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = yd)
)
)
- ogg 12.3 DownStream Extract 下游注册报错 DB12CR2
- GG做extract时报错OGG-00053
- OGG-01031报错
- ogg extract 参数配置
- OGG报错:ERROR OGG-01028解决办法
- OGG 添加extract失败 OGG-01756
- oracle 11.2.0.4 ogg 12.3.0.1.0备库rep进程启动报错OGG-00446
- 处理ogg恢复进程报错ERROR OGG-01161
- OGG-01738 BOUNDED RECOVERY 报错
- Goldengate报错之ERROR OGG-06551
- ogg修改extract进程从当前抽取
- GG做init data load时,报错OGG-01192,OGG-01668
- oracle ogg同步到kafka不抓数据,重启ogg报错
- OGG 机器重起后挂起,无明显报错信息
- ogg报错 No viable tables matched specification.
- 【OGG】SqlServer同步源端增加trandata报错解决
- ogg sourceistable extract parameter files - as an etl tool
- 【OGG-01414】extract abend CACHEMGR: tran id: 0 length memtran
- window和centos网络共享,文件名大写问题
- 自学笔记:显示mnist官方数据的的图片和标签
- 如何获得C币
- xshell、xftp过期等情况处理
- JAVA中堆栈和内存分配详解
- ogg 12.3 DownStream Extract 下游注册报错 DB12CR2
- MVP二级购物车
- Spring 事务管理
- 概率论的一些随笔
- 图片处理1
- linux常用命令
- UICollectionView 自定义布局教程: Pinterest
- 多条目
- 两个Json串merge