/u01/app/oracle/oraInventory/logs/installActions2013-05-07_06-00-52PM.logPrepare in progress................................................... 9% Done.Prepare successful.Copy files in progress................................................... 14% Done................................................... 20% Done................................................... 26% Done................................................... 31% Done................................................... 36% Done................................................... 44% Done................................................... 49% Done................................................... 55% Done................................................... 63% Done................................................... 68% Done................................................... 73% Done................................................... 78% Done................................................... 83% Done...............................Copy files successful.Link binaries in progress...........Link binaries successful.Setup files in progress................................................... 88% Done................................................... 94% Done.Setup files successful.The installation of Oracle Database 11g was successful.Please check '/u01/app/oracle/oraInventory/logs/silentInstall2013-05-07_06-00-52PM.log' for more details.Execute Root Scripts in progress.As a root user, execute the following script(s): 1. /u01/app/oracle/product/11.2.0.3/root.sh.................................................. 100% Done.Execute Root Scripts successful.--com root[root@oradsv01 11.2.0.3]# ./root.shCheck /u01/app/oracle/product/11.2.0.3/install/root_oradsv01_2013-05-07_18-49-51.log for the output of root script[root@oradsv01 11.2.0.3]# cat /u01/app/oracle/product/11.2.0.3/install/root_oradsv01_2013-05-07_18-49-51.logPerforming root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0.3Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Finished product-specific root actions.[root@oradsv01 11.2.0.3]# pwd/u01/app/oracle/product/11.2.0.3[root@oradsv01 11.2.0.3]# dateTue May 7 18:50:30 BRT 2013[root@oradsv01 11.2.0.3]#--com o user oracleSuccessfully Setup Software.3 - Escolher o metodo que sera feito o upgrade, aqui sera feito manualmente--backup do banco - nao rodei backup para a base de devRUN{ ALLOCATE CHANNEL chan_name TYPE DISK; BACKUP DATABASE FORMAT '/dados/some_backup_directory%U' TAG before_upgrade; BACKUP CURRENT CONTROLFILE FORMAT '/dados/control_file';}4 - Executando o upgrade da basecriar um pfile from spfileshutdown no bancocopiar o init e listener.ora(nao havia listener.ora na maquina oradsv01, foi copiado tb o tnsnames.ora) para o novo homeir para o diretoriocd $ORACLE_HOME/rdbms/adminconectar com o sysdbastartup upgradeSPOOL upgrade.log@catupgrd.sql--o script da shutdown no bancostartup@utlu112s.sql --checar se houve algum erro no spo do script @utlu112s.sql@catuppst.sql --checar se houve algum erro no spo do script @catuppst.sql--recompilar objetos@utlrp.sql--validar objetos invalidosSELECT count(*) FROM dba_invalid_objects;SELECT distinct object_name FROM dba_invalid_objects where owner in('SYS','SYSTEM') AND STATUS='INVALID';--opatchAtualizar o OPatch com a versao mais recente, realizar um backup da pasta $ORACLE_HOME/OPatch, depois apagar o conteudo e decompactar o arquivo p6880880_112000_Linux-x86-64.zip no $ORACLE_HOME--instalando o bundle patchDecompactar o arquivo p16056266_112030_Linux-x86-64.zip na pasta $ORACLE_HOME/OPatchcd $ORACLE_HOME/OPatch/16056266--se for um single instance, precisa baixar o banco e listener, para rac e possivel fazer sem gerar indisponibilidade[oracle@oradsv01:oradsvme 16056266]$/u01/app/oracle/product/11.2.0.3/OPatch/opatch applyOracle Interim Patch Installer version 11.2.0.3.4Password (optional): --Ignorar mensagens de tentativa de conexao com o metalink, preencha com NONE onde for solicitadoIs the local system ready for patching? [y|n]yUser Responded with: YBacking up files...Applying sub-patch '13343438' to OH '/u01/app/oracle/product/11.2.0.3'Patching component oracle.rdbms.rsf, 11.2.0.3.0...Patching component oracle.rdbms, 11.2.0.3.0...Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...Verifying the update...Applying sub-patch '13696216' to OH '/u01/app/oracle/product/11.2.0.3'Patching component oracle.rdbms.rsf, 11.2.0.3.0...Patching component oracle.rdbms, 11.2.0.3.0...Patching component oracle.sdo.locator, 11.2.0.3.0...Patching component oracle.sysman.console.db, 11.2.0.3.0...Patching component oracle.sysman.oms.core, 10.2.0.4.4...Verifying the update...Applying sub-patch '13923374' to OH '/u01/app/oracle/product/11.2.0.3'ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.Patching component oracle.rdbms.rsf, 11.2.0.3.0...Patching component oracle.rdbms, 11.2.0.3.0...Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...Patching component oracle.network.rsf, 11.2.0.3.0...Patching component oracle.network.listener, 11.2.0.3.0...Patching component oracle.sysman.console.db, 11.2.0.3.0...Verifying the update...Applying sub-patch '14275605' to OH '/u01/app/oracle/product/11.2.0.3'ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.Patching component oracle.network.client, 11.2.0.3.0...Patching component oracle.network.rsf, 11.2.0.3.0...Patching component oracle.precomp.common, 11.2.0.3.0...Patching component oracle.rdbms, 11.2.0.3.0...Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...Patching component oracle.rdbms.rman, 11.2.0.3.0...Patching component oracle.rdbms.rsf, 11.2.0.3.0...Patching component oracle.rdbms.util, 11.2.0.3.0...Verifying the update...Applying sub-patch '14727310' to OH '/u01/app/oracle/product/11.2.0.3'Patching component oracle.rdbms, 11.2.0.3.0...Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...Patching component oracle.rdbms.rsf, 11.2.0.3.0...Patching component oracle.sdo.locator, 11.2.0.3.0...Patching component