#

#

  • 512 MB de RAM y 1 GB de swap mínimo.
  • 800 MB para los archivos de instalación.
  • 3 GB para la instalación de la instancia de Oracle.
  • Los siguientes paquetes instalados:
  • binutils-2.15.92.0.2
  • compat-db-4.1.25
  • control-center-2.8.0
  • gcc-3.4.3
  • gcc-c++-3.4.3
  • glibc-2.3.4
  • glibc-common-2.3.4
  • gnome-libs-1.4.1.2.90
  • libstdc++-3.4.3
  • libstdc++-devel
  • make-3.80-5
  • pdksh-5.2.14
  • sysstat-5.0.5
  • xscreensaver-4.18
  • libaio-0.3.96
  • libXp

#

Edita los parametros del kernel de a cuerdo a las recomendaciones de Oracle.

/etc/sysctl.conf kernel.shmall kernel.shmmax kernel.shmmni kernel.sem fs.file-max net.ipv4.ip_local_port_range net.core.rmem_default net.core.rmem_max net.core.wmem_default net.core.wmem_max

Ejecuta ‘'’sysctl -p’’’ para recargar la configuración de los parametros del kernel.

Crea las cuentas de usuario de Oracle.

Edita ‘‘/etc/security/limits.conf’’

’‘/etc/security/limits.conf’’

oracle soft nofile 4096 oracle hard nofile 65536

Crea directorios para software y bases de datos de Oracle

Edita ‘‘/home/oracle/.bash_profile’’ para configurar las variables de entorno de la instancia Oracle.

/home/oracle/.bash_profile ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_SID=tibdb; export ORACLE_SID

#

#

Edita /home/oracle/.bash_profile

ORACLE_BASE=/u01/app/oracle ORACLE_SID=tibdb ORACLE_OWNER=oracle ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0/db_1 PATH=$ORACLE_HOME/bin:$PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

export ORACLE_BASE ORACLE_HOME ORACLE_SID ORACLE_OWNER PATH LD_LIBRARY_PATH </code>

#

’'’Conectar a sqlplus’’’

$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 7 00:46:51 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect / as sysdba Connected to an idle instance. </code>

#

SQL> startup ORACLE instance started.

Total System Global Area 1191182336 bytes Fixed Size 2020320 bytes Variable Size 318770208 bytes Database Buffers 855638016 bytes Redo Buffers 14753792 bytes Base de datos montada. Base de datos abierta. SQL> </code>

#

SQL> shutdown Database closed. Database dismounted. ORACLE instance shut down. SQL>

#

’'’Oracle Net Listnener’’’

Iniciar Oracle Net Listener

$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-DEC-2009 12:54:54

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /u01/app/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 10.2.0.1.0 - Production System parameter file is /u01/app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/oracle/product/10.2.0/db_1/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bladerunner.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER ———————— Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 13-DEC-2009 12:54:57 Uptime 0 days 0 hr. 0 min. 1 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/oracle/product/10.2.0/db_1/network/log/listener.log Listening Endpoints Summary… (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bladerunner.localdomain)(PORT=1521))) Services Summary… Service “PLSExtProc” has 1 instance(s). Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) for this service… The command completed successfully </code>

’'’Detener Oracle Net Listener’’’

$ lsnrctl stop

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-DEC-2009 13:57:26

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) The command completed successfully </code>

’'’Oracle Enterprise Manager’’’

[[http://localhost:1158/em/console/]]

Inicia Oracle Enterprise Manager

$ emctl start dbconsole TZ set to Mexico/General Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved. http://bladerunner.localdomain:1158/em/console/aboutApplication Starting Oracle Enterprise Manager 10g Database Control .......... started. ------------------------------------------------------------------ Logs are generated in directory /u01/app/oracle/oracle/product/10.2.0/db_1/bladerunner.localdomain_tibdb/sysman/log

Detener Oracle Enterprise Manager

$ emctl stop dbconsole TZ set to Mexico/General Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved. http://bladerunner.localdomain:1158/em/console/aboutApplication Stopping Oracle Enterprise Manager 10g Database Control ... ... Stopped.

’'’iSQL*Plus’’’

[[http://localhost:5560/isqlplus/]]

Iniciar iSQL*Plus

]$ isqlplusctl start iSQL*Plus 10.2.0.1.0 Copyright (c) 2003, 2005, Oracle. All rights reserved. Starting iSQL*Plus ... iSQL*Plus started.

Detener iSQL*Plus

$ isqlplusctl stop iSQL*Plus 10.2.0.1.0 Copyright (c) 2003, 2005, Oracle. All rights reserved. Stopping iSQL*Plus ... iSQL*Plus stopped.

#

CREATE TABLESPACE ofpartes LOGGING DATAFILE '/u02/oradata/tdemo/ofpartes.dbf' SIZE 32M AUTOEXTEND ON NEXT 32M EXTENT MANAGEMENT LOCAL

CREATE USER tibusr IDENTIFED BY tibusr; GRANT sysdba TO tibusr;

Tips

DESC nombre_tabla

SELECT table_name, contraint_name FROM all_contraints

#

oratab /etc/oratab es un archivo delimitado por dos puntos : que asocia los valores de ORACLE_SID y ORACLE_HOME, el último campo contiene Y o N para controlar el inicio de una instancia con el sistema operativo.

Rutas /var/opt/oracle o /etc

Scripts como oraenv, dbhome dbstart y dbshut lo utilizan.

Referencias

  • [[[http://www.puschitz.com/InstallingOracle10g.shtml   Installing Oracle Database 10g Release 1 and 2 (32-bit/64-bit) on Red Hat Enterprise Linux AS 4, 3, 2.1, Red Hat Fedora Core 4, 3, 1, RH 9 on x86 and x86-64 (AMD64/EM64T) Architecture]]]
  • [[[http://www.oracle.com/pls/db102/homepage   Oracle Database Documentation Library]]]
  • [[[http://www.orafaq.com/wiki/Main_Page   Oracle FAQ]]]
  • [[[http://database-diva.com/blog/?p=8 Permisos de changePerm.sh]]]