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.

[[email protected] 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 [email protected], 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.

 

[[email protected] 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 [email protected], password GoldenGate135246*
Successfully logged into database.

GGSCI (msdbadm01 as [email protected]) 2>

 

 

 

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

Oracle Goldengate Tutorials for Beginners

 503 views last month,  2 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Do NOT follow this link or you will be banned from the site!