Category: Instalación
Oracle 11gr2 : Aplicando nuestro primer PSU ABRIL 2010
Oracle lanzó el día de ayer , 13 de Abril su CPU correspondiente a Abril 2010 , en el vienen los típicos CPU, pero viene una cosa en especial que es un PSU para Oracle 11gr2
La información la puedes ver AQUÍ
En este CPU , viene para la 11gr2 (11.2.0.1) un CPU y un PSU , los 2 arreglan los mismos inconvenientes y esto viene consignado en cada uno de los README
Antes de comenzar con la instalación , debemos cerciorarnos que en nuestra variable de medio ambiente PATH ,tenemos acceso a los utilitarios make , ar , ld y nm
Por ejemplo, una forma de buscarlo es con el comando which
[oracle@oracle11g 9352237]$ which make
/usr/bin/make
Si es encontrado significa que está en el PATH
Además se debe colocar en el PATH la ruta donde se encuentra el OPATCH, para ello ejecutamos el siguiente comando
export PATH=$PATH:$ORACLE_HOME/OPatch
Se debe verificar la versión del OPatch, tiene que ser 11.2.0.1.0 o superior
Primero se debe verificar la versión que estemos utilizando
[oracle@oracle11g parches_11_2_1_0]$ opatch version
Invoking OPatch 11.1.0.6.6OPatch Version: 11.1.0.6.6
OPatch succeeded.
Como no es la correspondiente , debemos bajarla desde Metalink , en la siguiente URL
E instalarla
[oracle@oracle11g parches_11_2_1_0]$ unzip p6880880_112000_LINUX.zip
Archive: p6880880_112000_LINUX.zip
creating: OPatch/
creating: OPatch/docs/
inflating: OPatch/docs/FAQ
inflating: OPatch/docs/Users_Guide.txt
inflating: OPatch/docs/Prereq_Users_Guide.txt
creating: OPatch/jlib/
inflating: OPatch/jlib/opatch.jar
inflating: OPatch/jlib/opatchutil.jar
inflating: OPatch/jlib/opatchprereq.jar
inflating: OPatch/jlib/opatchactions.jar
inflating: OPatch/jlib/opatchext.jar
inflating: OPatch/jlib/opatchfmw.jar
creating: OPatch/crs/
inflating: OPatch/crs/auto_patch.pl
inflating: OPatch/crs/crsconfig_lib.pm
inflating: OPatch/crs/crsdelete.pm
inflating: OPatch/crs/crspatch.pm
creating: OPatch/crs/log/
extracting: OPatch/crs/log/dummy
inflating: OPatch/crs/oracss.pm
inflating: OPatch/crs/patch112.pl
inflating: OPatch/crs/s_crsconfig_defs
inflating: OPatch/crs/s_crsconfig_lib.pm
creating: OPatch/fmw/
inflating: OPatch/fmw/application.py
inflating: OPatch/fmw/init_def.py
inflating: OPatch/fmw/main_driver.py
inflating: OPatch/fmw/node_manager.py
inflating: OPatch/fmw/prereq.py
inflating: OPatch/fmw/start_stop.py
creating: OPatch/opatchprereqs/
creating: OPatch/opatchprereqs/opatch/
inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml
inflating: OPatch/opatchprereqs/opatch/rulemap.xml
inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml
creating: OPatch/opatchprereqs/oui/
inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml
inflating: OPatch/opatchprereqs/prerequisite.properties
inflating: OPatch/opatch
inflating: OPatch/opatch.bat
inflating: OPatch/opatch.pl
inflating: OPatch/opatch.ini
inflating: OPatch/emdpatch.pl
inflating: OPatch/README.txt
creating: OPatch/ocm/
creating: OPatch/ocm/bin/
inflating: OPatch/ocm/bin/emocmrsp
inflating: OPatch/ocm/ocm_platforms.txt
creating: OPatch/ocm/lib/
inflating: OPatch/ocm/lib/emocmclnt-14.jar
inflating: OPatch/ocm/lib/emocmutl.jar
inflating: OPatch/ocm/lib/osdt_core3.jar
inflating: OPatch/ocm/lib/osdt_jce.jar
extracting: OPatch/ocm/ocm.zip
Eliminamos la anterior versión
Copiamos la que descomprimimos y verificamos la versión actual de nuestro OPatch
[oracle@oracle11g parches_11_2_1_0]$ rm -rf $ORACLE_HOME/OPatch
[oracle@oracle11g parches_11_2_1_0]$ cp -R OPatch $ORACLE_HOME/.
[oracle@oracle11g parches_11_2_1_0]$
[oracle@oracle11g parches_11_2_1_0]$
[oracle@oracle11g parches_11_2_1_0]$ cd $ORACLE_HOME/OPatch
[oracle@oracle11g OPatch]$ ./opatch version
Invoking OPatch 11.2.0.1.2OPatch Version: 11.2.0.1.2
OPatch succeeded.
[oracle@oracle11g OPatch]$
Después de lo anterior , podemos verificar que no haya problemas y/o conflictos con parches existentes, para ello ejecutamos el comando
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./9352237
OBS : Esto se debe hacer en la ruta donde se encuentra la carpeta del PSU
[oracle@oracle11g parches_11_2_1_0]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./9352237
Invoking OPatch 11.2.0.1.2Installer de Parche Temporal de Oracle versión 11.2.0.1.2
Copyright (c) 2010, Oracle Corporation. Todos los Derechos Reservados.PREREQ session
Directorio RaÃz de Oracle : /u01/app/oracle/product/11.2.0/dbhome_1
Inventario Central: /u01/app/oracle/oraInventory
de : /etc/oraInst.loc
Versión de OPatch : 11.2.0.1.2
Versión de OUI : 11.2.0.1.0
Ubicación de OUI : /u01/app/oracle/product/11.2.0/dbhome_1/oui
Ubicación de Archivo Log : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2010-04-13_13-32-28PM.logPatch history file: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
Para instalar el PSU se debe bajar la instancia y bajar el listener
Estando dentro de la carpeta del PSU , se ejecuta opatch apply
cd 9352237
opatch apply
Invoking OPatch 11.2.0.1.2
Oracle Interim Patch Installer version 11.2.0.1.2
Copyright (c) 2010, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.2
OUI version : 11.2.0.1.0
OUI location : /u01/app/oracle/product/11.2.0/dbhome_1/oui
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2010-04-13_14-34-26PM.logPatch history file: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '9352237' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Running prerequisite checks...
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: YOPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0/dbhome_1')Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '9352237' for restore. This might take a while...
Backing up files affected by the patch '9352237' for rollback. This might take a while...
Execution of 'sh /home/oracle/parches_11_2_1_0/9352237/custom/scripts/pre -apply 9352237 ':Return Code = 0
Patching component oracle.rdbms.rsf, 11.2.0.1.0...
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libpls11.a" with "lib/libpls11.a/phd.o"
....
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libcommon11.a" with "lib/libcommon11.a/kdzc.o"
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/libdbtools11.a" with "rdbms/lib/libdbtools11.a/krmq.o"Patching component oracle.rdbms.dbscripts, 11.2.0.1.0...
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/prvtamgt.plb"
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/utlu112i.sql"
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/utlu112x.sql"
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/catexp.sql"Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kcc.o"
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kdt.o"
....
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libasmclnt11.a" with "lib/libasmclnt11.a/kgfn.o"
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libasmclnt11.a" with "lib/libasmclnt11.a/kgfo.o"Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ktd.o"
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/jox.o"
...
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/psu/11.2.0.1.1/catpsu_rollback.sql"
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/bundledata_PSU.xml"Patching component oracle.oraolap, 11.2.0.1.0...
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/lib/liboraolap11.a" with "lib/liboraolap11.a/xscarrot.o"Patching component oracle.rdbms.deconfig, 11.2.0.1.0...
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libasmclnt11.so"Patching component oracle.javavm.server, 11.2.0.1.0...
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/javavm/install/jvm_exp.sql"
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/javavm/install/initjvm.sql"
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/javavm/install/jvmursc.sql"
Running make for target client_sharedlib
Running make for target irman
Running make for target ikfod
Running make for target irenamedg
Running make for target idgmgrl
Running make for target imkpatch
Running make for target client_sharedlib
Running make for target ioracle
ApplySession adding interim patch '9352237' to inventoryVerifying the update...
Inventory check OK: Patch ID 9352237 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 9352237 are present in Oracle Home.--------------------------------------------------------------------------------
********************************************************************************
********************************************************************************
** ATTENTION **
** **
** Please note that the Patch Set Update Installation (PSU Deinstallation) **
** is not complete until all the Post Installation (Post Deinstallation) **
** instructions noted in the Readme accompanying this PSU, have been **
** successfully completed. **
** **
********************************************************************************
********************************************************************************--------------------------------------------------------------------------------
Execution of 'sh /home/oracle/parches_11_2_1_0/9352237/custom/scripts/post -apply 9352237 ':
Return Code = 0
The local system has been patched and can be restarted.
OPatch succeeded.
Una vez instalado el parche , se debe ejecutar lo siguiente
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT
Y cualquier error , se debe verificar en
$ORACLE_HOME/cfgtoollogs/catbundle/catbundle_PSU_ORCL11G2_APPLY_2010Apr13_15_11_49.log
Y como punto final vemos el catálogo de parchado , según el OPatch
opatch lsinventory
Y la nueva versión del motor
SQL> col comments format a20
SQL> r
1* select version , comments from registry$historyVERSION COMMENTS
------------------------------ --------------------
11.2.0.1 PSU 11.2.0.1.1
Y ya.. tenemos instalado nuestro primer PSU para Oracle11gr2
Espero que les sirva
![]()
![]()
14.04.10. 15:13:25. 1548 words, 1048 views. Categories: Base de datos, Instalación, Oracle11gR2 , Leave a comment » • Send a trackback »
Oracle 11gr2 : Nueva característica Audit Trail Cleanup
Típico que un DBA pueda colocarle auditoría a una base de datos, ya sea, en Sistema Operativo o en base de datos a través de la tabla SYS.AUD$, incluso puede ir más allá y colocarle auditoría fina, la llamda FGA
Hasta allí , ninguna novedad, la novedad comienza cuando queremos hacer una mantención de esos archivos, ya sea borrar desde disco los trace, borrar desde las tablas de auditoría etc, ni hablar de generar un Job, casi siempre creamos una Shell y probablemente ni siquiera sepamos Shell Script..
Pues bien, les puedo comentar que desde Oracle11gr2 aparece un package llamado DBMS_AUDIT_MGMT, que puede hacer todas las labores pensadas para archivos de auditoría y más... ahora lo mejor

Todos los detalles de está gran facultad de Oracle, haciendo click en el siguiente link
Implementación y uso del Audit Trail Cleanup
Otros links interesantes
Usando el package DBMS_AUDIT_MGMT
Espero les sirva
![]()
![]()
22.03.10. 14:57:04. 184 words, 767 views. Categories: Instalación, Oracle11gR2 , Leave a comment » • Send a trackback »
Instalación de agentes Grid Control bajo el format MASS AGENT
Una forma muy simple de instalar un agente de Grid Control es utilizando el mecanismo Mass Agent, este mecánismo es tan útil, que dentro del Grid Control quedan todos los agentes que yo desee y después lo único que se debe hacer es bajar una shell (o archivo) desde una URL y ejecutarlo.
Sin necesidad de colocar DVDs o pedir Xterm.

Así de sencillo, te invito a que lo leas, pues te sorprenderá, ya que es una isntalación sin pantallas gráficas y lo mejor, casi en forma silenciosa 
Para descargar el documento haz click Manual de Instalación MASS Agent
Espero sea de utilidad
![]()
![]()
04.03.10. 14:29:34. 109 words, 1123 views. Categories: Enterprise Manager Grid Control, Instalación , Leave a comment » • Send a trackback »
Oracle 11gr2 : Tool deinstall
Si quieres desinstalar algo en Oracle , casi siempre esta a mano el OUI , cierto?
Con su interfaz gráfica y que de verdad ayuda bastante, pero como la idea de Oracle es que te quedes obsoleto lo antes posible, en la versión Oracle11gr2 lanzo al mercado una tool para realizar las desinstalaciones de productos Oracle, esta tool simplemente se llama deinstall
, obvio, y dentro del OUI ya no aparece el "Uninstalled Products"
La acabo de usar , y por su interfaz no gráfica, me da la idea de que es mucho más segura que el OUI, además desinstala los productos aunque se hayan instalado mal. Y un dato no menor, cuando se desinstalan productos Oracle con el deinstall, si hay ASM de por medio, también resetea la cabecera de los discos para que queden como PROVISIONED en la siguiente instalación y no tener que hacer a mano un comando dd.
Se baja este utilitario desde la siguiente URL
http://www.oracle.com/technology/software/products/database/oracle11g/112010_linx8664soft.html
Y se llama
Oracle De-install Utility (11.2.0.1.0) for Linux x86-64 (existe también para 32 bits)
He aquí un ejemplo para ambiente RAC
- Se baja el utilitario , se descomprime el archivo
- Se ejecuta el desinstalador, indicandole el ORACLE_HOME que deseamos remover
[oracle@oracle11gnodo1 instaladores]$ cd deinstall/
[oracle@oracle11gnodo1 deinstall]$ ls -ltr
total 216
-r-xr-xr-x 1 oracle oinstall 31544 Apr 1 01:24 sshUserSetup.sh
-r--r--r-- 1 oracle oinstall 3154 Jul 13 08:01 deinstall.xml
-r-xr-xr-x 1 oracle oinstall 20670 Jul 13 08:26 deinstall
-rw-r--r-- 1 oracle oinstall 382 Aug 4 18:16 readme.txt
drwxr-xr-x 7 oracle oinstall 4096 Aug 13 05:46 jre
drwxr-xr-x 2 oracle oinstall 4096 Aug 14 01:35 utl
drwxr-xr-x 2 oracle oinstall 4096 Aug 14 01:35 response
drwxr-xr-x 2 oracle oinstall 4096 Aug 14 01:35 logs
drwxr-xr-x 2 oracle oinstall 4096 Aug 14 01:50 mapfiles
drwxrwxr-x 4 oracle oinstall 4096 Aug 14 01:53 sysman
drwxrwxr-x 3 oracle oinstall 4096 Aug 14 01:53 srvm
drwxrwxr-x 8 oracle oinstall 4096 Aug 14 01:53 perl
drwxrwxr-x 7 oracle oinstall 4096 Aug 14 01:53 oui
drwxr-xr-x 3 oracle oinstall 4096 Aug 14 01:53 lib
drwxr-xr-x 2 oracle oinstall 4096 Aug 14 01:53 jlib
drwxrwxr-x 3 oracle oinstall 4096 Aug 14 01:53 diagnostics
drwxrwxr-x 2 oracle oinstall 4096 Aug 14 01:53 dc_ocm
drwxrwxr-x 3 oracle oinstall 4096 Aug 14 01:53 cv
drwxrwxr-x 3 oracle oinstall 4096 Aug 14 01:53 crs
drwxrwxr-x 2 oracle oinstall 4096 Aug 14 01:53 bin
drwxrwxr-x 4 oracle oinstall 4096 Aug 14 01:53 assistants
[oracle@oracle11gnodo1 deinstall]$ ./deinstall -home /u01/app/11.2.0/grid
ORACLE_HOME = /u01/app/11.2.0/grid
Location of logs /home/oracle/oraInventory/logs/############ ORACLE DEINSTALL & DECONFIG TOOL START ############
######################## CHECK OPERATION START ########################
Install check configuration STARTChecking for existence of the Oracle home location /u01/app/11.2.0/grid
Oracle Home type selected for de-install is: CRS
Oracle Base selected for de-install is: /u01/app/oracle
Checking for existence of central inventory location /home/oracle/oraInventory
Checking for existence of the Oracle Grid Infrastructure home /u01/app/11.2.0/grid
The following nodes are part of this cluster: oracle11gnodo1,oracle11gnodo2Install check configuration END
Traces log file: /home/oracle/oraInventory/logs//crsdc.log
- Ahora comienza la serie de preguntitas, relacionadas con las IP Virtuales, físicas y el formato de la máscara.
Enter an address or the name of the virtual IP used on node "oracle11gnodo1"[oracle11gnodo1-vip]
The following information can be collected by running ifconfig -a on node "oracle11gnodo1"
Enter the IP netmask of Virtual IP "192.168.239.131" on node "oracle11gnodo1"[255.255.255.0]
192.168.239.129Enter the network interface name on which the virtual IP address "192.168.239.131" is active
eth0Enter an address or the name of the virtual IP used on node "oracle11gnodo2"[oracle11gnodo2-vip]
The following information can be collected by running ifconfig -a on node "oracle11gnodo2"
Enter the IP netmask of Virtual IP "192.168.239.132" on node "oracle11gnodo2"[192.168.239.129]
192.168.239.130Enter the network interface name on which the virtual IP address "192.168.239.132" is active[eth0]
Enter an address or the name of the virtual IP[]
192.168.239.131The following information can be collected by running ifconfig -a on node "oracle11gnodo1"
Enter the IP netmask of the virtual IP "192.168.239.131"[]
255.255.255.0Enter the network interface name on which the virtual IP address "192.168.239.131" is active
eth0Enter an address or the name of the virtual IP[]
192.168.239.131The following information can be collected by running ifconfig -a on node "oracle11gnodo1"
Enter the IP netmask of the virtual IP "192.168.239.131"[255.255.255.0]Enter the network interface name on which the virtual IP address "192.168.239.131" is active[eth0]
Enter an address or the name of the virtual IP
- Una vez ingresados todos los datos, comienza realmente la desinstalación
Network Configuration check config START
Network de-configuration trace file location: /home/oracle/oraInventory/logs/netdc_check32554.log
Network Configuration check config END
Asm Check Configuration START
ASM de-configuration trace file location: /home/oracle/oraInventory/logs/asmcadc_check32555.log
ASM configuration was not detected in this Oracle home. Was ASM configured in this Oracle home (y|n) [n]: y
Specify the ASM Diagnostic Destination [ ]:
Specify the diskgroups that are managed by this ASM instance []: DATA1De-configuring ASM will drop all the diskgroups at cleanup time. Do you want deconfig tool to drop the diskgroups y|n [y]:
######################### CHECK OPERATION END #########################
####################### CHECK OPERATION SUMMARY #######################
Oracle Grid Infrastructure Home is: /u01/app/11.2.0/grid
The cluster node(s) on which the Oracle home exists are: (Please input nodes seperated by ",", eg: node1,node2,...)oracle11gnodo1,oracle11gnodo2
Oracle Home selected for de-install is: /u01/app/11.2.0/grid
Inventory Location where the Oracle home registered is: /home/oracle/oraInventory
ASM instance will be de-configured from this Oracle home
Do you want to continue (y - yes, n - no)? [n]: y
A log of this session will be written to: '/home/oracle/oraInventory/logs/deinstall_deconfig2009-09-21_02-57-31-PM.out'
Any error messages from this session will be written to: '/home/oracle/oraInventory/logs/deinstall_deconfig2009-09-21_02-57-31-PM.err'######################## CLEAN OPERATION START ########################
ASM de-configuration trace file location: /home/oracle/oraInventory/logs/asmcadc_clean32556.log
ASM Clean Configuration START
ASM Clean Configuration ENDNetwork Configuration clean config START
Network de-configuration trace file location: /home/oracle/oraInventory/logs/netdc_clean32557.log
De-configuring Naming Methods configuration file on all nodes...
Naming Methods configuration file de-configured successfully.De-configuring Local Net Service Names configuration file on all nodes...
Local Net Service Names configuration file de-configured successfully.De-configuring Directory Usage configuration file on all nodes...
Directory Usage configuration file de-configured successfully.De-configuring backup files on all nodes...
Backup files de-configured successfully.The network configuration has been cleaned up successfully.
Network Configuration clean config END
- Una vez pasado lo anterior, indica que debemos ejecutar ciertos comandos con root en cada uno de los nodos.
---------------------------------------->
Run the following command as the root user or the administrator on node "oracle11gnodo2".
/home/oracle/instaladores/deinstall/perl/bin/perl -I/home/oracle/instaladores/deinstall/perl/lib -I/home/oracle/instaladores/deinstall/crs/install /home/oracle/instaladores/deinstall/crs/install/rootcrs.pl -force -delete -paramfile /home/oracle/instaladores/deinstall/response/deinstall_Ora11g_gridinfrahome2.rsp
Run the following command as the root user or the administrator on node "oracle11gnodo1".
/home/oracle/instaladores/deinstall/perl/bin/perl -I/home/oracle/instaladores/deinstall/perl/lib -I/home/oracle/instaladores/deinstall/crs/install /home/oracle/instaladores/deinstall/crs/install/rootcrs.pl -force -delete -paramfile /home/oracle/instaladores/deinstall/response/deinstall_Ora11g_gridinfrahome2.rsp -lastnode
- Ejecutamos esos comandos en cada uno de los nodos del RAC con usuario root, y el desinstalador simplemente remueve y aquellos procesos que no puede eliminar, los deja para el reboteo.
[oracle@oracle11gnodo2 ~]$ su - root
Password:
[root@oracle11gnodo2 ~]# /home/oracle/instaladores/deinstall/perl/bin/perl -I/home/oracle/instaladores/deinstall/perl/lib -I/home/oracle/instaladores/deinstall/crs/install /home/oracle/instaladores/deinstall/crs/install/rootcrs.pl -force -delete -paramfile /home/oracle/instaladores/deinstall/response/deinstall_Ora11g_gridinfrahome2.rsp
2009-09-21 15:05:48: Parsing the host name
2009-09-21 15:05:48: Checking for super user privileges
2009-09-21 15:05:48: User has super user privileges
Using configuration parameter file: /home/oracle/instaladores/deinstall/response/deinstall_Ora11g_gridinfrahome2.rsp
PRCR-1035 : Failed to look up CRS resource ora.cluster_vip.type for 1
PRCR-1068 : Failed to query resources
Cannot communicate with crsd
PRCR-1070 : Failed to check if resource ora.gsd is registered
Cannot communicate with crsd
PRCR-1070 : Failed to check if resource ora.ons is registered
Cannot communicate with crsd
PRCR-1070 : Failed to check if resource ora.eons is registered
Cannot communicate with crsdADVM/ACFS is not supported on Redhat 4
ACFS-9201: Not Supported
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oracle11gnodo2'
CRS-2673: Attempting to stop 'ora.crsd' on 'oracle11gnodo2'
CRS-4548: Unable to connect to CRSD
CRS-2675: Stop of 'ora.crsd' on 'oracle11gnodo2' failed
CRS-2679: Attempting to clean 'ora.crsd' on 'oracle11gnodo2'
CRS-4548: Unable to connect to CRSD
CRS-2678: 'ora.crsd' on 'oracle11gnodo2' has experienced an unrecoverable failure
CRS-0267: Human intervention required to resume its availability.
CRS-2795: Shutdown of Oracle High Availability Services-managed resources on 'oracle11gnodo2' has failed
CRS-4687: Shutdown command has completed with error(s).
CRS-4000: Command Stop failed, or completed with errors.
You must kill crs processes or reboot the system to properly
cleanup the processes started by Oracle clusterware
error: package cvuqdisk is not installed
Successfully deconfigured Oracle clusterware stack on this node[oracle@oracle11gnodo1 ~]$ su - root
Password:
[root@oracle11gnodo1 ~]# /home/oracle/instaladores/deinstall/perl/bin/perl -I/home/oracle/instaladores/deinstall/perl/lib -I/home/oracle/instaladores/deinstall/crs/install /home/oracle/instaladores/deinstall/crs/install/rootcrs.pl -force -delete -paramfile /home/oracle/instaladores/deinstall/response/deinstall_Ora11g_gridinfrahome2.rsp -lastnode
2009-09-21 15:07:52: Parsing the host name
2009-09-21 15:07:52: Checking for super user privileges
2009-09-21 15:07:52: User has super user privileges
Using configuration parameter file: /home/oracle/instaladores/deinstall/response/deinstall_Ora11g_gridinfrahome2.rspCRS-2672: Attempting to start 'ora.cssd' on 'oracle11gnodo1'
CRS-2676: Start of 'ora.cssd' on 'oracle11gnodo1' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'oracle11gnodo1'
CRS-2676: Start of 'ora.ctssd' on 'oracle11gnodo1' succeeded
CRS-2679: Attempting to clean 'ora.asm' on 'oracle11gnodo1'
CRS-5011: Check of resource "+ASM" failed: details at "(:CLSN00006" in "/u01/app/11.2.0/grid/log/oracle11gnodo1/agent/ohasd/oraagent_oracle/oraagent_oracle.log"
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
CRS-5011: Check of resource "+ASM" failed: details at "(:CLSN00006" in "/u01/app/11.2.0/grid/log/oracle11gnodo1/agent/ohasd/oraagent_oracle/oraagent_oracle.log"
CRS-2681: Clean of 'ora.asm' on 'oracle11gnodo1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'oracle11gnodo1'
CRS-2676: Start of 'ora.asm' on 'oracle11gnodo1' succeeded
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'oracle11gnodo1'
CRS-2677: Stop of 'ora.cssdmonitor' on 'oracle11gnodo1' succeeded
CRS-2529: Unable to act on 'ora.cssd' because that would require stopping or relocating 'ora.asm', but the force option was not specified
CRS-4000: Command Stop failed, or completed with errors.
Command return code of 1 (256) from command: /u01/app/11.2.0/grid/bin/crsctl stop resource ora.cssd -init
PRCR-1068 : Failed to query resources
Cannot communicate with crsd
PRCR-1068 : Failed to query resources
Cannot communicate with crsd
PRCR-1068 : Failed to query resources
Cannot communicate with crsd
PRCR-1068 : Failed to query resources
Cannot communicate with crsd
PRCR-1035 : Failed to look up CRS resource ora.cluster_vip.type for 1
PRCR-1068 : Failed to query resources
Cannot communicate with crsd
PRCR-1070 : Failed to check if resource ora.gsd is registered
Cannot communicate with crsd
PRCR-1070 : Failed to check if resource ora.ons is registered
Cannot communicate with crsd
PRCR-1070 : Failed to check if resource ora.eons is registered
Cannot communicate with crsdADVM/ACFS is not supported on Redhat 4
ACFS-9201: Not SupportedCRS-2673: Attempting to stop 'ora.ctssd' on 'oracle11gnodo1'
CRS-2673: Attempting to stop 'ora.evmd' on 'oracle11gnodo1'
CRS-2673: Attempting to stop 'ora.asm' on 'oracle11gnodo1'
CRS-2677: Stop of 'ora.evmd' on 'oracle11gnodo1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'oracle11gnodo1' succeeded
CRS-2677: Stop of 'ora.asm' on 'oracle11gnodo1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'oracle11gnodo1'
CRS-2677: Stop of 'ora.cssd' on 'oracle11gnodo1' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on 'oracle11gnodo1'
CRS-2677: Stop of 'ora.diskmon' on 'oracle11gnodo1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'oracle11gnodo1'
CRS-2676: Start of 'ora.cssdmonitor' on 'oracle11gnodo1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'oracle11gnodo1'
CRS-2672: Attempting to start 'ora.diskmon' on 'oracle11gnodo1'
CRS-2676: Start of 'ora.diskmon' on 'oracle11gnodo1' succeeded
CRS-2676: Start of 'ora.cssd' on 'oracle11gnodo1' succeeded
This ASM diskgroup does not contain voting disks to be deleted
CRS-2672: Attempting to start 'ora.ctssd' on 'oracle11gnodo1'
CRS-2676: Start of 'ora.ctssd' on 'oracle11gnodo1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'oracle11gnodo1'
CRS-2676: Start of 'ora.asm' on 'oracle11gnodo1' succeeded
ASM de-configuration trace file location: /home/oracle/oraInventory/logs/asmcadc_clean2043844166297175867.log
ASM Clean Configuration START
ASM Clean Configuration ENDASM with SID +ASM1 deleted successfully. Check /home/oracle/oraInventory/logs/asmcadc_clean2043844166297175867.log for details.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oracle11gnodo1'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'oracle11gnodo1'
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'oracle11gnodo1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'oracle11gnodo1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'oracle11gnodo1'
CRS-2677: Stop of 'ora.cssdmonitor' on 'oracle11gnodo1' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'oracle11gnodo1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'oracle11gnodo1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'oracle11gnodo1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'oracle11gnodo1'
CRS-2677: Stop of 'ora.cssd' on 'oracle11gnodo1' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on 'oracle11gnodo1'
CRS-2673: Attempting to stop 'ora.gipcd' on 'oracle11gnodo1'
CRS-2677: Stop of 'ora.gipcd' on 'oracle11gnodo1' succeeded
CRS-2677: Stop of 'ora.diskmon' on 'oracle11gnodo1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oracle11gnodo1' has completed
CRS-4133: Oracle High Availability Services has been stopped.error: package cvuqdisk is not installed
Successfully deconfigured Oracle clusterware stack on this node
- Una vez terminado lo anterior , procedemos a dar ENTER
Press Enter after you finish running the above commands
<----------------------------------------
Oracle Universal Installer clean STARTDetach Oracle home '/u01/app/11.2.0/grid' from the central inventory on the local node : Done
Delete directory '/u01/app/11.2.0/grid' on the local node : Done
Delete directory '/u01/app/oracle' on the local node : Done
Detach Oracle home '/u01/app/11.2.0/grid' from the central inventory on the remote nodes 'oracle11gnodo2' : Done
Delete directory '/u01/app/11.2.0/grid' on the remote nodes 'oracle11gnodo2' : Done
Delete directory '/u01/app/oracle' on the remote nodes 'oracle11gnodo2' : Done
Oracle Universal Installer cleanup was successful.
Oracle Universal Installer clean END
Oracle install clean START
Clean install operation removing temporary directory '/tmp/install' on node 'oracle11gnodo1'
Clean install operation removing temporary directory '/tmp/install' on node 'oracle11gnodo2'Oracle install clean END
Moved default properties file /home/oracle/instaladores/deinstall/response/deinstall_Ora11g_gridinfrahome2.rsp as /home/oracle/instaladores/deinstall/response/deinstall_Ora11g_gridinfrahome2.rsp3
######################### CLEAN OPERATION END #########################
- Y muestra en esta sección lo más importante, el resumen ![]()
####################### CLEAN OPERATION SUMMARY #######################
ASM instance was de-configured successfully from the Oracle home
Oracle Clusterware is stopped and successfully de-configured on node "oracle11gnodo2"
Oracle Clusterware is stopped and successfully de-configured on node "oracle11gnodo1"
Oracle Clusterware is stopped and de-configured successfully.
Successfully detached Oracle home '/u01/app/11.2.0/grid' from the central inventory on the local node.
Successfully deleted directory '/u01/app/11.2.0/grid' on the local node.
Successfully deleted directory '/u01/app/oracle' on the local node.
Successfully detached Oracle home '/u01/app/11.2.0/grid' from the central inventory on the remote nodes 'oracle11gnodo2'.
Successfully deleted directory '/u01/app/11.2.0/grid' on the remote nodes 'oracle11gnodo2'.
Successfully deleted directory '/u01/app/oracle' on the remote nodes 'oracle11gnodo2'.
Oracle Universal Installer cleanup was successful.Oracle install successfully cleaned up the temporary directories.
#################################################################################### ORACLE DEINSTALL & DECONFIG TOOL END #############
La herramienta desinstala absolutamente todo, es bastante poderosa, no se cae, pero... en las pruebas efectuadas, se demora bastante.
Más información del deinstall AQUÍ
Espero les sirva
![]()
![]()
22.09.09. 14:31:06. 2537 words, 12500 views. Categories: Base de datos, Instalación, Oracle11gR2 , Leave a comment » • Send a trackback »
Oracle11gr2 : Ahora Oracle nos arregla el típico problema de semáforos (Installation Fixup Scripts)
Por fin Oracle arreglo el típico problema que se nos presentaba en versiones anteriores, en donde nos indicaba un error en los parámetros de Kernel y nosotros a manito debiamos arreglarlo..
¿Recuerdan esta imagen?
Pues bien , ahora en Oracle11gr2 POR FIN NOS AYUDAN EN ESTO!!!!
¿Cómo? , pues con el Installation Fixup Scripts
De hecho , el prechequeo cambia , y nos lo muestra de la siguiente forma
Y si nos fijamos aparece un detalle del error, si lo seleccionamos, nos explica un poco de que se trata (en realidad no es muy bueno
)
Si ejecuto "FIX&CHECK AGAIN" , se creará una shell en la ruta mencionada, el cual arregla de forma automática los semáforos con valores muy bajos, se debe ejecutar obviamente con usuario root

La shell contiene el siguiente código

Y al ejecutar la shell , lo hace todo!!

Si vemos nuevamente los prerequisitos, solamente quedarán por ejemplo , los rpm faltantes

Espero les sirva y de verdad grande Oracle!!
![]()
![]()
02.09.09. 09:35:11. 166 words, 655 views. Categories: Base de datos, Instalación, Oracle11gR2 , Leave a comment » • Send a trackback »