Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29 GoldenGate Tutorial 2 – Installation (Oracle 11g on Linux) | Oracle DBA – Tips and Techniques
Hi Gavin,
The goldengate tutorial is great.It helped me in configuring the goldengate but when i tried to start the extract process its showing log read checkpoint not available and when i checked the log its showing unrecognized parameter (mgr port).
1)I have a question like we need to configure any listener,client configuration.
2)how to configure the manager port.
3)When the data is moved from one db to another by which means its going to travel like using lsn,tns etc
Thanks Surya.
I will try to answer 2 and 3.
2) ggsci>edit params mgr
PORT
should be any one of the available port.
3) GoldenGate uses Trail file to transfer data from one database to another. The trail will be in UDF(Universal Data Format). The content of the trail can be viewed using a utility called LOGDUMP.
Thanks,
Ravi
Rather than doing this:
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
to get around the No supplemental logging message, the following may be better:
Login to SQL*Plus as a user with ALTER SYSTEM privileges
2. Enable minimal supplemental logging by executing the following command:
a. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
3. To ensure the redo and archive logs contain supplemental log data , switch the
logs by executing the command:
a. ALTER SYSTEM SWITCH LOGFILE;
4. Verify that supplemental logging is enabled at the database level via the command:
a. SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
b. The output of the query must be YES or IMPLICIT
Great tutorial but i ahve some problems with it.
OS = Oracle Enterprise Linux
Database = 11g R2
Not Sure About Golden Gate Version.(But think its the problem since source can login with no problems.)
In my target OS i get this error.(Its ok in my source OS)
GGSCI (target) 2> DBLOGIN USERID ggs_owner, PASSWORD ggs_owner
ERROR: Failed to open data source for user GGS_OWNER.
Waiting for an answer.
Thx.
The previous post says = Not Sure About Golden Gate Version.(But think its the problem since source can login with no problems.)
it should be = Not Sure About Golden Gate Version.(But think its NOT the problem since source can login with no problems.)
Sorry about it:)
Hi,
Its really nice post.I want to download Golden Gate 32bit for linux or Goldengate for AIX(POWER). I googled it and every where it is showing to download it from edelivery.oracle.com .But it is not allowing me to download . Though I have valid License for Oracle.
Can you help me on this please, where to download and how.
Regards
-Niraj
The command line:
GGSCI (target) 2> DBLOGIN USERID ggs_owner, PASSWORD ggs_owner
was giving
ERROR: Unable to connect to database using user ggs_owner. Please check privileg
es.
ORA-12560: TNS:protocol adapter error.
Qualifying the login line with the instance resolved the issue.
DBLOGIN USERID ggs_owner@your_oracle_instance, PASSWORD ggs_owner
Hi - what platform are you running this on? Before launching GoldenGate ensure that the environment has been set up for the Oracle database on that server and you are able to connect to the database by just providong the username and the password without the connect string
Gavin, appreciate your inputs and efforts on the Golden Gate tutorial. I just wanted to pass on some info on one of the most common errors with Golden Gate as posted earlier.
On Oracle 10g (10.2.0.4) and Golden Gate Version 11.1.1.1 on Linux
GGSCI (OracleVM2) 1> dblogin userid ggate password ggate
Successfully logged into database.
GGSCI (OracleVM2) 2> dblogin userid ggate, password ggate
Successfully logged into database.
GGSCI (OracleVM2) 3> dblogin userid ggate, password ggate;
ERROR: Failed to open data source for user GGATE.
GGSCI (OracleVM2) 4> dblogin userid ggate, password ggate
Successfully logged into database.
Oracle 11g (11.2.0.1) with Golden Gate Version 11.2.1.0.0 on Linux
GGSCI (OracleVM1) 10> dblogin userid ggate password ggate
ERROR: Unable to connect to database using user ggate. Please check privileges.
ORA-00942: table or view does not exist.
GGSCI (OracleVM1) 11> dblogin userid ggate, password ggate;
Successfully logged into database.
GGSCI (OracleVM1) 12> dblogin userid ggate, password ggate
ERROR: Unable to connect to database using user ggate. Please check privileges.
ORA-00942: table or view does not exist.
GGSCI (OracleVM1) 13> dblogin userid ggate password ggate;
Successfully logged into database.
Based on the above test,there seems to have been a slight change with the syntax ( semicolon is mandatory in the later version of Golden Gate) for execution.
Hope this helps.
Regards
Vinit
14 Comments