Configure the Oracle database as the publishing Server on the SQL Server distribution Server

How can I configure an Oracle database as an Oracle Publishing Server? This is a problem that many people have mentioned. The following describes how to configure the Oracle database as a publishing Server on the SQL Server distribution Server for your reference.

Oracle publishing servers always use remote distribution servers. You must configure an SQL Server instance as the distribution Server of the Oracle Publishing Server. An Oracle Publishing Server can only use one distribution Server, but a single distribution Server can provide services for multiple Oracle publishing servers ). After configuring the distribution Server, identify the Oracle database instance as the publishing Server on the SQL Server distribution Server through SQL Server Management Studio, Transact-SQL, or copy management object (RMO. For more information about Oracle Database Configuration distributor, see configure distribution.

Note:
The Oracle Publishing Server cannot have the same name as its SQL Server distribution Server or any SQL Server distribution Server that uses the same distribution Server.

When you identify an Oracle database as a Publishing Server, You must select the Oracle release option: "complete" or "Oracle Gateway ". If you do not delete the Publishing Server and configure the Publishing Server again in the Oracle database, you cannot change this option. The "complete" option is used to provide a complete set of supported features released by Oracle for snapshot and transaction Publishing. The Oracle Gateway option provides specific design Optimizations to improve performance when replication is used as a Gateway between systems.

After the Oracle Publishing Server is identified on the SQL Server distribution Server, copy and create a linked Server with the same name as the TNS service name of the Oracle database. This linked server can only be used by replication. To connect to the Oracle Publishing Server by connecting to the server, create another TNS service name and use this name when calling sp_addmediaserver (Transact-SQL.
 

Addition and subtraction of oracle time

Oracle date formatting implementation

Oracle memory structure-SGA

Learn about the ORACLE resource role

Oracle data export and import Permissions