viernes, 31 de julio de 2009
lunes, 27 de julio de 2009
viernes, 24 de julio de 2009
Instalación Oracle10g en Linux Red Hat
[root@localhost ~]# groupdel dba
[root@localhost ~]# groupdel oper
[root@localhost ~]# userdel oracle
[root@localhost ~]# groupdel oinstall
[root@localhost ~]# /usr/sbin/groupadd dba
[root@localhost ~]# /usr/sbin/groupadd oper
[root@localhost ~]# /usr/sbin/groupadd oinstall
[root@localhost ~]# mkdir -p /u01/app
[root@localhost ~]# /usr/sbin/useradd -g oinstall -G dba,oper -d /u01/app/ oracle
[root@localhost ~]# passwd oracle <--poner password 2 veces
[root@localhost ~]# vi /etc/group <--añadir :oracle a oinstall
[root@localhost ~]# /usr/sbin/usermod -g oinstall -G dba,oper -d /u01/app/ oracle
[root@localhost ~]# chwon -R oracle:oinstall /u01/app/
[root@localhost ~]# chmod -R 775 /u01/app
[root@localhost ~]# xhost +
[root@localhost ~]# su - oracle
[oracle@localhost ~]# cd /u01/database/ <-- buscar instalador
[oracle@localhost database]$ ./runInstaller
...Passed ...se siguen las instrucciones
[oracle@localhost database]$ cd ..
[oracle@localhost u01]$ cd app/oracle/product/10.2.0/db_1/bin
[oracle@localhost bin]$ ./dbca
...Aquí instala la Base de Datos...se siguen las instrucciones
[oracle@localhost db_1]$ cd ./../../../../..
[oracle@localhost app]$ vi .bash_profile
...Aquí se setean las variables
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1/
export ORACLE_BASE=/u01/app/oracle/product/10.2.0/db_1/
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
... En otra consola
[root@localhost ~]# su - oracle
[oracle@localhost ~]$ lsnrctl start;
[oracle@localhost ~]$ sqlplus "/ as sysdba";
SQL>
[oracle@localhost ~]$ cd /u01/app/oracle/product/10.2.0/db_1/bin
[oracle@localhost bin]$ ./rman
RMAN>
http://localhost.localdomain:1158/em