{"id":211,"date":"2009-01-14T23:03:31","date_gmt":"2009-01-15T03:03:31","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=211"},"modified":"2015-08-03T12:06:54","modified_gmt":"2015-08-03T17:06:54","slug":"install-oracle-10g-express","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=211","title":{"rendered":"Install Oracle 10g Express"},"content":{"rendered":"
\n

Contents<\/h2>\n
    \n\t
  1. \n\t\tOracle 10g Express Limitations<\/a>\n\t<\/li>\n\t
  2. \n\t\tInstall<\/a>\n\t<\/li>\n\t
  3. \n\t\tIncrease Number of Processes<\/a>\n\t<\/li>\n\t
  4. \n\t\tOracle 10g Express Client<\/a>\n\t<\/li>\n<\/ol>\n<\/ol>\n<\/div>\n
     <\/div>\n

    Oracle 10g Express Limitations<\/h2><\/span>\n

    *One instance per machine
    \n*1 CPU
    \n*1 GB RAM
    \n*4 GB total disk space<\/p>\n

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

    *Download from Oracle XE Site<\/a>
    \n*Make sure you are logged in Windows as local administrator. Domain administrator won’t work.
    \n*Double click OracleXE.exe to install
    \n*Accept all default options
    \n*SID is XE (not orcl)
    \n*Port info
    \n-Oracle Listener: 1521
    \n-Oracle services for MS transaction service: 2030
    \n-HTTP port: 8080<\/p>\n

    Increase Number of Processes<\/h2><\/span>\n

    *Login as system
    \n*Set process number<\/p>\n

    \r\nalter system set processes=150 scope=spfile;\r\n<\/pre>\n
    *Increase open_cursors<\/p>\n
    \r\nalter system set open_cursors=500 scope=both;\r\n<\/pre>\n
    *Remove the twenty session limit<\/p>\n
    \r\nalter system reset sessions scope=spfile sid='*';\r\n<\/pre>\n
    *Restart Oracle
    \n*Check changes<\/p>\n
    \r\nshow parameter sessions;\r\nshow parameter processes;\r\n<\/pre>\n
    * Combined commands:<\/p>\n
    \r\nalter system set processes=150 scope=spfile;\r\nalter system set open_cursors=500 scope=both;\r\nalter system reset sessions scope=spfile sid='*';\r\n\r\nshow parameter sessions;\r\nshow parameter processes;\r\n<\/pre>\n
    Oracle 10g Express Client<\/h2><\/span>\n
    *If you install 10g Express client, then you don’t see tnsname.ora file
    \n*To connect use username\/password@[\/\/]host:port[\/service_name]<\/p>\n
    sqlplus \/nolog\r\nconnect sys\/password@dbhost\/xe as sysdba<\/pre>\n
    *Optionally, copy the “NETWORK” directory from a server installation into the client installation <\/p>\n
    connect user\/password@xe<\/pre>\n","protected":false},"excerpt":{"rendered":"
    Oracle 10g Express Limitations *One instance per machine *1 CPU *1 GB RAM *4 GB total disk space Install *Download from Oracle XE Site *Make sure you are logged in Windows as local administrator. Domain administrator won’t work. *Double click … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"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":[93,35],"tags":[],"class_list":["post-211","post","type-post","status-publish","format-standard","hentry","category-10g","category-oracle"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-3p","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/211","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=211"}],"version-history":[{"count":14,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/211\/revisions"}],"predecessor-version":[{"id":10848,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/211\/revisions\/10848"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}