OGG Director連線報錯Access denied

lhrbest發表於2020-10-28


在使用Goldengate Director GDS Admin Tool建立Data Source連線 Goldengate12c時遇到下面的報錯。

 

Checking connection to: 10.164.224.83:7809

Test is running directly from Director Server.

Opening GGSCI connection...

Connection FAILED, Manager doesn't seems to be running.

GGSCI Connection error: com.goldengate.gdsc.server.net.ggsci.ConnectException: Error retrieving dynamic port from 10.164.224.83 on 7809: ERROR Access denied

Sending AllStat command...

GGSCI Connection failed: nullClosing connection...

Closed. All done.



ggserr.log  日誌報錯：

INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GUI on host [XXXX]:26068 (START GGSCI ). 
WARNING OGG-00936 Oracle GoldenGate Manager for Oracle, mgr.prm: Access denied (request from XXXXX, rule #5).


Goldengate Director Will Not Connect To OGG (文件 ID 2100019.1)

In this Document

Symptoms
Cause
Solution


APPLIES TO:

Management Pack for Oracle GoldenGate - Version 11.2.1.0.0 and later
Information in this document applies to any platform.

SYMPTOMS

GoldenGate Director cannot connect to Oracle GoldenGate 11.2.1.0.32 or above.  

The GoldenGate "data source" shows DOWN in OGG Director UI and  ggserr.log shows:

2016-01-20 18:33:29 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GUI on host [<ip address>]:26068 (START GGSCI ).
2016-01-20 18:33:29 WARNING OGG-00936 Oracle GoldenGate Manager for Oracle, mgr.prm: Access denied (request from <ip address>, rule #5).

 

CAUSE

 In Oracle GoldenGate 11.2.1.0.32 and above the manager rejects OGG Director connection attempts using default settings. 

SOLUTION

 To allow a remote Director server connection, you must  ADD in the 
<OGG_HOME>/GLOBALS:

_DISABLEFIX21427144

AND 

ADD 

ACCESSRULE, PROG *, IPADDR *, PRI 1, ALLOW 

in $OGG_HOME/dirprm/mgr.prm

After the changes are configured then stop/start GoldenGate manager for changes to take effect.
Lastly, re-try GoldenGate Director UI operations and error should be resolved.

About Me

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

● 本文作者：小麥苗，部分內容整理自網路，若有侵權請聯絡小麥苗刪除

● 本文在個人微 信公眾號（ DB寶）上有同步更新

● QQ群號： 230161599 、618766405，微信群私聊

● 個人QQ號（646634621），微 訊號（db_bao），註明新增緣由

● 於 2020年10月 在西安完成

● 最新修改時間：2020年10月

● 版權所有，歡迎分享本文，轉載請保留出處

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

● 小麥苗的微店： https://weidian.com/s/793741433?wfr=c&ifr=shopdetail

● 小麥苗出版的資料庫類叢書： http://blog.itpub.net/26736162/viewspace-2142121/

● 小麥苗OCP、OCM、高可用、DBA學習班： http://blog.itpub.net/26736162/viewspace-2148098/

● 資料庫筆試面試題庫及解答： http://blog.itpub.net/26736162/viewspace-2134706/

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

請掃描下面的二維碼來關注小麥苗的微 信公眾號（ DB寶）及QQ群（230161599、618766405）、新增小麥苗微 信（db_bao）， 學習最實用的資料庫技術。

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

 

 



來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26736162/viewspace-2730434/，如需轉載，請註明出處，否則將追究法律責任。

相關文章