mson77: 2007

outubro 10, 2007

Red Hat 9 : atualizar via YUM

Segue um arquivo "yum.conf" que funciona para Red Hat 9:

# This yum configuration file is suitable for RedHat Linux 9 installations.
# It is configured to update out of RedWire Broadband's mirror servers.
#
# See http://www.fedoraproject.org/wiki/Legacy/Yum9Detailed for details on how
# to install yum on legacy RedHat 9 systems. Basically, run these commands:
#
#  rpm -Uvh http://download.fedoralegacy.org/redhat/9/updates/i386/gnupg-1.2.1-9.i386.rpm
# rpm -ivh http://download.fedoralegacy.org/redhat/9/legacy-utils/i386/yum-2.0.5-0.9.2.legacy.noarch.rpm
# rpm --import http://www.fedoralegacy.org/FEDORA-LEGACY-GPG-KEY http://www.redhat.com/security/db42a60e.txt http://fedora-us.sd2.mirrors.redwire.net/fedora/FEDORA-GPG-KEY http://www.jpackage.org/jpackage.asc
#
#
# Japheth Cleaver 
#
# v1.2 -  7/24/06 - Add Redwire's redhat9 repository
# v1.1 -  3/21/06 - Removed DAG and disabled repositories
#


[main]
cachedir=/var/cache/yum
debuglevel=2
logfile=/var/log/yum.log
pkgpolicy=newest
#exclude=kernel*
distroverpkg=redhat-release
failovermethod=priority
tolerant=1
exactarch=1
retries=20


##############################################################################################
# Fedora Legacy Project - from http://www.fedoralegacy.org/download/fedoralegacy-mirrors.php
##############################################################################################

[base]
name=RedHat Linux $releasever - $basearch - Base
baseurl=http://fedoralegacy.mirrors.redwire.net/redhat/$releasever/os/$basearch/
http://download.fedoralegacy.org/redhat/$releasever/os/$basearch/
failovermethod=priority
gpgcheck=1

[updates]
name=RedHat Linux $releasever - $basearch - Updates
baseurl=http://fedoralegacy.mirrors.redwire.net/redhat/$releasever/updates/$basearch/
http://download.fedoralegacy.org/redhat/$releasever/updates/$basearch/
failovermethod=priority
gpgcheck=1

[legacy-utils]
name=RedHat Linux $releasever - $basearch - Legacy Utilities
baseurl=http://fedoralegacy.mirrors.redwire.net/redhat/$releasever/legacy-utils/$basearch/
http://download.fedoralegacy.org/redhat/$releasever/legacy-utils/$basearch/
failovermethod=priority
gpgcheck=1



##########################################################################
# Entries for Fedora.us - from http://www.fedora.us/wiki/FedoraSources#yum
##########################################################################

[fedora-us-stable]
name=RedHat Linux $releasever - $basearch - Extras (Fedora US)
baseurl=http://fedora-us.mirrors.redwire.net/fedora/redhat/$releasever/$basearch/yum/stable/
http://download.fedora.us/fedora/redhat/$releasever/$basearch/yum/stable/
failovermethod=priority
gpgcheck=1


##########################################################################
# Entries for jpackage.org - http://jpackage.org/repos.php
##########################################################################

[jpackage15-generic]
name=JPackage 1.5, generic
failovermethod=priority
gpgcheck=1
baseurl=http://jpackage.mirrors.redwire.net/1.5/generic/free/
ftp://jpackage.hmdc.harvard.edu/JPackage/1.5/generic/free/
http://mirrors.sunsite.dk/jpackage/1.5/generic/free/

[jpackage15-rh9]
name=JPackage 1.5 for RedHat Linux $releasever
failovermethod=priority
gpgcheck=1
baseurl=http://jpackage.mirrors.redwire.net/1.5/redhat-$releasever/free/
ftp://jpackage.hmdc.harvard.edu/JPackage/1.5/redhat-$releasever/free/
http://mirrors.sunsite.dk/jpackage/1.5/redhat-$releasever/free/


##########################################################################
# Entries for Redwire packages
##########################################################################

[redwire-generic]
name=Redwire Broadband, generic packages
baseurl=http://mirrors.redwire.net/pub/local-rpms/fedora/standard/
enabled=1
gpgcheck=0


[redwire-release]
name=Redwire Broadband, for RedHat Linux $releasever
baseurl=http://mirrors.redwire.net/pub/local-rpms/redhat/$releasever/
enabled=1
gpgcheck=0

Conferir esse link:
http://fr.rpmfind.net/linux/RPM/Dag_Apt_Repository_for_Red_Hat_9.html

outubro 08, 2007

Quando conecto VPN Cliente, eu não acesso mais internet.

Olá,

Vá nas propriedades da conexão VPN, e selecione a aba REDE:
Siga as instruções abaixo:

Criar uma conexão VPN cliente no Windows XP

Segue abaixo as telas de como criar uma conexão VPN cliente no ambiente Microsoft Windows XP.
VPN da Microsoft utiliza o protocolo MS-CHAP v2 onde os dados fluem criptografados em 128-bits. VPN padrão utiliza a porta TCP/1723.

Pronto. A sua conexão VPN cliente está criada. Agora você vai apenas precisar de credenciais de usuário e senha para se conectar ao servidor VPN e ter acesso aos recursos da esfera remota.

outubro 02, 2007

Automatizar serviço Oracle (dbstart / dbshut)

Criar um arquivo /etc/rc.d/init.d/oracle

#!/bin/sh
#
# /etc/rc.d/init.d/oracle
# Descrição: Starts and stops the Oracle database and listeners
#
case "$1" in
start)
      echo -n "Iniciando Oracle Databases: "
      echo "----------------------------------------------------" >> /var/log/oracle
      date +"! %T %a %D : Iniciando Oracle Databases na inicialização do sistema." >> /var/log/oracle
      echo "----------------------------------------------------" >> /var/log/oracle
      su - oracle -c dbstart >> /var/log/oracle
      echo "Done."
      echo -n "Iniciando Oracle Listeners: "
      su - oracle -c "lsnrctl start" >> /var/log/oracle
      echo "Done."
      echo ""
      echo "----------------------------------------------------" >> /var/log/oracle
      date +"! %T %a %D : Finalizado." >> /var/log/oracle
      echo "----------------------------------------------------" >> /var/log/oracle
      touch /var/lock/subsys/oracle
      ;;
stop)
      echo -n "Shutting Down Oracle Listeners: "
      echo "----------------------------------------------------" >> /var/log/oracle
      date +"! %T %a %D : Shutting Down Oracle Databases ao desmontar o sistema." >> /var/log/oracle
      echo "----------------------------------------------------" >> /var/log/oracle
      su - oracle -c "lsnrctl stop" >> /var/log/oracle
      echo "Done."
      rm -f /var/lock/subsys/oracle
      echo -n "Shutting Down Oracle Databases: "
      su - oracle -c dbshut >> /var/log/oracle
      echo "Done."
      echo ""
      echo "----------------------------------------------------" >> /var/log/oracle
      date +"! %T %a %D : Finished." >> /var/log/oracle
      echo "----------------------------------------------------" >> /var/log/oracle
      ;;
restart)
      echo -n "Reiniciando Oracle Databases: "
      echo "----------------------------------------------------" >> /var/log/oracle
      date +"! %T %a %D : Reiniciando Oracle Databases." >> /var/log/oracle
      echo "----------------------------------------------------" >> /var/log/oracle
      su - oracle -c dbstop >> /var/log/oracle
      su - oracle -c dbstart >> /var/log/oracle
      echo "Done."
      echo -n "Reiniciando Oracle Listeners: "
      su - oracle -c "lsnrctl stop" >> /var/log/oracle
      su - oracle -c "lsnrctl start" >> /var/log/oracle
      echo "Done."
      echo ""
      echo "----------------------------------------------------" >> /var/log/oracle
      date +"! %T %a %D : Finalizado." >> /var/log/oracle
      echo "----------------------------------------------------" >> /var/log/oracle
      touch /var/lock/subsys/oracle
      ;;
*)
      echo "Modo de usar: oracle {start|stop|restart}"
      exit 1
esac

Depois criar os links simbólicos:
diretório /etc/rc.d/rc3.d

ln -s ../init.d/oracle S70oracle

diretório /etc/rc.d/rc6.d

ln -s ../init.d/oracle K70oracle

outubro 01, 2007

Como definir TRACE

Como achar SID e SERIAL# de outras sessões:

col sid for 999999
col serial# for 999999
col username for a20
col osuser for a20

select s.sid,s.serial#,s.username,s.osuser
from v$session s,v$process p
where s.paddr=p.addr;

Oracle 10g R2 - DB Console

Sumário de uso da ferramenta "emca" (enterprise manager configuration assistant).

Create Database Console

Para criar repositorio e arquivos de configuração do DB Console (OEM), execute:

$ emca -config dbcontrol db -repos create

Drop Database Console

Para "dropar"... execute:

$ emca -deconfig dbcontrol db -repos drop

Recreate Database Console

Para recriar execute:

$ emca -config dbcontrol db -repos recreate

Usando "emca" em ambiente RAC

Uso do DB Control em ambiente RAC.

$ emca -displayConfig dbcontrol -cluster

Criar Database Console:

$ emca -config dbcontrol db -repos create -cluster

Drop Database Console:

$ emca -deconfig dbcontrol db -repos drop -cluster

Problemas podem ser observados nos arquivos de log localizados em:

ORACLE_HOME/cfgtoollogs/emca/seu_oracle_sid/

Criar "historico de comandos" no SQLPLUS e RMAN na plataforma LINUX

Muitos de vocês que já usaram SQLPLUS ou RMAN na plataforma Windows sabem como é útil a facilidade "histórico de comandos" que pode ser acessado através das setas "up" e "down".

Ai, você migra para plataforma Linux e vê que isso não mais existe. Hummm... o que fazer?

Na sua distro... instale o pacote "rlwrap".
No meu Fedora7 eu faço assim:

yum install rlwrap

Depois no arquivo .bashrc adicione as linhas:

alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'

E pronto!
Agora você pode desfrutar das facilidades antigas vividas!

Download rlwrap para RHEL4,CentOSv4,Unbreakable:
http://halisway.hifichoice.com/rlwrap-hali-0.26-1.x86_64.rpm
http://halisway.hifichoice.com/rlwrap-hali-0.26-1.i386.rpm

X-server para Windows: CYGWIN e Xming

Inicialmente eu usava o CYGWIN como servidor X para minha plataforma MS Windows.
CYGWIN pode ser baixado de: http://www.cygwin.com/

Depois eu conheci o Xming
Xming pode ser baixado de: http://www.straightrunning.com/XmingNotes/

Hoje a minha preferencia é para Xming. Ferramenta muito boa.

outubro 10, 2007

outubro 08, 2007

outubro 02, 2007

outubro 01, 2007

Arquivo do blog