extract will not start after upgrade to 18.104.22.168.4 when extract is not installed on the DB Server
Last updated on FEBRUARY 03, 2017
Applies to:Oracle GoldenGate - Version 22.214.171.124.4 to 126.96.36.199.4 [Release 188.8.131.52]
Information in this document applies to any platform.
Your DB Server and OGG are not on the same server and prior release of OGG has run without problem, but
After an upgrade to OGG 184.108.40.206.4 you are unable to start OGG or use GGSCI> dblogin to connect to the DB.
Here are some messages you may see in your Extract report file when you attempt to start OGG 220.127.116.11.4 Extract
012-07-21 14:23:17 ERROR OGG-00664 OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory).
2012-07-21 14:23:17 ERROR OGG-01668 PROCESS ABENDING.
Or you may see this error in your Extract
2012-07-21 11:22:42 ERROR OGG-00664 OCI Error during OCIServerAttach (status = 12545-Error while trying to retrieve text for error ORA-12545).
2012-07-21 11:22:42 ERROR OGG-01668 PROCESS ABENDING.
You will see GGSCI fail to connect to the DB server that is REMOTE
GGSCI 3> dblogin userid gg@remoteDB
ERROR: Failed to open data source for user GG.
Upgrading to Or Installing OGG 18.104.22.168.4 will cause this issue to occur if your DB Server and your Goldengate software are not on the same server
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms