{"id":1500,"date":"2010-04-02T09:24:38","date_gmt":"2010-04-02T14:24:38","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=1500"},"modified":"2011-02-16T11:10:27","modified_gmt":"2011-02-16T16:10:27","slug":"install-oracle-golden-gate-104-on-windows","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=1500","title":{"rendered":"Install Oracle Golden Gate 10.4 on Windows"},"content":{"rendered":"<span id=\"Install_Visual_C__2005_SP1_Redistributable_Package\"><h3>Install Visual C ++ 2005 SP1 Redistributable Package<\/h3><\/span>\n<p>* Download from <a href=\"http:\/\/www.microsoft.com\/downloads\/details.aspx?familyid=200b2fd9-ae1a-4a14-984d-389c36f85647&#038;displaylang=en\">here<\/a>.<br \/>\n* Double click to install.<\/p>\n<span id=\"Set_Env_Var\"><h3>Set Env Var<\/h3><\/span>\n<p>* Set ORACLE_HOME and ORACLE_SID environment variables accordingly.<\/p>\n<span id=\"Install_Golden_Gate_Software\"><h3>Install Golden Gate Software<\/h3><\/span>\n<p>* Unzip Golden Gate download into a local folder (e.g. C:\\prog\\gg104). Make sure there is no space in folder names.<br \/>\n* Open a DOS shell and cd to GoldenGate folder.<br \/>\n* Issue command &#8216;GGSCI&#8217; to bring up the GoldenGate command interface.<br \/>\n* Issue command &#8216;CREATE SUBDIRS&#8217; to create needed subdiretories.<br \/>\n* Issue command &#8216;exit&#8217; to exit command interface.<\/p>\n<pre lang=\"dos\">\r\nMicrosoft Windows XP [Version 5.1.2600]\r\n(C) Copyright 1985-2001 Microsoft Corp.\r\n\r\nC:\\WINDOWS\\system32>cd C:\\prog\\gg104\r\n\r\nC:\\prog\\gg104>ggsci\r\n\r\nOracle GoldenGate Command Interpreter for Oracle\r\nVersion 10.4.0.19 Build 002\r\nWindows (optimized), Oracle 10 on Sep 18 2009 15:54:55\r\n\r\nCopyright (C) 1995, 2009, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nGGSCI (mycomputer) 1> CREATE SUBDIRS\r\n\r\nCreating subdirectories under current directory C:\\prog\\gg104\r\n\r\nParameter files                C:\\prog\\gg104\\dirprm: created\r\nReport files                   C:\\prog\\gg104\\dirrpt: created\r\nCheckpoint files               C:\\prog\\gg104\\dirchk: created\r\nProcess status files           C:\\prog\\gg104\\dirpcs: created\r\nSQL script files               C:\\prog\\gg104\\dirsql: created\r\nDatabase definitions files     C:\\prog\\gg104\\dirdef: created\r\nExtract data files             C:\\prog\\gg104\\dirdat: created\r\nTemporary files                C:\\prog\\gg104\\dirtmp: created\r\nVeridata files                 C:\\prog\\gg104\\dirver: created\r\nVeridata Lock files            C:\\prog\\gg104\\dirver\\lock: created\r\nVeridata Out-Of-Sync files     C:\\prog\\gg104\\dirver\\oos: created\r\nVeridata Out-Of-Sync XML files C:\\prog\\gg104\\dirver\\oosxml: created\r\nVeridata Parameter files       C:\\prog\\gg104\\dirver\\params: created\r\nVeridata Report files          C:\\prog\\gg104\\dirver\\report: created\r\nVeridata Status files          C:\\prog\\gg104\\dirver\\status: created\r\nVeridata Trace files           C:\\prog\\gg104\\dirver\\trace: created\r\nStdout files                   C:\\prog\\gg104\\dirout: created\r\n\r\nGGSCI (mycomputer) 2> exit\r\nC:\\prog\\gg104>\r\n<\/pre>\n<span id=\"Configure_Manager_Port\"><h3>Configure Manager Port<\/h3><\/span>\n<pre lang=\"bash\">\r\nGGSCI 3> EDIT PARAMS MGR\r\n# Manager listening on port 7809\r\nPORT 7809\r\n# Additional params\r\n# DYNAMICPORTLIST {<port> | <port>-<port>} [, ...]\r\n# DYNAMICPORTREASSIGNDELAY <seconds>\r\nAUTORESTART {ER | EXTRACT | REPLICAT} {group name | wildcard}\r\n[, RETRIES <max retries>]\r\n[, WAITMINUTES <wait minutes>]\r\n[, RESETMINUTES <reset minutes>]\r\n# PURGEOLDEXTRACTS\r\n<\/pre>\n<span id=\"Install_Manager_as_Window_Services\"><h3>Install Manager as Window Services<\/h3><\/span>\n<pre lang=\"batch\">\r\nC:\\prog\\gg104>install ADDSERVICE\r\nService 'GGSMGR' created.\r\nInstall program terminated normally.\r\n<\/pre>\n<span id=\"Delete_Manager_as_Window_Service\"><h3>Delete Manager as Window Service<\/h3><\/span>\n<pre lang=\"batch\">\r\nC:\\prog\\gg104>install deleteservice\r\nService 'GGSMGR' removed.\r\nInstall program terminated normally.\r\n<\/pre>\n<span id=\"Start_Manager\"><h3>Start Manager<\/h3><\/span>\n<p>* From ggsci:<\/p>\n<pre lang=\"bash\">START MANAGER<\/pre>\n<p>* From Windows Services<br \/>\nStart installed service<\/p>\n<span id=\"Stop_Manager\"><h3>Stop Manager<\/h3><\/span>\n<p>* From ggsci:<\/p>\n<pre lang=\"bash\">STOP MANAGER [!]<\/pre>\n<p>* From Windows Services<br \/>\nStop installed service<\/p>\n<span id=\"Prepare_Database\"><h2>Prepare Database<\/h2><\/span>\n<span id=\"Enable_Supplemental_Log\"><h3>Enable Supplemental Log<\/h3><\/span>\n<pre lang=\"sql\">\r\n-- Enable supplemental logging\r\nALTER DATABASE ADD SUPPLEMENTAL LOG DATA;\r\n\r\n-- Swith log to start supplemental logging\r\nALTER SYSTEM SWITCH LOGFILE;\r\n\r\n-- Verify supplemental logging is enabled (with a result of 'YES')\r\nSELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Install Visual C ++ 2005 SP1 Redistributable Package * Download from here. * Double click to install. Set Env Var * Set ORACLE_HOME and ORACLE_SID environment variables accordingly. Install Golden Gate Software * Unzip Golden Gate download into a local &hellip; <a href=\"https:\/\/jianmingli.com\/wp\/?p=1500\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[88],"tags":[],"class_list":["post-1500","post","type-post","status-publish","format-standard","hentry","category-goldengate"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-oc","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1500","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1500"}],"version-history":[{"count":8,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1500\/revisions"}],"predecessor-version":[{"id":1938,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1500\/revisions\/1938"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1500"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}