Xshell 5 (Build 1124)
Copyright (c) 2002-2017 NetSarang Computer, Inc. All rights reserved.
Type `help' to learn how to use Xshell prompt.
[d:\~]$
Connecting to 192.168.1.55:22...
Connection established.
To escape to local shell, press 'Ctrl+Alt+]'.
Last login: Wed Apr 5 21:03:23 2017 from 192.168.1.1
[root@middle ~]# su - oracle
[oracle@middle ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.5.0 - Production on Sat Apr 8 04:08:34 2017
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> connect /as sysDBA
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 599785472 bytes
Fixed Size 2098112 bytes
Variable Size 163580992 bytes
Database Buffers 427819008 bytes
Redo Buffers 6287360 bytes
Database mounted.
Database opened.
SQL> !lsnrctl start
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 08-APR-2017 04:08:52
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.5.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=middle)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=middle)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 08-APR-2017 04:08:53
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/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=middle)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service " LSExtProc" has 1 instance(s).
Instance "LSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
SQL> alter system register;
System altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@middle ~]$ sp_cop &
[1] 4259
[oracle@middle ~]$
*******************************************************
* SharePlex for Oracle Startup
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
* Version: 8.6.6.64-m64-oracle100
* VarDir : /u01/app/oracle/vardir2100
* Port : 2100
*******************************************************
[oracle@middle ~]$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (middle:2100)>
sp_ctrl (middle:2100)> status
Brief Status for middle
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 4259 08-Apr-17 04:09:08
Capture Stopped by user
Read Stopped by user
Post Stopped by user
Cmd & Ctrl Running 4262 08-Apr-17 04:09:16
System is used as a source machine
There is 1 active configuration file
sp_ctrl (middle:2100)> start capture
sp_ctrl (middle:2100)> start read
sp_ctrl (middle:2100)> start post
sp_ctrl (middle:2100)> status
Brief Status for middle
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 4259 08-Apr-17 04:09:08
Capture Running 4263 08-Apr-17 04:09:21
Read Running 4275 08-Apr-17 04:09:26
Post Running 4296 08-Apr-17 04:09:29
Cmd & Ctrl Running 4262 08-Apr-17 04:09:16
System is used as a source machine
There is 1 active configuration file
sp_ctrl (middle:2100)>
sp_ctrl (middle:2100)>
sp_ctrl (middle:2100)> list config
File Name State Datasource
-------------------------------------------------- ---------- ---------------
ORA_config Inactive o.SOURCE_SID
Last Modified At: 05-Apr-17 21:22 Size: 151
test Active o.orcl
Last Modified At: 05-Apr-17 21:37 Size: 206 Internal Name: .conf.1
sp_ctrl (middle:2100)> view config test
datasource .orcl
#source tables target tables routing map
splex.demo_src splex.demo_dest target_system@o.target_sid
source.t1 target.t1 middle@o.orcl
sp_ctrl (middle:2100)>
sp_ctrl (middle:2100)>
sp_ctrl (middle:2100)>
sp_ctrl (middle:2100)>
sp_ctrl (middle:2100)> stop capture
sp_ctrl (middle:2100)> stop read
sp_ctrl (middle:2100)> stop post
sp_ctrl (middle:2100)> shutdown
[oracle@middle ~]$ cd /u01/app/oracle/vardir2100/config/
[1]+ Done sp_cop (wd: ~)
(wd now: /u01/app/oracle/vardir2100/config)
[oracle@middle config]$ ls
ORA_config test
[oracle@middle config]$ vi test
[oracle@middle config]$ cat test
datasource.orcl
#source tables target tables routing map
splex.demo_src splex.demo_dest target_system@o.target_sid
expand source.% target.% middle*middle@o.orcl
[oracle@middle config]$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (middle:2100)> status
Brief Status for middle
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 4441 08-Apr-17 04:15:16
Capture Stopped by user
Read Stopped by user
Post Stopped by user
Cmd & Ctrl Running 4443 08-Apr-17 04:15:19
System is used as a source machine
There is 1 active configuration file
sp_ctrl (middle:2100)> list config
File Name State Datasource
-------------------------------------------------- ---------- ---------------
ORA_config Inactive o.SOURCE_SID
Last Modified At: 05-Apr-17 21:22 Size: 151
test Active o.orcl
Last Modified At: 05-Apr-17 21:37 Size: 212 Internal Name: .conf.1
sp_ctrl (middle:2100)> deactivate config test
sp_ctrl (middle:2100)> activate config test
Not all tables activated successfully
sp_ctrl (middle:2100)> status
Brief Status for middle
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 4441 08-Apr-17 04:15:16
Capture Stopped by user
Read Stopped by user
Post Stopped by user
Cmd & Ctrl Running 4443 08-Apr-17 04:15:19
System is used as a source machine
There is 1 active configuration file
sp_ctrl (middle:2100)> start capture
sp_ctrl (middle:2100)> start read
sp_ctrl (middle:2100)> start post
sp_ctrl (middle:2100)> status
Brief Status for middle
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 4441 08-Apr-17 04:15:16
Capture Running 4466 08-Apr-17 04:16:40
Read Running 4474 08-Apr-17 04:16:43
Post Running 4494 08-Apr-17 04:16:46
Cmd & Ctrl Running 4443 08-Apr-17 04:15:19
Export Running 4499 08-Apr-17 04:16:47
Import Running 4500 08-Apr-17 04:16:47
System is used as a source machine
There is 1 active configuration file
sp_ctrl (middle:2100)> view config test
datasource.orcl
#source tables target tables routing map
splex.demo_src splex.demo_dest target_system@o.target_sid
expand source.% target.% middle*middle@o.orcl
|
|
京ICP备12024223-8号
不良信息举报电话：13718043309
转播
分享
淘帖