IT Tutorial

OCI Error ORA (status = 1034-ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist during Dblogin Goldengate

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>

 

 

 

Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.

Oracle Goldengate Tutorials for Beginners

 765 views last month,  3 views today

Exit mobile version