{"id":408,"date":"2009-02-12T13:47:19","date_gmt":"2009-02-12T18:47:19","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=408"},"modified":"2010-03-24T13:23:14","modified_gmt":"2010-03-24T18:23:14","slug":"install-oracle-10g","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=408","title":{"rendered":"Oracle 10g"},"content":{"rendered":"

Install on Windows<\/h2><\/span>\n

Install Oracle 10g on Windows is straight forward enough. One caveat is that if your computer is configured with DHCP IP addresses, you need to install a Microsoft loopback adapter. Follow the install doc to install a loopback adapter. Briefly as follows.<\/p>\n

Add a Microsoft loopback adapter<\/h3><\/span>\n

* Go to Control panel
\n* Double click “Add hardware”
\n* Select “Yes, I have already connected the hardware”
\n* Select “Add a new hardware device”
\n* Select “Install the hardware that I manually select from a list”
\n* Select “Network adapters”
\n* Select “Microsoft” and “Microsoft Loopback Adapter”
\n* Click “Finish” button to close the wizard.<\/p>\n

Set loopback adapter TCP\/IP<\/h3><\/span>\n

With ip: 10.10.10.10 (or 192.168.x.x) and subnet: 255.255.255.0.
\n* Go to Control panel
\n* Double click “Network Connections”
\n* Right click the newly added adapter and select the “Properties”
\n* Select “Internet Protocol (TCP\/IP)
\n* Click “Properties”
\n* Click “Use the following IP address”
\n* Set IP adress: 10.10.10.10 (or 192.168.x.x) and Subnet mask: 255.255.255.0
\n* Click “OK” button
\n* Click “Close” button.<\/p>\n

Add to “system32 -> drivers -> etc -> hosts” file<\/h3><\/span>\n
10.10.10.10   mycomputer.mydomain.com   mycomputer<\/pre>\n
Restart computer<\/h4><\/span>\n
Need to restart computer for the loopback adapter to take effect<\/p>\n
imp<\/h2><\/span>\n
Create needed tablespaces<\/h3><\/span>\n
\r\nCREATE TABLESPACE \"SOASMDB\" BLOCKSIZE 8192 \r\nDATAFILE  'C:\\ORACLE\\PRODUCT\\10.2.0\\ORADATA\\orcl\\SOASMDB.DBF' SIZE 104857600 REUSE \r\nAUTOEXTEND ON NEXT 52428800  MAXSIZE 32767M EXTENT MANAGEMENT LOCAL  \r\nAUTOALLOCATE  ONLINE PERMANENT  NOLOGGING SEGMENT SPACE MANAGEMENT AUTO;\r\n<\/pre>\n
Create users<\/h3><\/span>\n
\r\nCREATE USER \"SOASM\" IDENTIFIED BY VALUES 'secret' DEFAULT TABLESPACE \"SOASMDB\" TEMPORARY TABLESPACE \"TEMP\";\r\nCREATE USER \"SOAMP\" IDENTIFIED BY VALUES 'secret' DEFAULT TABLESPACE \"SOASMDB\" TEMPORARY TABLESPACE \"TEMP\";\r\n<\/pre>\n
Grant roles<\/h3><\/span>\n
\r\ngrant resource to soasm;\r\ngrant resource to soamp;<\/pre>\n
Run imp utility<\/h3><\/span>\n
\r\nimp parfile=imp.dat\r\n<\/pre>\n
imp.dat<\/h3><\/span>\n
\r\nUSERID=system\r\nFILE=EXP.DMP\r\nSHOW=n\r\nIGNORE=y\r\nGRANTS=y\r\nROWS=y\r\nFROMUSER=soasm,soamp\r\nLOG=c:\\IMP.log\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
Install on Windows Install Oracle 10g on Windows is straight forward enough. One caveat is that if your computer is configured with DHCP IP addresses, you need to install a Microsoft loopback adapter. Follow the install doc to install a … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","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":[35],"tags":[],"class_list":["post-408","post","type-post","status-publish","format-standard","hentry","category-oracle"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-6A","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/408","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=408"}],"version-history":[{"count":19,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/408\/revisions"}],"predecessor-version":[{"id":410,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/408\/revisions\/410"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}