FAQ on Administering Orale goldengate director

                          FAQ on Administering Orale goldengate director

1.Each instance of an Oracle GoldenGate Manger process is identified within Oracle
GoldenGate Director by the fully qualified domain name of the host (or the IP address
of the host), the port number on which Manager is listening, and a user-defined data
source name.

2.Oracle GoldenGate Director Server is installed as an Oracle WebLogic
Server domain.

3.Oracle GoldenGate Director Server is composed of the following applications:

a)The Oracle GoldenGate Director Server application, a collection of services that
controls security, host information services, object modeling, diagramming,
consolidated event logging, and alert services.

b)The Monitor Agent, a client to the Oracle GoldenGate hosts that establishes a
dedicated session of GGSCI (GoldenGate Software Command Interface). The
connection is used to obtain process status and event information

4.Oracle GoldenGate Director Server uses a database as a central repository to store
information about users and groups, graphical diagrams created by users,
consolidated events, and other information

5.Oracle GoldenGate Director Client is a client application of Oracle GoldenGate
Director Server that provides a graphical user interface (GUI) for managing Oracle
GoldenGate instances

6.Oracle GoldenGate Director Web is a web application that is hosted within Oracle
GoldenGate Director Server. It allows remote, browser-based monitoring and control
of Oracle GoldenGate instances without the need to install software on the client
system

7.Oracle GoldenGate Director Administrator is a client of Oracle GoldenGate Director
Server and is used for configuring Oracle GoldenGate Director Server itself

8.Oracle GoldenGate Director only supports UTF-8 character encoding

9.The character set of the operating system where Oracle GoldenGate is running and the
character set of the database being monitored or controlled with Oracle GoldenGate
Director must be the same

10.Requirements for Oracle GoldenGate Director Server

Oracle GoldenGate Director Server runs on 64-bit platforms only.
a)The system must have 1 GB of RAM.
b)The system must have at least 100 MB of free disk space
c)The http port that is selected during the installation process must be dedicated to
Oracle GoldenGate Director Server. The default port is 7001. The default SSL port
is 7002.
d)All systems hosting Oracle GoldenGate instances must be registered with a
Domain Name Server (DNS).

11.The Java Runtime Environment (JRE) must be available on, and supported by, the
operating system where you are installing Oracle GoldenGate Director Server

12)Allow at least 200 MB of space in the database for Oracle GoldenGate Director
Server objects and data. The installer creates the following tables and
corresponding indexes.
– ACCOUNTB
– ACLB
– ACLENTRYB
– ACNTGROUPREL
– ACNTPROPB
– ACONPROCSB
– ACONWATCHB
– ALERTB
– AUTOINCB
– CONTCACHEB
– GDSCVERS
– GROUPB
– HOSTINFOB
– LOGENTRYB
– MANAGERREFB
– MONAGENTB
– NODESTATEB
– OBJECTSTATEB
– STAGEB
– STATSENTRYB
– SUFFIXB
– UISPROPB

13.Oracle GoldenGate Director Server runs on 64-bit platforms only.

14.The Oracle GoldenGate Director Client must be the same version as that of the
Oracle GoldenGate Director Server. The client is packaged with the server
software. The use of different client and server versions returns an error.

15.The client host must be on the same network as the Oracle GoldenGate Director
Server host.

16.Installing Oracle GoldenGate Director Server

a)Assigning Database Storage and Login Credentials
b)Downloading the Oracle GoldenGate Director Software
c)Installing the Oracle GoldenGate Director Server Software

17.Assigning Database Storage and Login Credentials
Before installing Oracle GoldenGate Director Server for the first time, you need to
assign a storage location for the repository and assign database login credentials for
Oracle GoldenGate Director to use. You can use existing objects or create new ones.


1. Create a user (schema) and password. The password must contain at least eight
alphanumeric characters, with at least one alphabet character and one number.
2. Specify QUOTA UNLIMITED on the user’s default tablespace

Installing Oracle GoldenGate Director Server from the Command Line
From the command line of the operating system, run the following command.
./gg-director-serversetup_unix_version.sh -c


18.Oracle GoldenGate Director
Server will use to communicate with Oracle GoldenGate Director Web. In most
cases, the default of 7001 should be sufficient.

19.Installing Oracle GoldenGate Director Server with the Wizard
This procedure installs Oracle GoldenGate Director by means of a graphical interface.

Run the ggdirector-serversetup program.

20.The installer creates a WebLogic Domain service. If the
WebLogic version is earlier than 12c, a prefix of beasvc is prepended
to the service name, or if the WebLogic version is at least 12c, a prefix
of wlsvc is prepended to the service name. The host name is appended
to the service name. For example, if the default service name of
oggdirector is used, the service name is beasvc oggdirector_
localhost or wlsvc oggdirector_localhost

21.Control Commands for Oracle GoldenGate Director Server

Start in
foreground

domain/startWebLogic.sh
(or...)
directorControl.sh start
Start in
background

directorControl.sh -b start

Stop

directorControl.sh stop

22.To configure Oracle GoldenGate Director Server, use the Oracle GoldenGate Director
Administrator program.

23.start Oracle GoldenGate Director Administrator on UNIX
Run the run-admin.sh script from the bin sub-directory of the
installation directory

24.All users of Oracle GoldenGate Director Client must have an account with Oracle
GoldenGate Director Server

25.To view an Oracle GoldenGate instance from Oracle GoldenGate Director Client, its
connection information must be stored in the Oracle GoldenGate Director Server
repository

26.Oracle GoldenGate Director Server creates threads that monitor the Manager
processes of the Oracle GoldenGate instances that are registered with Oracle
GoldenGate Director Server. Each thread is called a monitor

27.SSL (Secure Socket Layer) is an industry-standard method of establishing an
encrypted link between a browser and Oracle GoldenGate Director Server

28.For SSL Listen Port, specify a SSL port number for this domain, or use the default
of 7002.

29.Configuring Oracle GoldenGate Director Client for SSL

1. Copy the SSL keystore to any directory of the Oracle GoldenGate Director Client
machine. This file has a suffix of .jks.
2. In the Oracle GoldenGate Director Client installation directory, open the
etc/client-properties.conf file.
3. Update the following properties. Because this is a Java properties file, use only
forward slashes even if the platform is Windows.
¦ Specify the location of the keystore file. Replace the directory path in this
example with the path to your keystore.
weblogic.security.SSL.trustedCAKeyStore=C:/Oracle/Middleware1034/wlserver_
10.3/server/lib/certificate
¦ Set the following parameter to instruct Oracle WebLogic Server not to verify
the host name:
weblogic.security.SSL.ignoreHostnameVerification=true