OGG-00664 OCI Error ORA (status = 904-ORA-00904: “SERVER_NAME”: invalid identifier for Goldengate 19c

Hi,

You can get ” OGG-00664 OCI Error ORA (status = 904-ORA-00904: “SERVER_NAME”: invalid identifier ).” error during replicate process is abended.

Details of error are as follows.

2020-01-27 09:59:17 INFO OGG-08549 416,881 records processed as of 2020-01-27 09:59:17.397103 (rate 690, delta 690).

Source Context :
SourceModule : [ggdb.ora.ocicpp.err]
SourceID : [ggdbora/ocicpp/OCIErrorHandler.cpp]
SourceMethod : [dpiErr]
SourceLine : [121]
ThreadBacktrace : [20] elements
: [/ggateb01/goldengate/product/19.1.0.0.4/libgglog.so(CMessageContext::AddThreadContext())]
: [/ggateb01/goldengate/product/19.1.0.0.4/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/ggateb01/goldengate/product/19.1.0.0.4/libgglog.so(_MSG_Int32_String_String(CSourceContext*, int, int, char const*, char const*, CMessageFactory::MessageDisposition))]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat(ggs::gglib::ggocicpp::OCIErrorHandler::dpiErr(dpi::Exception&) const)]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat(ggs::gglib::ggocicpp::OCIStatement::execStatement(int))]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat(ggs::gglib::ggocicpp::ORAConnection::execStmt(ggs::gglib::ggunicode::UString const*))]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat()]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat()]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat(process_update_stats(extr_ptr_def*, std_rec_hdr_def*, stat_rollover_ts_def*, bool, short, ggs::gglib::ggmetadata::MetadataContext&))]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat(ggs::er::ReplicatContext::replicate_io(ggs::gglib::gglcr::CommonLCR const*, ggs::gglib::gglcr::CommonLCR*, extr_ptr_def*, bool, int&, RepCsn&, bool*))]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat(ggs::er::ReplicatContext::processRecord(ggs::gglib::gglcr::CommonLCR const*, ggs::gglib::gglcr::CommonLCR*, extr_ptr_def*&, extr_ptr_def*&, bool&, int&, bool, RepCsn&))]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat(ggs::er::ReplicatContext::processReplicatLoop())]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat(ggs::er::ReplicatContext::run())]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat()]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/ggateb01/goldengate/product/19.1.0.0.4/replicat()]

2020-01-27 10:00:02 ERROR OGG-00664 OCI Error ORA (status = 904-ORA-00904: "SERVER_NAME": invalid identifier

This error is occured because of incompatibility Goldengate home and RDBMS home.

In this example Our Goldengate version is 19c and DB is 18c.

But Goldengate was installed for Oracle 11g, it should be 18c.

Oracle GoldenGate Delivery 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:43

Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.

Starting at 2020-01-27 09:49:09
***********************************************************************

2020-01-27 09:49:11 INFO OGG-25340
Database Version:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production.

2020-01-27 09:49:11 INFO OGG-25341
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8".

To solve this problem, we need to install a fresh Goldengate 19c software which is compatible with 18c RDBMS as follows.

Delete replicate at the Old Goldengate home, and add it at the new Goldengate home, it will work successfuly.

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

https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/