Search: Advanced search

SDE Replication Oracle

Article ID: 458

Last updated: 27 Dec, 2019

Revision: 1

Export to PDF

Email to friend

The SDE Replication Oracle monitoring point checks to verify if a scheduled Oracle replication has happened, and whether or not it was successful.

There is not currently a scheduler in the GeoSystems Monitor, so scheduling information needs to be added as parameters to the point check. Presently, the point can check every day of the week at a certain time, or the user can enter single/multiple days of the week and a time (for example, all:22 would run a check every day at 10 P.M. 1,2,4:21 would run a check on Sunday, Monday, and Wednesday at 9 P.M.)

Note that the time entered for the point check should be set after the scheduled replication is to occur by approximately one hour (for example, if replication is set to run at 2100 (9 P.M.), set the point to start checking at 22 (10 P.M.).

The parameters that are unique to the SDE Replication Oracle include:

Server Name	Server name where SDE database is located
Svr NM w/Listener	Oracle Database name with TNS listener (ex. Servername:TNS listener) ex. VOracle12c:1521/orclpdb.vestra.ad VOracle11g:1521/vector
Replication Name	Name of Oracle replication
Schema SDE/User	SDE or user
userID:PW	user ID and user PW with access to the Oracle database (Note colon separating User ID:PW) (Database Authentication). If using Windows AD authentication, enter Domain\UserID:PW *Note:* userID and userPW should be entered as encrypted information
Days:Time	Presently, the point can check every day of the week at a certain time, or the user can enter single/multiple days of the week and a time (for example, all:22 would run a check every day at 10 P.M. 1,2,4:21 would run a check on Sunday, Monday, and Wednesday at 9 P.M.

Prev		Next
SDE Replication MSSQL		SDE Replication Postgres