{"id":76,"date":"2010-10-16T06:31:37","date_gmt":"2010-10-16T06:31:37","guid":{"rendered":"https:\/\/shan.info\/new\/oracle-install-sur-debian-%e8%bf%9c%e7%a8%8b-%e5%ae%89%e8%a3%85-oracle-xe-%e5%9c%a8-debian\/"},"modified":"2010-10-16T06:31:37","modified_gmt":"2010-10-16T06:31:37","slug":"oracle-install-sur-debian-%e8%bf%9c%e7%a8%8b-%e5%ae%89%e8%a3%85-oracle-xe-%e5%9c%a8-debian","status":"publish","type":"post","link":"https:\/\/shan.info\/new\/oracle-install-sur-debian-%e8%bf%9c%e7%a8%8b-%e5%ae%89%e8%a3%85-oracle-xe-%e5%9c%a8-debian\/","title":{"rendered":"Oracle install sur debian \u8fdc\u7a0b \u5b89\u88c5 oracle XE \u5728 debian"},"content":{"rendered":"<p>MIN 1g ram<\/p>\n<p>\u00a0<\/p>\n<p>\u8d44\u6599<\/p>\n<p><a href=\"http:\/\/www.debianhelp.co.uk\/oracle.htm\">http:\/\/www.debianhelp.co.uk\/oracle.htm<\/a><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>APT-GET \u5b89\u88c5\u8fc7\u7a0b<\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\">To use this reposotory you need to add following lines to \/etc\/apt\/sources.list file:<\/p>\n<p> <span style=\"color: #cc0066;\">deb http:\/\/oss.oracle.com\/debian\/ unstable main non-free<br \/> deb-src http:\/\/oss.oracle.com\/debian\/ unstable main<\/span><\/span><\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\"># apt-get update<\/span><\/span><\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\"># apt-get install oracle-xe-universal<\/span><\/span><\/p>\n<p>\u5b89\u88c5\u5b8c\u6210<\/p>\n<p>\u00a0<\/p>\n<p>\u8bbe\u7f6e<\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\"># \/etc\/init.d\/oracle-xe configure<\/span><\/span><\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\">Specify the HTTP port that will be used for Oracle Application Express [8080]:<\/span><\/span><\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\">\u8bbe\u7f6eweb\u754c\u9762\u7aef\u53e3<\/span><\/span><\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\"><br \/> Specify a port that will be used for the database listener [1521]:<\/span><\/span><\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\"><br \/>\u7a0b\u5e8f\u7aef\u53e3<\/span><\/span><\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\"><br \/> Specify a password to be used for database accounts. Note that the same<br \/> password will be used for SYS and SYSTEM. Oracle recommends the use of<br \/> different passwords for each database account. This can be done after<br \/> initial configuration:<\/p>\n<p> Confirm the password: (* make sure you remember this password *)<\/span><\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\">\u8bbe\u7f6e\u5bc6\u7801<\/span><\/span><\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\"><br \/> Do you want Oracle Database 10g Express Edition to be started on boot (y\/n) [y]: y<\/span><\/span><\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\"><br \/>\u6253Y\u662f\u786e\u5b9a<br \/> Starting Oracle Net Listener\u2026Done<br \/> Configuring Database\u2026Done<br \/> Starting Oracle Database 10g Express Edition Instance\u2026Done<br \/> Installation Completed Successfully.<br \/> To access the Database Home Page go to <span style=\"color: #cc0066;\"> \u201chttp:\/\/127.0.0.1:8080\/apex\u201d<\/span><\/span><\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\">\u8fdc\u7a0b\u5b89\u88c5web\u754c\u9762\u4e0d\u53ef\u7528 \u9700\u8981\u8bbe\u7f6e<br \/><\/span><\/span><\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\"><br \/> Now you have installed Oracle Express Edition on your Debian Sarge server.<\/span><\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\">\u5f00\u542f \u8fdc\u7a0b \u7aef\u53e3<\/span><\/span><\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\">Specify the HTTP port that will be used for Oracle Application Express [8080]:<\/p>\n<p> Specify a port that will be used for the database listener [1521]:<\/p>\n<p> Specify a password to be used for database accounts. Note that the same<br \/> password will be used for SYS and SYSTEM. Oracle recommends the use of<br \/> different passwords for each database account. This can be done after<br \/> initial configuration:<\/p>\n<p> Confirm the password: (* make sure you remember this password *)<\/p>\n<p> Do you want Oracle Database 10g Express Edition to be started on boot (y\/n) [y]: y<\/p>\n<p> Starting Oracle Net Listener\u2026Done<br \/> Configuring Database\u2026Done<br \/> Starting Oracle Database 10g Express Edition Instance\u2026Done<br \/> Installation Completed Successfully.<br \/> To access the Database Home Page go to <span style=\"color: #cc0066;\"> \u201chttp:\/\/127.0.0.1:8080\/apex\u201d<\/span><\/p>\n<p> Now you have installed Oracle Express Edition on your Debian Sarge server.<\/span><\/span><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\">\u89e3\u51b3 sqlplus: command not found<br \/><\/span><\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\">sudo vim \/etc\/profile<\/p>\n<p>\u6700\u4e0b\u9762\u589e\u52a0<br \/>export ORACLE_HOME=\/usr\/lib\/oracle\/xe\/app\/oracle\/product\/10.2.0\/server\u00a0 <br \/>export LD_LIBRARY_PATH=$ORACLE_HOME\/lib:$LD_LIBRARY_PATH\u00a0 <br \/>export ORACLE_SID=XE\u00a0 <br \/>export PATH=${PATH}:${ORACLE_HOME}\/bin <\/p>\n<p>\u91cd\u65b0\u52a0\u8f7d profile<br \/>source \/etc\/profile<\/span><\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\">sqlplus \u53ef\u7528<\/span><\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-size: xx-small;\"><span style=\"font-size: x-small;\">\u547d\u4ee4 web\u754c\u9762\u53ef\u4ee5\u8fdc\u7a0b\u8bbf\u95ee<\/span><\/span><\/p>\n<pre>$ sqlplus -S system\/password@\/\/localhost\/XE &lt;&lt;!\r\nEXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE); \r\nEXIT;\r\n\/\r\n!<br \/><br \/><br \/>\u73b0\u5728\u5c31\u53ef\u4ee5\u7528 <br \/><br \/> <a href=\"http:\/\/localhost:8081\/apex\/\">http:\/\/your-host-adress:8081\/apex\/<\/a><br \/><br \/>\u8bbf\u95ee\u4e86<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>MIN 1g ram \u00a0 \u8d44\u6599 http:\/\/www.debianhelp.co.uk\/oracle.htm \u00a0 \u00a0 \u00a0 APT-GET \u5b89\u88c5\u8fc7\u7a0b \u00a0 To use this reposotory you need to add following lines to \/etc\/apt\/sources.list file: deb http:\/\/oss.oracle.com\/debian\/ unstable main non-free deb-src http:\/\/oss.oracle.com\/debian\/ unstable main \u00a0 # apt-get update # apt-get install oracle-xe-universal \u5b89\u88c5\u5b8c\u6210 \u00a0 \u8bbe\u7f6e # \/etc\/init.d\/oracle-xe configure Specify the HTTP port that will be [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[],"class_list":["post-76","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts\/76","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/comments?post=76"}],"version-history":[{"count":0,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts\/76\/revisions"}],"wp:attachment":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/media?parent=76"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/categories?post=76"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/tags?post=76"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}