[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