ERROR OGG-00664 OCI Error during OCIServerAttach (status = 12162-ORA-12162:

Scenario # Rebooted golden gate process, Pump Abended with following error <

Investigated  Issue and found root cause # 

ggsci> View report plct90

.....

....

............

extract plct90

passthru

userid ggsuser, password *******

Source Context :

  SourceModule            : [ggdb.ora.sess]

  SourceID                : [/scratch/aime1/adestore/views/aime1_staxj04/oggcore

/OpenSys/src/gglib/ggdbora/ocisess.c]

  SourceFunction          : [OCISESS_context_def::oci_try(int, const char *, ...)]

  SourceLine              : [650]

2016-09-04 08:48:14  ERROR   OGG-00664  OCI Error during OCIServerAttach (status

 = 12162-ORA-12162: TNS:net service name is incorrectly specified)

Pump Param file looks like as follows # 

ggsci> view param plct90

extract plct90

userid ggsuser, password oracle

PASSTHRU

RMTHOST tnc61.ffdc.com, MGRPORT 7809

RMTTRAIL /u01/app/trails/aa

REPORTCOUNT EVERY 10 MINUTES, RATE

TABLE world.orders;

Resolution: New changes in parameter file and start pump 

ggsci> view param plct90

extract plct90

userid ggsuser@tns_name, password oracle

PASSTHRU

RMTHOST tnc61.ffdc.com, MGRPORT 7809

RMTTRAIL /u01/app/trails/aa

REPORTCOUNT EVERY 10 MINUTES, RATE

ggsci> start plct90 

--pump came up automatically, Issue is resolved --

--Nikhil Tatineni--

--gg--

Links Related to GoldenGate #

REPLICAT WITH HANDLECOLLISIONS

http://www.databaseinmemory.com/2015/01/replicat-with-handlecollisions.html

SPLITING OracleGoldenGate REPLICAT

http://www.databaseinmemory.com/2015/02/hey-guys-welcome-back.html

Goldengate Replicat is running very slow

http://www.databaseinmemory.com/2015/10/replicat-is-running-very-slow.html

Goldengate Replicat's blocking itself

http://www.databaseinmemory.com/2015/10/replicats-blocking-itself.html

Oracle GoldenGate: SKIP LONG RUNNING TRANSACTIONS

http://www.databaseinmemory.com/2015/03/ogg-skip-long-running-transactions.html

Goldengate Extract is not moving?

http://www.databaseinmemory.com/2015/02/extract-is-not-moving.html

ERROR OGG-00446  Missing filename opening checkpoint file

http://www.databaseinmemory.com/2015/08/error-ogg-00446.html

>>