Instalação Oracle XE
Instalação Pacotes Requeridos
Packages
glibcshould be greater than or equal to2.3.4-2.41makeshould be greater than or equal to3.80binutilsshould be greater than or equal to2.16.91.0.5gccshould be greater than or equal to4.1.2libaioshould be greater than or equal to0.3.104
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
[root@bdxe~]# yum -y install glibc make binutils gcc libaio Dependencies Resolved ========================================================================================================================== Package Arch Version Repository Size ========================================================================================================================== Updating: binutils x86_64 2.27-27.base.el7 ol7_latest 5.9 M gcc x86_64 4.8.5-28.0.1.el7 ol7_latest 16 M glibc x86_64 2.17-222.el7 ol7_latest 3.6 M Updating for dependencies: cpp x86_64 4.8.5-28.0.1.el7 ol7_latest 6.0 M gcc-c++ x86_64 4.8.5-28.0.1.el7 ol7_latest 7.2 M glibc-common x86_64 2.17-222.el7 ol7_latest 11 M glibc-devel x86_64 2.17-222.el7 ol7_latest 1.1 M glibc-headers x86_64 2.17-222.el7 ol7_latest 678 k libgcc x86_64 4.8.5-28.0.1.el7 ol7_latest 100 k libgomp x86_64 4.8.5-28.0.1.el7 ol7_latest 156 k libstdc++ x86_64 4.8.5-28.0.1.el7 ol7_latest 303 k libstdc++-devel x86_64 4.8.5-28.0.1.el7 ol7_latest 1.5 M Transaction Summary ========================================================================================================================== Upgrade 3 Packages (+9 Dependent packages) Total download size: 54 M Is this ok [y/d/N]: y |
Adicionar os seguintes parâmetros de Kernel
|
1 2 3 4 5 6 |
[root@bdxe~]# vim /etc/sysctl.conf kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 fs.file-max = 6815744 net.ipv4.ip_local_port_range = 9000 65500 |
Baixar Oracle XE: Download
Descompactar o arquivo: oracle-xe-11.2.0-1.0.x86_64.rpm.zip
|
1 2 3 4 5 6 7 8 |
[root@bdxe /]# unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip Archive: oracle-xe-11.2.0-1.0.x86_64.rpm.zip creating: Disk1/ creating: Disk1/upgrade/ inflating: Disk1/upgrade/gen_inst.sql creating: Disk1/response/ inflating: Disk1/response/xe.rsp inflating: Disk1/oracle-xe-11.2.0-1.0.x86_64.rpm |
Instalar com o RPM -ivh
|
1 2 3 4 5 |
[root@bdxe /]# rpm -ivh Disk1/oracle-xe-11.2.0-1.0.x86_64.rpm Preparing... ########################################### [100%] 1:oracle-xe ########################################### [100%] Executing post-install steps... You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database. |
Executar etapa pós instalação com usuário root.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
[root@bdxe /]# /etc/init.d/oracle-xe configure Oracle Database 11g Express Edition Configuration ------------------------------------------------- This will configure on-boot properties of Oracle Database 11g Express Edition. The following questions will determine whether the database should be starting upon system boot, the ports it will use, and the passwords that will be used for database accounts. Press <Enter> to accept the defaults. Ctrl-C will abort. Specify the HTTP port that will be used for Oracle Application Express [8080]: Specify a port that will be used for the database listener [1521]: Specify a password to be used for database accounts. Note that the same password will be used for SYS and SYSTEM. Oracle recommends the use of different passwords for each database account. This can be done after initial configuration: Confirm the password: Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:y Starting Oracle Net Listener...Done Configuring database...Done Starting Oracle Database 11g Express Edition instance...Done Installation completed successfully. |
Login usuário oracle
|
1 2 3 4 5 |
[root@localhost /]# su - oracle -bash-4.1$ sqlplus / as sysdba -bash: sqlplus: command not found -bash-4.1$ source product/11.2.0/xe/bin/oracle_env.sh -bash-4.1$ sqlplus / AS SYSDBA |
Consultando a view v$instance
|
1 2 3 4 5 |
SQL> select status from v$instance; STATUS ------------ OPEN |
Consultar nome instância
|
1 2 3 4 5 |
SQL> SELECT * FROM GLOBAL_NAME; GLOBAL_NAME -------------------------------------------------------------------------------- XE |
Fonte:Portilho – Nerv Informática