Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Golden Gate Configuration

mmaller0319Jan 11 2014 — edited Feb 9 2014

I have a question on the default ports of Golden Gate.

I am trying to setup a one way replication between Database A on Mac A and Database B on Mac B

But my Database A on Mac A as well as Database B on Mac Bare in different DMZ for which needs ports to be opened.

My question is what ports do i tell my Firewall team to open to establish one way communication between source and target,assuming i will use default ports.

Comments

Billy Verreynne

Rules on an executable can be created. Select the java.exe executable and define the required access rules for it.
See https://docs.microsoft.com/en-us/windows/security/threat-protection/windows-firewall/best-practices-configuring for the basics - i.e. select PROGRAM for the rules:
image.png

Murray Sobol

Thanks Billy; I was pre-mature with my post. I found a similar link and added the missing Java entry.
This is the REAl issue I am trying to resolve:
I recently installed Oracle 18c Express Edition on my Windows 10x laptop.
When I tried to run DBCA I got this message:
image.png

When I researched this error one suggestion was to use a TRY/Catch block to trap this error; I shouldn't be trying to change DBCA.
My background is with Oracle 11g on Windows servers; I am researching a project to migrate databases to Oracle 19.
I would have preferred to install an Oracle 19 Express edition but apparently that does not exist.
My account with oracle is a "free" one so I don't have access to knowledge base articles.
I am curious - did something change between Oracle 11 and Oracle 18/19 with respect to language support.
Amy assistance would be appreciated.

I had issues with ORACLE_HOME not being set properly but I resolved that.
Now My Listener and other Oracle services start properly.
Remaining problem is with DBCA.

Billy Verreynne

Sorry, last used Oracle on Windows NT back with Oracle 7 - and Linux troubleshooting does not work on Windows. Knee jerk reaction is that your Windows o/s is not fully certified for Oracle, or there is some kind of config stuffup in the Registry.
As for version changes, there are release notes for each new Oracle version that list changes and new features and options.

cormaco
Answer

Does it have to be Windows installation?
If not you can use this VirtualBox appliance to get a running Oracle 19.3 EE database on Oracle Linux:
Developer Day - Hands-on Database Application Development (0 Bytes)

Marked as Answer by Murray Sobol · Apr 28 2021
Murray Sobol

Billy: I checked the supported OS's for Oracle 18c XE; my platform IS supported.
Cormaco: Yes, it needs to be a Windows installation.
Also, my potential client does not work with LINUX and is unwilling to spend the extra money for Oracle 19.x EE
Murray

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 9 2014
Added on Jan 11 2014
3 comments
1,703 views