使用系统用户登录执行marker_setup.sql oracle会出现hang住不动
[
oracle@n3 ~]$ cd /opt/app/OGG/
使用ogg的传输数据用户,这里是ogg问题解决
[
oracle@n3 OGG]$ sqlplus ogg/ogg
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 1 11:15:43 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> @marker_setup.sql
Marker setup script
You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter GoldenGate schema name:ogg
Marker setup table script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to OGG
MARKER TABLE
--------------------------------------------------------------------------------
OK
MARKER SEQUENCE
--------------------------------------------------------------------------------
OK
Script complete.