{"id":2039,"date":"2011-03-09T16:28:48","date_gmt":"2011-03-09T21:28:48","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=2039"},"modified":"2011-03-15T12:54:10","modified_gmt":"2011-03-15T17:54:10","slug":"create-a-general-purpose-oracle-10g-database-on-solaris-10","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=2039","title":{"rendered":"Create a General Purpose Oracle 10g Database on Solaris 10"},"content":{"rendered":"

Set up env<\/h3><\/span>\n
\r\nexport ORACLE_HOME=\/opt\/oracle\/product\/10.2\r\nexport ORACLE_SID=soa11g\r\n<\/pre>\n
Start dbca<\/h3><\/span>\n
* You’ll need X Windows. I used Cygwin X. See this post<\/a> for details.<\/p>\n
\r\ncd $ORACLE_HOME\/bin\r\n.\/dbca\r\n<\/pre>\n
* Select Create a Database
\n* Select General Purpose
\n* Enter
\n– Global Database Name: soa11g.my.com
\n– SID: soa11g
\n* Select use the Same Password for All Accounts
\n– Password: welcome1
\n* Select Register this database with all the listeners
\n* Select File System on Select the storage mechanism
\n* Select use Common Location for All Database Files and enter
\n– Database Files Location: \/data1\/oradata
\n* Uncheck both Specify Flash Recovery Area and Enable Archiving
\n* Uncheck Sample Schemas
\n* Initialization Parameters
\n– On Memory tab,
\nSelect Typical
\nPercentage: 20
\n– On Sizing tab, Enter
\nProcesses: 150
\n– On Character Sets tab,
\nselect Use Unicode (“)
\n– On Connection Mode tab,
\nSelect Dedicated Server Mode
\n* Edit Database Storage
\n– Controlfile
\ncontrol01.ctl \/data1\/oradata\/{DB_NAME}\/
\ncontrol02.ctl \/data2\/oradata\/{DB_NAME}\/
\ncontrol03.ctl \/data3\/oradata\/{DB_NAME}\/
\n– Datafile
\nAccept defaults
\n– Redo Log Groups
\n– redo01.log \/data1\/oradata\/{DB_NAME}\/
\n– redo02.log \/data2\/oradata\/{DB_NAME}\/
\n– redo03.log \/data3\/oradata\/{DB_NAME}\/
\n* On Creation Options
\n– Check Create Database
\n– Check Generate Database Creation Scripts and enter
\nDestination Directory: \/opt\/oracle\/admin\/soa11g\/scripts
\n– Click Finish
\n* Click OK
\n* Click Exit when done<\/p>\n
Edit tnsnames.ora<\/h3><\/span>\n
\r\nsoa11g =\r\n  (DESCRIPTION =\r\n    (ADDRESS = (PROTOCOL = tcp)(HOST = mydbsvr)(PORT = 1521))\r\n    (CONNECT_DATA =\r\n      (sid = soa11g)\r\n    )\r\n  )\r\n\r\nsoa11g.my.com =\r\n  (DESCRIPTION =\r\n    (ADDRESS = (PROTOCOL = tcp)(HOST = mydbsvr)(PORT = 1521))\r\n    (CONNECT_DATA =\r\n      (service_name = soa11g.my.com)\r\n    )\r\n  )\r\n<\/pre>\n
References<\/h3><\/span>\n
* Installing and Configuring Oracle Database 10g on the Solaris Platform<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Set up env export ORACLE_HOME=\/opt\/oracle\/product\/10.2 export ORACLE_SID=soa11g Start dbca * You’ll need X Windows. I used Cygwin X. See this post for details. cd $ORACLE_HOME\/bin .\/dbca * Select Create a Database * Select General Purpose * Enter – Global Database … 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":[93],"tags":[],"class_list":["post-2039","post","type-post","status-publish","format-standard","hentry","category-10g"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-wT","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2039","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=2039"}],"version-history":[{"count":4,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2039\/revisions"}],"predecessor-version":[{"id":2068,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2039\/revisions\/2068"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}