{"id":169,"date":"2013-04-29T08:01:18","date_gmt":"2013-04-29T08:01:18","guid":{"rendered":"http:\/\/www.einaweb.es\/develop\/?p=169"},"modified":"2013-04-29T08:01:54","modified_gmt":"2013-04-29T08:01:54","slug":"oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server","status":"publish","type":"post","link":"http:\/\/www.einaweb.es\/develop\/oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server\/","title":{"rendered":"Oracle XE oracle-xe-11.2.0-1.0.x86_64 in Ubuntu Server"},"content":{"rendered":"

Pasos a seguir par conseguir instalar el Oracle XE en un ubuntu Server a traves de la consola.<\/p>\n

–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Bajamos los siguientes paquetes que se utilizaran.<\/strong><\/p>\n

~$ sudo apt-get install openssh-server
\n~$ sudo apt-get install alien libaio1 unixodbc unzip<\/p><\/blockquote>\n

–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Aumentamos el tama\u00f1o de swap.<\/strong><\/p>\n

~$ cat \/proc\/meminfo | grep -i swap
\n~$ sudo su –
\n~$ dd if=\/dev\/zero of=\/home\/swapfile bs=1024 count=1048576
\n~$ mkswap \/home\/swapfile
\n~$ swapon \/home\/swapfile
\n~$ swapon -a
\n~$ cp \/etc\/fstab \/etc\/fstab.backup_`date +%N`
\n~$ echo ‘\/home\/swapfile swap swap defaults 0 0’ >> \/etc\/fstab
\n~$ exit
\n~$ swapon -s<\/p><\/blockquote>\n

–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Modificamos los par\u00e1metros del kernel<\/strong><\/p>\n

~$ sudo su –
\n~$ cat > \/etc\/sysctl.d\/60-oracle.conf <<-EOF
\n# Oracle 11g XE kernel parameters
\nfs.file-max=6815744
\nnet.ipv4.ip_local_port_range=9000 65500
\nkernel.sem=250 32000 100 128
\n# kernel.shmmax=429496729
\nkernel.shmmax=107374183
\nEOF
\n~$ service procps start
\n~$ sudo sysctl -q fs.file-max
\n~$ sudo sysctl -q kernel.shmmax
\n~$ sudo sysctl -q net.ipv4.ip_local_port_range
\n~$ sudo sysctl -q kernel.sem<\/p><\/blockquote>\n

–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ORA-00845: MEMORY_TARGET<\/strong><\/p>\n

~$ sudo su –
\n~$ cat > \/etc\/init.d\/oracle-shm <<-EOF
\n#! \/bin\/sh
\n# \/etc\/init.d\/oracle-shm
\n#
\n#
\ncase \u00ab\\$1\u00bb in
\nstart)
\necho \u00abStarting script \/etc\/init.d\/oracle-shm\u00bb
\n# Run only once at system startup
\nif [ -e \/dev\/shm\/.oracle-shm ]; then
\necho \u00ab\/dev\/shm is already mounted, nothing to do\u00bb
\nelse
\nrm -f \/dev\/shm
\nmkdir \/dev\/shm
\nmount -t tmpfs shmfs -o size=2048m \/dev\/shm
\ntouch \/dev\/shm\/.oracle-shm
\nfi
\n;;
\nstop)
\necho \u00abStopping script \/etc\/init.d\/oracle-shm\u00bb
\necho \u00abNothing to do\u00bb
\n;;
\n*)
\necho \u00abUsage: \/etc\/init.d\/oracle-shm {start|stop}\u00bb
\nexit 1
\n;;
\nesac
\n#
\n### BEGIN INIT INFO
\n# Provides:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 oracle-shm
\n# Required-Start:\u00a0\u00a0\u00a0 $remote_fs $syslog
\n# Required-Stop:\u00a0\u00a0\u00a0\u00a0 $remote_fs $syslog
\n# Default-Start:\u00a0\u00a0\u00a0\u00a0 2 3 4 5
\n# Default-Stop:\u00a0\u00a0\u00a0\u00a0\u00a0 0 1 6
\n# Short-Description: Bind \/run\/shm to \/dev\/shm at system startup.
\n# Description:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Fix to allow Oracle 11g use AMM.
\n### END INIT INFO
\nEOF
\n~$ chmod 755 \/etc\/init.d\/oracle-shm
\n~$ update-rc.d oracle-shm defaults 01 99
\n~$ reboot
\n~$ sudo cat \/etc\/mtab | grep shm
\n~$ sudo df -h \/run\/shm<\/p><\/blockquote>\n

–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Instalamos el Oracle 11gR2 Express Edition<\/strong><\/p>\n

~$ unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
\n~$ cd Disk1
\n~$ sudo alien –to-deb –scripts oracle-xe-11.2.0-1.0.x86_64.rpm
\n~$ sudo ln -s \/usr\/bin\/awk \/bin\/awk
\n~$ sudo mkdir \/var\/lock\/subsys
\n~$ sudo su –
\n~$ cat > \/sbin\/chkconfig <<-EOF
\n#!\/bin\/bash
\n# Oracle 11gR2 XE installer chkconfig hack for Debian based Linux (by dude)
\n# Only run once.
\necho \u00abSimulating \/sbin\/chkconfig…\u00bb
\nif [[ ! \\`tail -n1 \/etc\/init.d\/oracle-xe | grep INIT\\` ]]; then
\ncat >> \/etc\/init.d\/oracle-xe <<-EOM
\n#
\n### BEGIN INIT INFO
\n# Provides:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OracleXE
\n# Required-Start:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \\\\\\$remote_fs \\\\\\$syslog
\n# Required-Stop:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \\\\\\$remote_fs \\\\\\$syslog
\n# Default-Start:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 3 4 5
\n# Default-Stop:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 1 6
\n# Short-Description:\u00a0\u00a0 Oracle 11g Express Edition
\n### END INIT INFO
\nEOM
\nfi
\nupdate-rc.d oracle-xe defaults 80 01
\nEOF
\n~$ exit
\n~$ sudo chmod 755 \/sbin\/chkconfig
\n~$ sudo dpkg –install .\/oracle-xe_11.2.0-2_amd64.deb
\n~$ sudo \/etc\/init.d\/oracle-xe configure
\n~$ sudo passwd oracle<\/p><\/blockquote>\n

–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Despu\u00e9s de la instalaci\u00f3n<\/strong><\/p>\n

~$ su – oracle
\n~$ cp \/etc\/skel\/.bash_logout .\/
\n~$ cp \/etc\/skel\/.bashrc .\/
\n~$ cp \/etc\/skel\/.profile .\/
\n~$ echo \u00ab\u00bb >>.\/.profile
\n~$ echo ‘. \/u01\/app\/oracle\/product\/11.2.0\/xe\/bin\/oracle_env.sh’ >>.\/.profile
\n~$ su – oracle
\n~$ sqlplus \/ as sysdba
\nSQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
\nexit<\/p><\/blockquote>\n

Fuente recogida de esta direccion: https:\/\/forums.oracle.com\/forums\/thread.jspa?threadID=2301639&start=0&tstart=0<\/a><\/p>\n

En ubuntu tuve problemas siguiendo el tutorial del link anterior por esta razon que esta modificado en la explicaci\u00f3n que se detalla anteriormente:<\/p>\n

Debes cambiar del fichero \/etc\/init.d\/oracle-shm la linea esta \u00abmount -B \/run\/shm \/dev\/shm\u00bb por esta \u00abmount -t tmpfs shmfs -o size=2048m \/dev\/shm\u00bb, sino no podras configurar la base de datos y no la instanciara.<\/em><\/p><\/blockquote>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Pasos a seguir par conseguir instalar el Oracle XE en un ubuntu Server a traves de la consola. –\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Bajamos los siguientes paquetes que se utilizaran. ~$ sudo apt-get install openssh-server ~$ sudo apt-get install alien libaio1 unixodbc unzip –\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Aumentamos el tama\u00f1o de swap. ~$ cat \/proc\/meminfo | grep -i swap ~$ sudo su […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-169","post","type-post","status-publish","format-standard","hentry","category-oracle"],"yoast_head":"\nOracle XE oracle-xe-11.2.0-1.0.x86_64 in Ubuntu Server - Blog Desarrollador<\/title>\n<meta name=\"description\" content=\"Oracle XE oracle-xe-11.2.0-1.0.x86_64 in Ubuntu Server - Blog Desarrollador\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.einaweb.es\/develop\/oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle XE oracle-xe-11.2.0-1.0.x86_64 in Ubuntu Server - Blog Desarrollador\" \/>\n<meta property=\"og:description\" content=\"Oracle XE oracle-xe-11.2.0-1.0.x86_64 in Ubuntu Server - Blog Desarrollador\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.einaweb.es\/develop\/oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog Desarrollador\" \/>\n<meta property=\"article:published_time\" content=\"2013-04-29T08:01:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-04-29T08:01:54+00:00\" \/>\n<meta name=\"author\" content=\"Angel Fernandez Gutierrez\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@afernandezg76\" \/>\n<meta name=\"twitter:site\" content=\"@afernandezg76\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Angel Fernandez Gutierrez\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.einaweb.es\/develop\/oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server\/\",\"url\":\"http:\/\/www.einaweb.es\/develop\/oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server\/\",\"name\":\"Oracle XE oracle-xe-11.2.0-1.0.x86_64 in Ubuntu Server - Blog Desarrollador\",\"isPartOf\":{\"@id\":\"http:\/\/www.einaweb.es\/develop\/#website\"},\"datePublished\":\"2013-04-29T08:01:18+00:00\",\"dateModified\":\"2013-04-29T08:01:54+00:00\",\"author\":{\"@id\":\"http:\/\/www.einaweb.es\/develop\/#\/schema\/person\/2d3361868423160a6db46ce6f9fc9a3c\"},\"description\":\"Oracle XE oracle-xe-11.2.0-1.0.x86_64 in Ubuntu Server - Blog Desarrollador\",\"breadcrumb\":{\"@id\":\"http:\/\/www.einaweb.es\/develop\/oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.einaweb.es\/develop\/oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.einaweb.es\/develop\/oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"http:\/\/www.einaweb.es\/develop\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle XE oracle-xe-11.2.0-1.0.x86_64 in Ubuntu Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.einaweb.es\/develop\/#website\",\"url\":\"http:\/\/www.einaweb.es\/develop\/\",\"name\":\"Blog Desarrollador\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/www.einaweb.es\/develop\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/www.einaweb.es\/develop\/#\/schema\/person\/2d3361868423160a6db46ce6f9fc9a3c\",\"name\":\"Angel Fernandez Gutierrez\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"http:\/\/www.einaweb.es\/develop\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/366f7c75ad085d0dcc2c290559c1aa5947679d86e3a8c55db42ac1c26e16c816?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/366f7c75ad085d0dcc2c290559c1aa5947679d86e3a8c55db42ac1c26e16c816?s=96&d=mm&r=g\",\"caption\":\"Angel Fernandez Gutierrez\"},\"url\":\"http:\/\/www.einaweb.es\/develop\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle XE oracle-xe-11.2.0-1.0.x86_64 in Ubuntu Server - Blog Desarrollador","description":"Oracle XE oracle-xe-11.2.0-1.0.x86_64 in Ubuntu Server - Blog Desarrollador","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.einaweb.es\/develop\/oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server\/","og_locale":"es_ES","og_type":"article","og_title":"Oracle XE oracle-xe-11.2.0-1.0.x86_64 in Ubuntu Server - Blog Desarrollador","og_description":"Oracle XE oracle-xe-11.2.0-1.0.x86_64 in Ubuntu Server - Blog Desarrollador","og_url":"http:\/\/www.einaweb.es\/develop\/oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server\/","og_site_name":"Blog Desarrollador","article_published_time":"2013-04-29T08:01:18+00:00","article_modified_time":"2013-04-29T08:01:54+00:00","author":"Angel Fernandez Gutierrez","twitter_card":"summary_large_image","twitter_creator":"@afernandezg76","twitter_site":"@afernandezg76","twitter_misc":{"Escrito por":"Angel Fernandez Gutierrez","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/www.einaweb.es\/develop\/oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server\/","url":"http:\/\/www.einaweb.es\/develop\/oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server\/","name":"Oracle XE oracle-xe-11.2.0-1.0.x86_64 in Ubuntu Server - Blog Desarrollador","isPartOf":{"@id":"http:\/\/www.einaweb.es\/develop\/#website"},"datePublished":"2013-04-29T08:01:18+00:00","dateModified":"2013-04-29T08:01:54+00:00","author":{"@id":"http:\/\/www.einaweb.es\/develop\/#\/schema\/person\/2d3361868423160a6db46ce6f9fc9a3c"},"description":"Oracle XE oracle-xe-11.2.0-1.0.x86_64 in Ubuntu Server - Blog Desarrollador","breadcrumb":{"@id":"http:\/\/www.einaweb.es\/develop\/oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.einaweb.es\/develop\/oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.einaweb.es\/develop\/oracle-xe-oracle-xe-11-2-0-1-0-x86_64-in-ubuntu-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"http:\/\/www.einaweb.es\/develop\/"},{"@type":"ListItem","position":2,"name":"Oracle XE oracle-xe-11.2.0-1.0.x86_64 in Ubuntu Server"}]},{"@type":"WebSite","@id":"http:\/\/www.einaweb.es\/develop\/#website","url":"http:\/\/www.einaweb.es\/develop\/","name":"Blog Desarrollador","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.einaweb.es\/develop\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"es"},{"@type":"Person","@id":"http:\/\/www.einaweb.es\/develop\/#\/schema\/person\/2d3361868423160a6db46ce6f9fc9a3c","name":"Angel Fernandez Gutierrez","image":{"@type":"ImageObject","inLanguage":"es","@id":"http:\/\/www.einaweb.es\/develop\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/366f7c75ad085d0dcc2c290559c1aa5947679d86e3a8c55db42ac1c26e16c816?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/366f7c75ad085d0dcc2c290559c1aa5947679d86e3a8c55db42ac1c26e16c816?s=96&d=mm&r=g","caption":"Angel Fernandez Gutierrez"},"url":"http:\/\/www.einaweb.es\/develop\/author\/admin\/"}]}},"_links":{"self":[{"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/posts\/169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/comments?post=169"}],"version-history":[{"count":2,"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/posts\/169\/revisions"}],"predecessor-version":[{"id":171,"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/posts\/169\/revisions\/171"}],"wp:attachment":[{"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/media?parent=169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/categories?post=169"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.einaweb.es\/develop\/wp-json\/wp\/v2\/tags?post=169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}