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.</enter>A instalacao foi criada no diretorio .Passo 3: Setar as variaveis de ambiente.Para setar as variaveis de ambiente no Oracle , utilize o script oracle_env.sh incluso no diretorio de instalacao/u01/app/oracle/product/11.2.0/xe/bin[root@devoracle Disk1]# cd /u01/app/oracle/product/11.2.0/xe/binPara setar execute os comando abaixo.'. ./oracle_env.sh':[root@devoracle bin]# . ./oracle_env.shPara setar permanentemente para os usuarios, adicione as variaveis nos arquivos .bashrc ou .bash_profile dos usuarios que irao acessar.. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.shAgora acesso o SQL *PlusPasso 4 - Permitir Acesso Remoto ao Orace 11g XE.SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE); PL/SQL procedure successfully completed. Passo 5 - Mover a Flash Recovery Area (Fast Recovery Area)Para proteger uma possivel falha de disco, voce deve mover a Flash Recovery Area para um disco separado;Por default a Fast Recovery Area pode estar localizada em /u01/ap/oracle/fast_recovery_areaSQL> show parameter DB_RECOVERY_FILE_DEST; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/fast_recovery_area db_recovery_file_dest_size big integer 10G SQL> Entao, para poder mover devera ser criado uma pasta previa.[root@devoracle ~]# mkdir /opt/fra [root@devoracle ~]# chown oracle:dba /opt/fraSQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/opt/fra'; System altered. SQL> Para mover os arquivos use o script movelog.sql:SQL> @?/sqlplus/admin/movelogs SQL> SET FEEDBACK 1 SQL> SET NUMWIDTH 10 SQL> SET LINESIZE 80 SQL> SET TRIMSPOOL ON SQL> SET TAB OFF SQL> SET PAGESIZE 100 SQL> declare 2 cursor rlc is 3 select group# grp, thread# thr, bytes/1024 bytes_k 4 from v$log 5 order by 1; 6 stmt varchar2(2048); 7 swtstmt varchar2(1024) := 'alter system switch logfile'; 8 ckpstmt varchar2(1024) := 'alter system checkpoint global'; 9 begin 10 for rlcRec in rlc loop 11 stmt := 'alter database add logfile thread ' || 12 rlcRec.thr || ' size ' || 13 rlcRec.bytes_k || 'K'; 14 execute immediate stmt; 15 begin 16 stmt := 'alter database drop logfile group ' || rlcRec.grp; 17 execute immediate stmt; 18 exception 19 when others then 20 execute immediate swtstmt; 21 execute immediate ckpstmt; 22 execute immediate stmt; 23 end; 24 execute immediate swtstmt; 25 end loop; 26 end; 27 / PL/SQL procedure successfully completed. SQL> SQL> Agora, defina um tamanho adequado para a Area de recuperacao rapida.Utilize df -h para garantir que ha um amplo espaco.SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 20G; System altered.Verifique a nova localizacao e tamanho.SQL> show parameter DB_RECOVERY_FILE_DEST; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /opt/fra db_recovery_file_dest_size big integer 20G SQL> Passo 6: Adicionar membros para grupos de Redo Log.Voce deve ter pelo menos dois Grupos Redo e cada