Category
产品版本
主题
副主题
Does compare/repair work with DML filtering? (4377594)
<p>Does compare/repair work with DML filtering?</p> <p>No - the compare/repair utility does not work on a table that is configured with DML filtering.</p>
Does SharePlex for PostgreSQL support the use of a Hints file? (4376506)
Does SharePlex for PostgreSQL support the use of a Hints file?<br> No.<br><br>The Hints utility is only available when posting to Oracle.<br>SharePlex supports it's use when replicating from Oracle to Oracle, and from PostgreSQL to Oracle.<br>But not when posting to PostgreSQL.<br>
Oracle Instant Client support for remote capture (4374507)
As Oracle releases different types of Oracle clients for different purposes like instant client basic, instant client lite, SqlPlus package. ... What kind of instant client packages required for SharePlex remote capture?
Is there a maximum limit for number of tables per post queue? (4273910)
No, there is no limit.
Which SCN number should I reconcile to? (4278248)
The reconcile process will remove committed transactions less than or equal to reconcile scn# minus 1 ... 1. If using rman ‘recover until scn xxx’, then use the same SCN for reconcile ... Example: rman recover until 100, oracle recovers data with committed transaction through 99, then use 100 in reconcile command
How does SharePlex detect out of sync? (4272839)
<p>Please refer to the "Understanding synchronization" chapter in the SharePlex Administrator’s Guide.</p><p></p>
What are some ways to correct out of sync. (4263755)
<p>Please refer to the following chapter "Solving Synchronization Problems" in the SharePlex Reference Guide.</p>
What does parameter SP_OPO_TRACK_PREIMAGE do? (4277635)
This parameter controls whether or not the Post process tracks the column values before a row is updated. ... If this parameter is 1, Post will insert two rows for every update, one with the column values before the change, and one with the column values after the change.
Does shareplex support encrypted data? (4263758)
<p>Starting with version 7.6.0, SharePlex can support encrypted data whether the column, the table, or the tablespace is encrypted.</p><p>For more information, please refer to the SharePlex Administrator Guide.</p>
What does the reconcile command do? (4268087)
The reconcile command coordinates the results of ongoing replication with a hot copy of the source data that is applied to the target system by an Oracle hot-backup. ... After the target instance has been recovered and opened, the reconcile function compares the replicated changes in the post queue with the state of the target instance after the recovery process.
What is change history? (4272842)
<p>Use change history to facilitate the auditing of changes to the source tables. ... A change history target differs from a replication database target in that a change history target maintains a record of every change that occurs to a source database, rather than simply maintaining a mirror of the current state of the source database.
Where is the SharePlex logs located? (4328982)
On window, it is the value of SP_SYS_VARDIR in the register for the port.
What log it writes to when activate config (4328432)
It writes to vardir/log/ *oconf*.log and *.rep in 8.x, *config*log is in 7.6
SharePlex run on source if the target does not exist, what are repercussions? (4328998)
Yes, but the messages for replication will be filling up the export Queue, unless it’s configured for replication between source and target on the same system. ... When the source and target are on same server, reader places the messages on the post Queue directly as there is no need to use a network.
As a best practice, what SharePlex environment variables should set to run SharePlex (4328978)
Following SP variables should be set for the replication:<p>SP_COP_UPORT, SP_COP_TPORT, SP_SYS_BINDIR,SP_SYS_PRODIR and SP_SYS_VARDIR, oracle_SID, oracle_home, and SP_SYS_HOST_NAME</p>
What document describes what SharePlex does and does not replicate? (4328819)
The latest Release notes defines what objects/components are in scope or not in scope for replication at the time of that version release.
Does SharePlex replication work between different O/S platform (4328651)
Yes, Shareplex source and target can be on different Operating system. ... For supported OS, please refer to the Release Notes of the version being installed..
Does SharePlex need to run on the same port on source and target? (4325019)
Yes, Shareplex source and target should run on the same port.
Does SharePlex support Oracle Standard Edition? (4328605)
<p>Yes, SharePlex does support Oracle Standard Edition.</p>
What Oracle version and O/S combination does SharePlex support? (4332652)
<p>Refer to the latest SharePlex release notes for supported platform. ... If you do not see the platform in SharePlex Release Notes, please check Oracle Certifications Matrix.
My source and target data are not in sync, but I want post to always overwrite target data. How to do that? (4269554)
UpdateUsingKeyOnly as default in conflict_resolution.SID file on var dir/state like below ... !Default U ! ... UpdateUsingKeyOnly
Does SharePlex support nested table? (4278254)
No, SharePlex does not support nested tables.
Support for PDB (pluggable databases in an Oracle multitenant container environment) FAQs 1. Does Shareplex support replication of PDB (pluggable databases in an Oracle multitenant container environment)? 2 .What combinations are supported? 3. Can a Sha (4330912)
Question: Does Shareplex support replication of PDB (pluggable databases in an Oracle multitenant container environment)? ... Answer: The following are supported: ... Replication from a non-multitenant container database to a PDB
sp_wallet fails to load with error 'Error opening wallet' (4303102)
Error in event_log: ... Error 2015-12-04 00:49:52.734024 14156188 1 Cop: No such file or directory Cannot open +DATADG/ECDAPRF/WALLET/ewallet.p12 for reading [module cop] ... Wallet is on ASM and is available for SharePlex user to read.
Copy error “Error/Warning Detected: EXP-00111: Table TABLE_NAME resides in an Encrypted Tablespace TABLESPACE_NAME and will not be exported” (4297476)
The following errors are observed when running copy for a source table that resides in an encrypted tablespace: ... 1 "OWNER"."SOURCE_TABLE" Failed - An error occurred in export: EXP-00111: Table SOURCE_TABLE resides in an Encrypted Tablespace TABLESPACE_NAME and will not be exported
新产品关联性