{"id":1545,"date":"2010-04-20T13:28:34","date_gmt":"2010-04-20T18:28:34","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=1545"},"modified":"2012-09-10T16:59:02","modified_gmt":"2012-09-10T21:59:02","slug":"install-goldengate-1040-on-unix","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=1545","title":{"rendered":"Install GoldenGate 10.4.0 on Unix"},"content":{"rendered":"
\n

Contents<\/h2>\n
    \n\t
  1. \n\t\tDownload GoldenGate<\/a>\n\t\t
      \n\t\t\t
    1. \n\t\t\t\tFrom Oracle GoldenGate Download<\/a>\n\t\t\t<\/li>\n\t\t\t
    2. \n\t\t\t\tFrom eDelivery<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
    3. \n\t\tSetup Environment Variables<\/a>\n\t\t
        \n\t\t\t
      1. \n\t\t\t\tSet ORACLE_HOME and ORACLE_SID<\/a>\n\t\t\t<\/li>\n\t\t\t
      2. \n\t\t\t\tSetup PATH and LD_LIBRARY_PATH<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
      3. \n\t\tInstall GoldenGate<\/a>\n\t\t
          \n\t\t\t
        1. \n\t\t\t\tUnpack Download<\/a>\n\t\t\t<\/li>\n\t\t\t
        2. \n\t\t\t\tExample<\/a>\n\t\t\t<\/li>\n\t\t\t
        3. \n\t\t\t\tCreate Subdirectories<\/a>\n\t\t\t<\/li>\n\t\t\t
        4. \n\t\t\t\tConfigure Manager Port<\/a>\n\t\t\t<\/li>\n\t\t\t
        5. \n\t\t\t\tStart Manager<\/a>\n\t\t\t<\/li>\n\t\t\t
        6. \n\t\t\t\tStop Manager<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
        7. \n\t\tPrepare Database<\/a>\n\t\t
            \n\t\t\t
          1. \n\t\t\t\tEnable Supplemental Log<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
          2. \n\t\tIssues<\/a>\n\t\t
              \n\t\t\t
            1. \n\t\t\t\tError Loading Shared Libraries<\/a>\n\t\t\t<\/li>\n\t\t\t
            2. \n\t\t\t\tcannot restore segment prot after reloc<\/a>\n\t\t\t<\/li>\n<\/ol>\n<\/ol>\n<\/ol>\n<\/div>\n
               <\/div>\n

              Download GoldenGate<\/h2><\/span>\n

              From Oracle GoldenGate Download<\/h3><\/span>\n

              * Go to Oracle GoldenGate Download<\/a> site.<\/p>\n

              From eDelivery<\/h3><\/span>\n

              Download GoldenGate from Oracle edelivery site under Oracle Fusion Middleware product pack. For example, to download GoldenGate 10.4.0\/Solaris 10 Sparc\/Oracle 10g:
              \n* Select Product pack: Oracle Fusion Middleware.
              \n* Select Platform: Oracle Solaris on SPARC (64bit).
              \n* Click “Go” button.
              \n* Select “Oracle GoldenGate on Oracle Media Pack for Sun Solaris”.
              \n* Click “Download” button next to “Oracle GoldenGate V10.4.0.x for Oracle 10g 64bit on Solaris 10”.
              \n* V18148-01.zip will be downloaded.<\/p>\n

              Setup Environment Variables<\/h2><\/span>\n

              Set ORACLE_HOME and ORACLE_SID<\/h3><\/span>\n

              * If only one instance of Oracle is running, set ORACLE_HOME and ORACLE_SID to that instance.
              \n* If multiple instances of Oracle is running, then set ORACLE_HOME and ORACLE_SID to desired instance in process parameter files.<\/p>\n

              \r\nSETENV (ORACLE_HOME = \"orahome\")\r\nSETENV (ORACLE_SID = \"mysid\")\r\n<\/pre>\n
              Setup PATH and LD_LIBRARY_PATH<\/h3><\/span>\n
              \r\nGG_HOME=\/goldengate; export GG_HOME\r\nPATH=$GG_HOME:$PATH; export PATH\r\nLD_LIBRARY_PATH=$GG_HOME:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH\r\n<\/pre>\n
              Install GoldenGate<\/h2><\/span>\n
              Unpack Download<\/h3><\/span>\n
              * Copy GoldenGate download to target machine.
              \n* Unzip download.
              \n* Create a new directory to host GoldenGate.
              \n* cd to the new directory and untar the unzip tar ball.<\/p>\n
              Example<\/h3><\/span>\n
              \r\n# Downloaded file\r\nls\r\nV18148-01.zip\r\n\r\n# Unzip\r\n$JAVA_HOME\/bin\/jar xvf V18148-01.zip\r\n# We get\r\nls\r\nV18148-01.zip\r\nggs_solaris10_sparc_ora10g_64bit_v10.4.0.19_002.tar\r\n\r\n# Make a new directory\r\nmkdir goldengate104\r\n\r\n# Untar\r\ncd goldengate104\r\ntar xvf ggs_solaris10_sparc_ora10g_64bit_v10.4.0.19_002.tar\r\n<\/pre>\n
              Create Subdirectories<\/h3><\/span>\n
              \r\ncd $GG_HOME\r\n$ ggsci\r\nOracle GoldenGate Command Interpreter for Oracle\r\nVersion 10.4.0.19 Build 002\r\nSolaris, sparc, 64bit (optimized), Oracle 10 on Sep 23 2009 15:19:42\r\n\r\nCopyright (C) 1995, 2009, Oracle and\/or its affiliates.  All rights reserved.\r\nGGSCI 1> CREATE SUBDIRS\r\n\r\nCreating subdirectories under current directory \/goldengate\r\n\r\nParameter files                \/goldengate\/dirprm: created\r\nReport files                   \/goldengate\/dirrpt: created\r\nCheckpoint files               \/goldengate\/dirchk: created\r\nProcess status files           \/goldengate\/dirpcs: created\r\nSQL script files               \/goldengate\/dirsql: created\r\nDatabase definitions files     \/goldengate\/dirdef: created\r\nExtract data files             \/goldengate\/dirdat: created\r\nTemporary files                \/goldengate\/dirtmp: created\r\nVeridata files                 \/goldengate\/dirver: created\r\nVeridata Lock files            \/goldengate\/dirver\/lock: created\r\nVeridata Out-Of-Sync files     \/goldengate\/dirver\/oos: created\r\nVeridata Out-Of-Sync XML files \/goldengate\/dirver\/oosxml: created\r\nVeridata Parameter files       \/goldengate\/dirver\/params: created\r\nVeridata Report files          \/goldengate\/dirver\/report: created\r\nVeridata Status files          \/goldengate\/dirver\/status: created\r\nVeridata Trace files           \/goldengate\/dirver\/trace: created\r\nStdout files                   \/goldengate\/dirout: created\r\n<\/pre>\n
              Configure Manager Port<\/h3><\/span>\n
              \r\nGGSCI 3> EDIT PARAMS MGR\r\n# Manager listening on port 7809\r\nPORT 7809\r\n# Additional params\r\n# DYNAMICPORTLIST { | -} [, ...]\r\n# DYNAMICPORTREASSIGNDELAY \r\nAUTORESTART {ER | EXTRACT | REPLICAT} {group name | wildcard}\r\n[, RETRIES ]\r\n[, WAITMINUTES ]\r\n[, RESETMINUTES ]\r\n# PURGEOLDEXTRACTS\r\n<\/pre>\n
              Start Manager<\/h3><\/span>\n
              * From shell command line:<\/p>\n
              mgr paramfile  [reportfile ]<\/pre>\n
              * From ggsci:<\/p>\n
              START MANAGER<\/pre>\n
              Stop Manager<\/h3><\/span>\n
              STOP MANAGER [!]<\/pre>\n
              Prepare Database<\/h2><\/span>\n
              Enable Supplemental Log<\/h3><\/span>\n
              * Login as sysdba and run following SQL statements:<\/p>\n
              \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
              Issues<\/h2><\/span>\n
              Error Loading Shared Libraries<\/h3><\/span>\n
              * Error message:<\/p>\n
              \r\n.\/ggsci: error while loading shared libraries: libnnz10.so: cannot open shared object file: No such file or directory\r\n<\/pre>\n
              * Solution: add $ORACLE_HOME\/lib to LD_LIBRARY_PATH<\/p>\n
              \r\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:$LD_LIBRARY_PATH\r\n<\/pre>\n
              cannot restore segment prot after reloc<\/h3><\/span>\n
              * Environment: SELinux
              \n* Error message:<\/p>\n
              \r\nerror while loading shared libraries: cannot restore segment prot after reloc: Permission denied\r\n<\/pre>\n
              * Solutions: login as root and turn off SELinux<\/p>\n
              \r\nsetenforce 0\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
              Download GoldenGate From Oracle GoldenGate Download * Go to Oracle GoldenGate Download site. From eDelivery Download GoldenGate from Oracle edelivery site under Oracle Fusion Middleware product pack. For example, to download GoldenGate 10.4.0\/Solaris 10 Sparc\/Oracle 10g: * Select Product pack: … Continue reading →<\/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":[587,141,565],"class_list":["post-1545","post","type-post","status-publish","format-standard","hentry","category-goldengate","tag-goldengate","tag-install","tag-unix"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-oV","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1545","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=1545"}],"version-history":[{"count":10,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1545\/revisions"}],"predecessor-version":[{"id":5906,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1545\/revisions\/5906"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}