Buenas! 🙂
Com o Oracle 12c batendo a porta resolvi postar um vídeo que já me havia sido solicitado, e aproveitar para demonstrar como realizar upgrade em duas situações:
– 10.2.0.1 para 10.2.0.5 (Continuando na mesma versão.)
– 10.2.0.5 para 11.2.0.1 (Alterando a versão.)
Segue abaixo o roteiro utilizado nos vídeos:
Série de posts upgrade Oracle # Software utilizado: VirtualBox: http://goo.gl/gJXfi Oracle VM VirtualBox Extension Pack http://goo.gl/ZgCca Oracle Linux Release 5 Update 8 for x86_64 (64 Bit) http://goo.gl/PWKvW Oracle 10gR2 (10.2.0.1 e 10.2.0.5) - *** Disponível apenas por meio de chamado no metalink http://goo.gl/sBFce Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86-64 http://goo.gl/zvG7w 1) Virtual Box: Criação e configuração da VM - Oracle 64-bit - RAM 1024 - Disco 80G - Config - Geral - Avançado: - Área de Transferência Compartilhada: Bi-direcional - Arrastar e soltar: Bi-direcional - Config - Sistema - Placa-mãe: - Desmarcar disquete - Config - Sistema - Processador: - Limitar em 80% - Config - Armazenamento: - Selecionar a ISO do OEL 5.8 64bit - Config - Rede - Adaptador 1 - Configurar como bridge - Config - Pastas Compartilhadas - Compartilhar a pasta Meus Documentos - Marcar Montar Automaticamente ## Instalação da VM Pacotes a serem selecionados: Desktop Environments: GNOME Desktop Environment Applications: Editors Applications: Graphical Internet Applications: Text-based Internet Development: Development Libraries Development: Development Tools Development: Legacy Software Development Server: Server Configuration Tools Base System: Administration Tools Base System: Base Base System: Legacy Software Support Base System: System Tools Base System: X Window System
[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”LSBEZXNhYmlsaXRhciBvIGZpcmV3YWxsCgotIEluc3RhbGFyIGFkaWNpb25haXMgcGFyYSBjb252aWRhZG9zCgotIEluc3RhbGFyIG8gc2VndWludGUgcGFjb3RlOgoKY2QgL21lZGlhL09MNS44IHg4Nl82NCBkdmQgMjAxMjAyMjkvU2VydmVyLwpycG0gLVV2aCBsaWJYcC0xKgoKLSBFZGl0YXIgL2V0Yy9ob3N0cwoxMjcuMC4wLjEgICAgICBsb2NhbGhvc3QgbG9jYWxob3N0LmxvY2FsZG9tYWluCjE5Mi4xNjguMS4xODAgIGNlcnRpZmJkLmxvY2FsZG9tYWluIGNlcnRpZmJkCgotIEVkaXRhciAvZXRjL3N5c2N0bC5jb25mCmtlcm5lbC5zaG1tbmkgPSA0MDk2CiMgc2VtYXBob3Jlczogc2VtbXNsLCBzZW1tbnMsIHNlbW9wbSwgc2VtbW5pCmtlcm5lbC5zZW0gPSAyNTAgMzIwMDAgMTAwIDEyOApuZXQuaXB2NC5pcF9sb2NhbF9wb3J0X3JhbmdlID0gMTAyNCA2NTAwMApuZXQuY29yZS5ybWVtX2RlZmF1bHQ9MjYyMTQ0Cm5ldC5jb3JlLnJtZW1fbWF4PTI2MjE0NApuZXQuY29yZS53bWVtX2RlZmF1bHQ9MjYyMTQ0Cm5ldC5jb3JlLndtZW1fbWF4PTI2MjE0NAoKLSBFeGVjdXRhciBzeXNjdGwgLXAKCi0gRWRpdGFyIC9ldGMvc2VjdXJpdHkvbGltaXRzLmNvbmYKKiAgICAgICAgIHNvZnQgICAgbnByb2MgICAgICAyMDQ3CiogICAgICAgICBoYXJkICAgIG5wcm9jICAgICAgMTYzODQKKiAgICAgICAgIHNvZnQgICAgbm9maWxlICAgICAxMDI0CiogICAgICAgICBoYXJkICAgIG5vZmlsZSAgICAgNjU1MzYKb3JhY2xlICAgIHNvZnQgICAgbWVtbG9jayAgICB1bmxpbWl0ZWQKb3JhY2xlICAgIGhhcmQgICAgbWVtbG9jayAgICB1bmxpbWl0ZWQKCi0gRWRpdGFyIC9ldGMvcGFtLmQvbG9naW4Kc2Vzc2lvbiAgICByZXF1aXJlZCAgICAgcGFtX2xpbWl0cy5zbwoKLSBDcmlhw6fDo28gZG8gdXNlciBvcmFjbGU6Cmdyb3VwYWRkIG9pbnN0YWxsCmdyb3VwYWRkIGRiYQpncm91cGFkZCBvcGVyCnVzZXJhZGQgLWcgb2luc3RhbGwgLUcgZGJhIG9yYWNsZQpwYXNzd2Qgb3JhY2xlCgotIENyaWHDp8OjbyBkb3MgZGlyZXTDs3Jpb3M6Cm1rZGlyIC1wIC91MDEvYXBwL29yYWNsZS9wcm9kdWN0LzEwLjIuMC9kYl8xCmNob3duIC1SIG9yYWNsZS5vaW5zdGFsbCAvdTAxCgotIEV4ZWN1dGFyIGNvbW8gcm9vdDoKeGhvc3QgKwoKLSBFZGl0YXIgbyAvZXRjL3JlZGhhdC1yZWxlYXNlCnJlZGhhdC00CgotIEVkaXRhciBvIC5iYXNocmMKIyBPcmFjbGUgU2V0dGluZ3MKVE1QPS90bXA7IGV4cG9ydCBUTVAKVE1QRElSPSRUTVA7IGV4cG9ydCBUTVBESVIKCk9SQUNMRV9CQVNFPS91MDEvYXBwL29yYWNsZTsgZXhwb3J0IE9SQUNMRV9CQVNFCk9SQUNMRV9IT01FPSRPUkFDTEVfQkFTRS9wcm9kdWN0LzEwLjIuMC9kYl8xOyBleHBvcnQgT1JBQ0xFX0hPTUUKT1JBQ0xFX1NJRD1DRVJUSUZCRDsgZXhwb3J0IE9SQUNMRV9TSUQKT1JBQ0xFX1RFUk09eHRlcm07IGV4cG9ydCBPUkFDTEVfVEVSTQpQQVRIPS91c3Ivc2JpbjokUEFUSDsgZXhwb3J0IFBBVEgKUEFUSD0kT1JBQ0xFX0hPTUUvYmluOiRQQVRIOyBleHBvcnQgUEFUSApFRElUT1I9dmk7IGV4cG9ydCBFRElUT1IKCkxEX0xJQlJBUllfUEFUSD0kT1JBQ0xFX0hPTUUvbGliOi9saWI6L3Vzci9saWI7IGV4cG9ydCBMRF9MSUJSQVJZX1BBVEgKQ0xBU1NQQVRIPSRPUkFDTEVfSE9NRS9KUkU6JE9SQUNMRV9IT01FL2psaWI6JE9SQUNMRV9IT01FL3JkYm1zL2psaWI7IGV4cG9ydCBDTEFTU1BBVEgKCmlmIFsgJFVTRVIgPSAib3JhY2xlIiBdOyB0aGVuCiAgaWYgWyAkU0hFTEwgPSAiL2Jpbi9rc2giIF07IHRoZW4KICAgIHVsaW1pdCAtcCAxNjM4NAogICAgdWxpbWl0IC1uIDY1NTM2CiAgZWxzZQogICAgdWxpbWl0IC11IDE2Mzg0IC1uIDY1NTM2CiAgZmkKZmk=” hover_enabled=”0″]LSBEZXNhYmlsaXRhciBvIGZpcmV3YWxsCgotIEluc3RhbGFyIGFkaWNpb25haXMgcGFyYSBjb252aWRhZG9zCgotIEluc3RhbGFyIG8gc2VndWludGUgcGFjb3RlOgoKY2QgL21lZGlhL09MNS44IHg4Nl82NCBkdmQgMjAxMjAyMjkvU2VydmVyLwpycG0gLVV2aCBsaWJYcC0xKgoKLSBFZGl0YXIgL2V0Yy9ob3N0cwoxMjcuMC4wLjEgICAgICBsb2NhbGhvc3QgbG9jYWxob3N0LmxvY2FsZG9tYWluCjE5Mi4xNjguMS4xODAgIGNlcnRpZmJkLmxvY2FsZG9tYWluIGNlcnRpZmJkCgotIEVkaXRhciAvZXRjL3N5c2N0bC5jb25mCmtlcm5lbC5zaG1tbmkgPSA0MDk2CiMgc2VtYXBob3Jlczogc2VtbXNsLCBzZW1tbnMsIHNlbW9wbSwgc2VtbW5pCmtlcm5lbC5zZW0gPSAyNTAgMzIwMDAgMTAwIDEyOApuZXQuaXB2NC5pcF9sb2NhbF9wb3J0X3JhbmdlID0gMTAyNCA2NTAwMApuZXQuY29yZS5ybWVtX2RlZmF1bHQ9MjYyMTQ0Cm5ldC5jb3JlLnJtZW1fbWF4PTI2MjE0NApuZXQuY29yZS53bWVtX2RlZmF1bHQ9MjYyMTQ0Cm5ldC5jb3JlLndtZW1fbWF4PTI2MjE0NAoKLSBFeGVjdXRhciBzeXNjdGwgLXAKCi0gRWRpdGFyIC9ldGMvc2VjdXJpdHkvbGltaXRzLmNvbmYKKiAgICAgICAgIHNvZnQgICAgbnByb2MgICAgICAyMDQ3CiogICAgICAgICBoYXJkICAgIG5wcm9jICAgICAgMTYzODQKKiAgICAgICAgIHNvZnQgICAgbm9maWxlICAgICAxMDI0CiogICAgICAgICBoYXJkICAgIG5vZmlsZSAgICAgNjU1MzYKb3JhY2xlICAgIHNvZnQgICAgbWVtbG9jayAgICB1bmxpbWl0ZWQKb3JhY2xlICAgIGhhcmQgICAgbWVtbG9jayAgICB1bmxpbWl0ZWQKCi0gRWRpdGFyIC9ldGMvcGFtLmQvbG9naW4Kc2Vzc2lvbiAgICByZXF1aXJlZCAgICAgcGFtX2xpbWl0cy5zbwoKLSBDcmlhw6fDo28gZG8gdXNlciBvcmFjbGU6Cmdyb3VwYWRkIG9pbnN0YWxsCmdyb3VwYWRkIGRiYQpncm91cGFkZCBvcGVyCnVzZXJhZGQgLWcgb2luc3RhbGwgLUcgZGJhIG9yYWNsZQpwYXNzd2Qgb3JhY2xlCgotIENyaWHDp8OjbyBkb3MgZGlyZXTDs3Jpb3M6Cm1rZGlyIC1wIC91MDEvYXBwL29yYWNsZS9wcm9kdWN0LzEwLjIuMC9kYl8xCmNob3duIC1SIG9yYWNsZS5vaW5zdGFsbCAvdTAxCgotIEV4ZWN1dGFyIGNvbW8gcm9vdDoKeGhvc3QgKwoKLSBFZGl0YXIgbyAvZXRjL3JlZGhhdC1yZWxlYXNlCnJlZGhhdC00CgotIEVkaXRhciBvIC5iYXNocmMKIyBPcmFjbGUgU2V0dGluZ3MKVE1QPS90bXA7IGV4cG9ydCBUTVAKVE1QRElSPSRUTVA7IGV4cG9ydCBUTVBESVIKCk9SQUNMRV9CQVNFPS91MDEvYXBwL29yYWNsZTsgZXhwb3J0IE9SQUNMRV9CQVNFCk9SQUNMRV9IT01FPSRPUkFDTEVfQkFTRS9wcm9kdWN0LzEwLjIuMC9kYl8xOyBleHBvcnQgT1JBQ0xFX0hPTUUKT1JBQ0xFX1NJRD1DRVJUSUZCRDsgZXhwb3J0IE9SQUNMRV9TSUQKT1JBQ0xFX1RFUk09eHRlcm07IGV4cG9ydCBPUkFDTEVfVEVSTQpQQVRIPS91c3Ivc2JpbjokUEFUSDsgZXhwb3J0IFBBVEgKUEFUSD0kT1JBQ0xFX0hPTUUvYmluOiRQQVRIOyBleHBvcnQgUEFUSApFRElUT1I9dmk7IGV4cG9ydCBFRElUT1IKCkxEX0xJQlJBUllfUEFUSD0kT1JBQ0xFX0hPTUUvbGliOi9saWI6L3Vzci9saWI7IGV4cG9ydCBMRF9MSUJSQVJZX1BBVEgKQ0xBU1NQQVRIPSRPUkFDTEVfSE9NRS9KUkU6JE9SQUNMRV9IT01FL2psaWI6JE9SQUNMRV9IT01FL3JkYm1zL2psaWI7IGV4cG9ydCBDTEFTU1BBVEgKCmlmIFsgJFVTRVIgPSAib3JhY2xlIiBdOyB0aGVuCiAgaWYgWyAkU0hFTEwgPSAiL2Jpbi9rc2giIF07IHRoZW4KICAgIHVsaW1pdCAtcCAxNjM4NAogICAgdWxpbWl0IC1uIDY1NTM2CiAgZWxzZQogICAgdWxpbWl0IC11IDE2Mzg0IC1uIDY1NTM2CiAgZmkKZmk=[/et_pb_dmb_code_snippet]
Como de ‘praxe’, segue recomendação de trilha sonora para acompanhar a instalação! m/
Show de bola Vitor..Parabéns mano!
Sempre com ótimos posts
Valeu Emerson! Em breve daremos continuidade aos posts de upgrade! 🙂
Excelente Vitinho, parabéns cara!
Sabe muito esse life-letti! Continua acompanhando, to pensando num post sobre standby, que tu acha? Te habilita a escrever? rsrsrsrs
Abração! 😀
Grandeeee…! Standby dá trabalho! Mas no final, com muita paciência sempre bomba! hehe
Abraços!
Boa tarde Victor !
A configuração no Virtual Box para o Oracle 11g é a mesma que segue nos passos acima?
Olá Carlos. Só corrigindo, é Vitor, sem o C, ok? 🙂
Verifique na área DBArea, em Instalação/Configuração, fiz vários vídeos de instalação do 11GR2. Segue o link para a última parte:
http://certificacaobd.com.br/2012/08/12/oracle-instalacao-instalacao-11gr2-no-grid/