Hi,
You can get ” OCI Error ORA (status = 1034-ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist ” error during Dblogin in Goldengate.
Details of error are as follows.
[ggate@msdbadm01 19.1.0.0.4]$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO Linux, x64, 64bit (optimized), Oracle 11g on Oct 17 2019 23:13:12 Operating system character set identified as UTF-8. Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved. GGSCI (msdbadm01) 1> dblogin userid GGS_ADMIN@MSDB, password GoldenGate135246* ERROR: OCI Error ORA (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 Process ID: 0 Session ID: 0 Serial number: 0 ). GGSCI (msdbadm01) 2>
This error is related with the missing Oracle SID and Oracle Home, To solve this error add the following lines into parameter file.
SETENV (ORACLE_SID=MSDB) SETENV (ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_home)
Or Check your TNS Alias if it contains correct values for SID and IP.
I have created a static listener for the Goldengate as follows, then use it. Add following statis listener description into listener.ora under $ORACLE_HOME/network/admin. Then start listener.
LISTENER_GG =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.63.35)(PORT = 1521))
)
)
SID_LIST_LISTENER_GG =
(SID_LIST =
(SID_DESC =
(SID_NAME = MSDB1)
(ORACLE_HOME = /u01/app/oracle/product/12.2.0/db_home)
(SERVICE_NAME = MSDB)
)
)
lsnrctl start LISTENER_GG
Now When I try to run dblogin command, it is successful. The problem is related with the registered listener in my case.
So I have created a new static listener, then it works fine as follows.
[ggate@msdbadm01 19.1.0.0.4]$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO Linux, x64, 64bit (optimized), Oracle 11g on Oct 17 2019 23:13:12 Operating system character set identified as UTF-8. Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved. GGSCI (msdbadm01) 1> dblogin userid GGS_ADMIN@MSDB, password GoldenGate135246* Successfully logged into database. GGSCI (msdbadm01 as GGS_ADMIN@MSDB1) 2>