A continuaci\u00f3n se detallan los pasos a seguir para poder instalar correctamente un servidor de base de datos Oracle XE.<\/p>\n
Para empezar, ser\u00e1 necesario descargar el fichero de instalaci\u00f3n para Linux del Oracle Server; para ello es necesario tener una cuenta en Oracle, que es gratuita, pero que resulta un poco molesta crear, sobre todo porque vas a acceder a un software gratuito, pero es un peaje que hay que pagar.
\nUna vez descargado el ejecutable procedemos a descomprimirlo<\/p>\n
Lo cual produce el siguiente mensaje de error<\/p>\n This system does not meet the minimum requirements for swap space. Based on error: %pre(oracle-xe-11.2.0-1.0.x86_64) scriptlet failed, exit status 1 Para evitar este error Generamos la partici\u00f3n de swap sudo swapon \/swapfile<\/p>\n sudo cp \/etc\/fstab \/etc\/fstab.orig<\/p>\n sudo chmod 777 \/etc\/fstab.orig Para comprobar que esta bien: Y ahora s\u00ed que ejecutamos el instalable sudo \/etc\/init.d\/oracle-xe configure<\/p>\n Oracle Database 11g Express Edition Configuration Specify the HTTP port that will be used for Oracle Application Express [8080]:<\/p>\n Specify a port that will be used for the database listener [1521]:<\/p>\n Specify a password to be used for database accounts. Note that the same Do you want Oracle Database 11g Express Edition to be started on boot (y\/n) [y]:<\/p>\n Starting Oracle Net Listener...Done Crear usuario de acceso a base de datos Dar permiso de conexi\u00f3n al usuario reci\u00e9n creadosudo unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip -d
\n<\/code>
\nE intentamos ejecutar el instalable<\/p>\nsudo rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm<\/code><\/p>\nPreparing... ########################################### [100%]<\/p>\n
\nthe amount of physical memory available on the system, Oracle Database 11g
\nExpress Edition requires 2048 MB of swap space. This system has 0 MB
\nof swap space. Configure more swap space on the system and retry the
\ninstallation.<\/p>\n
\nerror: install: %pre scriptlet failed (2), skipping oracle-xe-11.2.0-1.0<\/code><\/p>\n
\nsudo dd if=\/dev\/zero of=\/swapfile bs=1024 count=2097152
\n2097152+0 records in
\n2097152+0 records out
\n2147483648 bytes (2.1 GB) copied, 36.531 s, 58.8 MB\/s<\/code><\/p>\n
\nsudo mkswap \/swapfile
\nmkswap: \/swapfile: warning: don't erase bootbits sectors
\n on whole disk. Use -f to force.
\nSetting up swapspace version 1, size = 2097148 KiB
\nno label, UUID=132a8739-0156-4c57-b3f8-b35bf8830085<\/p>\n
\nsudo chmod 777 \/etc\/fstab
\nsudo echo '\/swapfile swap swap defaults 0 0' >> \/etc\/fstab <\/code><\/p>\n
\nsudo swapon -a
\nsudo swapon -s
\nFilename Type Size Used Priority
\n\/swapfile file 2097148 0 -1<\/code><\/p>\n
\nsudo rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm
\nPreparing... ########################################### [100%]
\n 1:oracle-xe ########################################### [100%]
\nExecuting post-install steps...
\nYou must run '\/etc\/init.d\/oracle-xe configure' as the root user to configure the database.<\/p>\n
\n-------------------------------------------------
\nThis will configure on-boot properties of Oracle Database 11g Express
\nEdition. The following questions will determine whether the database should
\nbe starting upon system boot, the ports it will use, and the passwords that
\nwill be used for database accounts. Press
\nCtrl-C will abort.<\/p>\n
\npassword will be used for SYS and SYSTEM. Oracle recommends the use of
\ndifferent passwords for each database account. This can be done after
\ninitial configuration:
\nConfirm the password:<\/p>\n
\nConfiguring database...Done
\nStarting Oracle Database 11g Express Edition instance...Done
\nInstallation completed successfully.<\/code><\/p>\nsudo \/u01\/app\/oracle\/product\/11.2.0\/xe\/bin\/oracle_env.sh
\n<\/code>
\nConectar a la base de datos<\/strong>
\nCon el usuario oracle
\n.\/sqlplus \/ as sysdba<\/p>\n
\nCREATE USER MYUSER IDENTIFIED BY MYPWD;<\/code><\/p>\n
\ngrant create session to MYUSER;
\n<\/code>
\nIniciar la instancia XE de base de datos
\n<\/strong>Despu\u00e9s de conectarse como SYS as SYSDBA
\n.\/sqlplus SYS@XE as SYSDBA<\/code><\/p>\nSTARTUP pfile=\/RUTA-INSTALACION-ORACLE\/app\/oracle\/product\/11.2.0\/xe\/dbs\/spfileXE.ora<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"