[FUG-BR] Oracle 10g - FreeBSD - Funcionando
Leo Getz
getz.leo em gmail.com
Quinta Março 1 20:14:41 BRT 2007
Pessoal,
O belo Oracle 10g roda perfeitamente no FreeBSD. Estou rodando ele em um
6.2-RELEASE
FreeBSD oracle.********* FreeBSD 6.2-RELEASE #0: Thu Mar 1 18:02:10 BRT
2007 sysop@***********.br:/usr/src/sys/i386/compile/ORACLE i386 i386
[oracle] ~> ps -xa | grep oracle
688 ?? Is 0:00.11
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER
-inherit
693 ?? Ss 0:00.26 xe_pmon_XE (oracle)
695 ?? Ss 0:00.12 xe_psp0_XE (oracle)
697 ?? Ss 0:00.13 xe_mman_XE (oracle)
699 ?? Ss 0:00.33 xe_dbw0_XE (oracle)
701 ?? Ss 0:00.22 xe_lgwr_XE (oracle)
703 ?? Ss 0:00.19 xe_ckpt_XE (oracle)
705 ?? Ss 0:00.67 xe_smon_XE (oracle)
707 ?? Ss 0:00.16 xe_reco_XE (oracle)
709 ?? Ss 0:00.49 xe_cjq0_XE (oracle)
711 ?? Ss 0:01.40 xe_mmon_XE (oracle)
713 ?? Ss 0:00.16 xe_mmnl_XE (oracle)
715 ?? Ss 0:00.25 xe_d000_XE (oracle)
717 ?? Ss 0:06.20 xe_s000_XE (oracle)
719 ?? Ss 0:02.91 xe_s001_XE (oracle)
721 ?? Ss 0:00.72 xe_s002_XE (oracle)
723 ?? Ss 0:01.45 xe_s003_XE (oracle)
734 ?? Ss 0:00.09 xe_qmnc_XE (oracle)
742 ?? Ss 0:00.09 xe_q000_XE (oracle)
744 ?? Ss 0:00.08 xe_q001_XE (oracle)
[oracle] ~> sockstat -4 | grep oracle
oracle oracle 723 15 udp4 127.0.0.1:61814 *:*
oracle oracle 721 15 udp4 127.0.0.1:59765 *:*
oracle oracle 719 15 udp4 127.0.0.1:51720 *:*
oracle oracle 717 15 udp4 127.0.0.1:49907 *:*
oracle oracle 715 15 udp4 127.0.0.1:54160 *:*
oracle oracle 715 85 tcp4 *:64234 *:*
oracle oracle 693 16 udp4 127.0.0.1:49166 *:*
oracle oracle 693 17 tcp4 192.168.71.90:61765 192.168.71.90:1521
oracle tnslsnr 688 10 tcp4 *:1521 *:*
oracle tnslsnr 688 12 tcp4 192.168.71.90:1521
192.168.71.90:61765
oracle tnslsnr 688 13 tcp4 *:8080 *:*
Versão
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
Banco de Dados
NOME XE
CREATED 01/03/07 18:24:54
RESETLOGS_TIME 01/03/07 18:24:55
PRIOR_RESETLOGS_CHANGE# 1
PRIOR_RESETLOGS_TIME 31/01/06
LOG_MODE NOARCHIVELOG
CHECKPOINT_CHANGE# 440541
ARCHIVE_CHANGE# 393764
OPEN_RESETLOGS NOT ALLOWED
VERSION_TIME 01/03/07 18:24:54
OPEN_MODE READ WRITE
PROTECTION_MODE MAXIMUM PERFORMANCE
PROTECTION_LEVEL UNPROTECTED
REMOTE_ARCHIVE ENABLED
DATABASE_ROLE PRIMARY
ARCHIVELOG_CHANGE# 393626
SWITCHOVER_STATUS SESSIONS ACTIVE
DATAGUARD_BROKER DISABLED
GUARD_STATUS NONE
FORCE_LOGGING NO
Resumindo a historia toda, roda beeeeeeeem mais rapido que a mesma
versão no LINUX (sem flames gente, por favor) e precisa de menos memória
RAM
do que o solicitado no LINUX.... agora vou partir para alguns testes
porem o que vi ja gostei muito...
Assim que tiver tudo OK, mandarei para a lista o HowTo...
Abraços
Leo "Getz"
Mais detalhes sobre a lista de discussão freebsd