{"id":2079,"date":"2011-05-12T23:18:29","date_gmt":"2011-05-13T04:18:29","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=2079"},"modified":"2015-04-17T13:54:57","modified_gmt":"2015-04-17T18:54:57","slug":"soa-11g-tutorial-prepare-and-setup","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=2079","title":{"rendered":"SOA 11g Tutorial: Prepare and Setup"},"content":{"rendered":"
\n

Contents<\/h2>\n
    \n\t
  1. \n\t\tDownloads and Installs<\/a>\n\t\t
      \n\t\t\t
    1. \n\t\t\t\tSample Projects<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
    2. \n\t\tPrepare for Tutorial<\/a>\n\t\t
        \n\t\t\t
      1. \n\t\t\t\tInstalling the database schema<\/a>\n\t\t\t<\/li>\n\t\t\t
      2. \n\t\t\t\tCreate JMS Resources in SOAJMSModule<\/a>\n\t\t\t\t
          \n\t\t\t\t\t
        1. \n\t\t\t\t\t\tJMS Queue: demoFulfillmentQueue<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t\t
        2. \n\t\t\t\t\t\tJMS Connection Factory: demoCF<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t<\/ol>\n\t\t\t
        3. \n\t\t\t\tConfigure JMSAdapter<\/a>\n\t\t\t\t
            \n\t\t\t\t\t
          1. \n\t\t\t\t\t\tCreate JMSAdapter Deployment Plan Folder<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t\t
          2. \n\t\t\t\t\t\tCreate a new JmsAdapter Outbound Connection Pool: eis\/Queue\/demo<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t\t
          3. \n\t\t\t\t\t\tConfigure Connection Factory for the New Connection Pool<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t\t
          4. \n\t\t\t\t\t\tRe-Deploy JMSAdapter<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t<\/ol>\n\t\t\t
          5. \n\t\t\t\tCreate Database Resource in DBAdapter: eis\/DB\/soademoDatabase<\/a>\n\t\t\t\t
              \n\t\t\t\t\t
            1. \n\t\t\t\t\t\tCreate Data Source<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t\t
            2. \n\t\t\t\t\t\tCreate Connection Pool<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t\t
            3. \n\t\t\t\t\t\tConfigure Data Source for the New Connection Pool<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t\t
            4. \n\t\t\t\t\t\tRe-Deploy DBAdapter<\/a>\n\t\t\t\t\t<\/li>\n<\/ol>\n<\/ol>\n<\/ol>\n<\/ol>\n<\/div>\n
               <\/div>\n

              This is part of the Oracle SOA11g hands on tutorials<\/a>.<\/p>\n

              Downloads and Installs<\/h2><\/span>\n

              * Book Download Page<\/a><\/p>\n

              Sample Projects<\/h3><\/span>\n

              * Download sample zip file SOA11g_GettingStarted.zip<\/a>, unzip, and copy po folder to c:\\<\/p>\n

              Prepare for Tutorial<\/h2><\/span>\n

              Installing the database schema<\/h3><\/span>\n
              C:\\po\\sql\r\n-- Create soademo user\r\nsqlpus system\r\nSQL> @create_soademo_user.sql\r\n\r\n-- Create creditrating table\r\nsqlplus soademo\/soademo\r\nSQL> @create_creditrating_table.sql<\/pre>\n
              Create JMS Resources in SOAJMSModule<\/h3><\/span>\n
              * Login WebLogic console, e.g. http:\/\/localhost:7001\/console<\/a>
              \n* Go to Services -> messaging -> JMS Modules<\/em>
              \n* Click SOAJMSModule<\/em><\/p>\n
              JMS Queue: demoFulfillmentQueue<\/h4><\/span>\n
              * Click New<\/em>
              \n* Select Queue<\/em>, click Next<\/em>
              \n– Enter JMS Destination Properties and click Next<\/em>.<\/p>\n
              Name:demoFulfillmentQueue\r\nJNDI name: jms\/demoFulfillmentQueue<\/pre>\n
              – Select<\/p>\n
              Subdeployments: SOASubDeployment\r\nJMS Servers: SOAJMSServer\r\n<\/pre>\n
              and click Finish<\/em>.<\/p>\n
              JMS Connection Factory: demoCF<\/h4><\/span>\n
              * In SOAJMSModule <\/em>Summary of Resources screen
              \n* Click New<\/em>
              \n* Select Connection Factory<\/em> and click Next<\/em>
              \n– Enter<\/p>\n
              \r\nName: demoCF\r\nJNDI Name: jms\/demoCF\r\n<\/pre>\n
              * Click Next <\/em>
              \n* Click Finish<\/em><\/p>\n
              Configure JMSAdapter<\/h3><\/span>\n
              Create JMSAdapter Deployment Plan Folder<\/h4><\/span>\n
              * Create a new JMSAdapter deployment plan directory on SOA domain host machine<\/p>\n
              \r\nmkdir \/opt\/oracle\/Middleware\/home_11gr1\/Oracle_SOA1\/soa\/JMSPlan\r\n<\/pre>\n
              Create a new JmsAdapter Outbound Connection Pool: eis\/Queue\/demo<\/h4><\/span>\n
              * Click navigation tree: Deployments<\/em>
              \n* Click JmsAdapter<\/em>
              \n* Click on tabs: Configuration -> Outbound Connection Pools<\/em>
              \n* Click New<\/em>
              \n* Select: oracle.tip.adapter.jms.IJmsConnectionFactory<\/em>
              \n* Enter
              \nJNDI Name: eis\/Queue\/demo<\/strong>
              \n* Click Finish<\/em>
              \n* Enter deployment plan path
              \nPath: \/opt\/oracle\/Middleware\/home_11gr1\/Oracle_SOA1\/soa\/JMSPlan\/Plan.xml<\/strong>
              \n* Click OK<\/em><\/p>\n
              Configure Connection Factory for the New Connection Pool<\/h4><\/span>\n
              * Click on Configuration <\/em>tab
              \n* Expand: oracle.tip.adapter.jms.IJmsConnectionFactory<\/em>
              \n* Click: eis\/Queue\/demo<\/em>
              \n* Enter:
              \nConnectionFactoryLocation: jms\/demoCF<\/strong>
              \n* Hit Enter <\/em>key
              \n* Click Save<\/em><\/p>\n
              Re-Deploy JMSAdapter<\/h4><\/span>\n
              * Click on “Deployments<\/em>” from left hand side Domain Structure panel
              \n* Select checkbox for JmsAdapter<\/em>
              \n* Click Update<\/em>
              \n* Verify deployment plan file location
              \n* Click Next<\/em>, Finish<\/em><\/p>\n
              Create Database Resource in DBAdapter: eis\/DB\/soademoDatabase<\/h3><\/span>\n
              Create Data Source<\/h4><\/span>\n
              * Go to Services -> Data Sources<\/em>
              \n* Click New -> Generic Datasource<\/em>
              \n* Enter<\/p>\n
              Name: soademoDatabase\r\nJNDI Name: jdbc\/soademoDatabase\r\nDatabase Type: Oracle<\/pre>\n
              and click Next<\/em>.
              \n* Select
              \nDatabase Driver: Oracle’s Driver (Thin XA<\/strong>) for Service <\/strong>connections; Verions:9.0.1 and later<\/em>
              \nand click Next<\/em>.
              \n* Click Next <\/em>on Transaction Options screen.
              \n* Enter Database connection properties:<\/p>\n
              Database Name: orcl.world<\/strong>\r\nHost Name: localhost\r\nPort: 1521\r\nDatabase User Name: soademo\r\nPassword: soademo\r\n<\/pre>\n
              and click Next<\/em>.
              \n* Click Test Configuration<\/em>. A green font message ‘Connection test succeeded’<\/em> should show up on the top of the screen.
              \n* Click Next<\/em>.
              \n* On Select Targets<\/em> screen, check soa_server1<\/em> and click Finish<\/em>.<\/p>\n
              Create Connection Pool<\/h4><\/span>\n
              * Create plan directory on host machine<\/p>\n
              \r\nmkdir \/opt\/oracle\/Middleware\/home_11gr1\/Oracle_SOA1\/soa\/DBPlan\r\n<\/pre>\n
              * Click Deployments <\/em>on tree menu
              \n* Click DBAdapter<\/em>
              \n* Click Configuration -> Outbound Connection Pools<\/em>
              \n* Click New<\/em>
              \n* Select javax.resource.cci.ConnectionFactory<\/em> and click Next<\/em>
              \n* Enter
              \nJNDI Name: eis\/DB\/soademoDatabase<\/strong>
              \nand click Finish<\/em>.
              \n* Enter
              \nPath: \/opt\/oracle\/Middleware\/home_11gr1\/Oracle_SOA1\/soa\/DBPlan\/Plan.xml<\/strong>
              \n* Click OK<\/em><\/p>\n
              Configure Data Source for the New Connection Pool<\/h4><\/span>\n
              * Click on Configuration tab -> Outbound Connection Pools<\/em>
              \n* Expand javax.resource.cci.ConnectionFactory<\/em>
              \n* Click eis\/DB\/soademoDatabase<\/em> name
              \n* Click Properties <\/em>tab and enter
              \nxADataSourceName: jdbc\/soademoDatabase<\/strong>
              \n* Hit Enter <\/em>key
              \n* Click Save <\/em>button.<\/p>\n
              Re-Deploy DBAdapter<\/h4><\/span>\n
              * Click Deployments <\/em>on left panel
              \n* Select checkbox for DbAdapter<\/em>
              \n* Click Update<\/em>
              \n* Select
              \nRedeploy this application using the following deployment files<\/em>
              \n* Verify
              \nDeployment plan path: \/opt\/oracle\/Middleware\/home_11gr1\/Oracle_SOA1\/soa\/DBPlan\/Plan.xml<\/em>
              \n* Click Finish<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"
              This is part of the Oracle SOA11g hands on tutorials. Downloads and Installs * Book Download Page Sample Projects * Download sample zip file SOA11g_GettingStarted.zip, unzip, and copy po folder to c:\\ Prepare for Tutorial Installing the database schema C:\\po\\sql … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","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":[100],"tags":[588,562,138],"class_list":["post-2079","post","type-post","status-publish","format-standard","hentry","category-soa11g","tag-11g","tag-soa","tag-tutorial-setup"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-xx","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2079","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=2079"}],"version-history":[{"count":32,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2079\/revisions"}],"predecessor-version":[{"id":10655,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2079\/revisions\/10655"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2079"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2079"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}