Posts

Showing posts from February, 2014

Oracle Database 12c: What happens during CDB startup if one the PDB has a media problem? - Continue

During Oracle Day 2014  (February 05, 2014, which was held in Baku/Azerbaijan), I met with my friends and had a conversation about several topics.

I asked to my friend Teymur Hajiyev, what happens during CDB startup if one the PDB has a media problem? He said, CDB must open without a problem. But you need to open PDBs manually. In other words, by default PDBs in mount mode, you need call alter pluggable databases all open.

After Oracle Day, Teymur shared his tests in here. and faced the same issue. But he is wrote : If you apply PSU1 on 12c, you will not meet with such problem, CDB will skip opening problematic PDB and will open other PDBs.

I will share my tests on patched database. I applied PSU1 to my database server:  Installation and configuration Patch 17552800 - 12.1.0.1.2 Patch Set Update

My test environment as below:

[oracle@oel62-ora12c /]$ export ORACLE_SID=prmcdb [oracle@oel62-ora12c /]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Wed Feb 12 12:53:16 201…

Installation and configuration Patch 17552800 - 12.1.0.1.2 Patch Set Update

Image
Hi,

Patch 17552800 - 12.1.0.1.2 Database Patch Set Update released: January 14, 2014. You can download this PSU  from Oracle My Support. I will show short steps installation and configuration this PSU.

Note:To install the PSU 12.1.0.1.2 patch, the Oracle home must have the 12.1.0.1.0 Database installed. Subsequent PSU patches can be installed on Oracle Database 12.1.0.1.0 or any PSU with a lower 5th numeral version than the one being installed.

1. Download this patch set zip file from support web site and copy to database server.


[oracle@oel62-ora12c PSU1]$ pwd /tmp/oracle/PSU1 [oracle@oel62-ora12c PSU1]$ ls -l total 67952 -rw-r--r-- 1 oracle oinstall 69580299 Feb 12 09:17 p17552800_121010_Linux-x86-64.zip [oracle@oel62-ora12c PSU1]$
2. Exract patch files from p17552800_121010_Linux-x86-64.zip file.

[oracle@oel62-ora12c PSU1]$ unzip p17552800_121010_Linux-x86-64.zip Archive:  p17552800_121010_Linux-x86-64.zip    creating: 17552800/   inflating: 17552800/README.html      creating: 175…

Oracle ACE Newsletter January 2014

Image
I saw my name in Oracle ACE Newsletter January 2014.




















It is first time, is my name in Oracle ACE Newsletter. I'm very glad.
Thanks to Oracle Technology Network (OTN).

Regards
Mahir M. Quluzade