When you create Multitenant databases with DBCA there are some Things to Know. And in Oracle Database 18.104.22.168’s Database Creation Assistant (DBCA) there is a common pitfall in the “Options” screen. It was grayed out in the previous release but when you choose to create a “custom” database you can select the options/components now.… [Read More]
There’s a new and improved version of the preupgrade.jar (build 5 – May 2017) available for download from MyOracle Support:
The same note will get you access also to the most recent builds of preupgrd.sql for upgrades to Oracle Database 12.1 and utlu112i.sql for the unlikely event you’ll have to upgrade a database to Oracle 22.214.171.124.… [Read More]
I did blog in the past already about the Grid Infrastructure Management Repository Database (GIMR DB):
SID and DBNAME are kept the same in Oracle Database 12.2. But there are a few changes and additions in Oracle Database 126.96.36.199.
GIMR DB in its own Disk Group
During a fresh installation of Oracle Grid Infrastructure 188.8.131.52 you’ll have the chance to create a disk group for GIMR DB:
But you can migrate GIMR DB into a separate disk group as well – just make sure the size is large enough (see below).… [Read More]
I did blog a day ago about
ORA-1017 connection issues in Oracle Database 12.2 once you would like to use the deprecated init.ora/spfile parameter
But how can this change actually happen?
Let’s check how the
PASSWORD_VERSIONS is set in a fresh Oracle Database 184.108.40.206 database with the January 2017 Proactive Bundle Patch applied to it:
SQL> select username, password_versions from dba_users order by 1; USERNAME PASSWORD_VERSIONS ------------------------------ ----------------- ANONYMOUS APPQOSSYS 10G 11G 12C AUDSYS 10G 11G 12C DBSNMP 10G 11G 12C DIP 10G 11G 12C GSMADMIN_INTERNAL 10G 11G 12C GSMCATUSER 10G 11G 12C GSMUSER 10G 11G 12C ORACLE_OCM 10G 11G 12C OUTLN 10G 11G 12C SYS 10G 11G 12C SYSBACKUP 10G 11G 12C SYSDG 10G 11G 12C SYSKM 10G 11G 12C SYSTEM 10G 11G 12C WMSYS 10G 11G 12C XDB 10G 11G 12C XS$NULL 18 rows selected.… [Read More]
Oracle Database 12c Release 2 on-premises for IBM AIX and HP-UX is availaibe now for download from OTN and eDelivery:
- Oracle Tech Network (OTN)
HP-UX Itanium (x86 systems, 64-bit) File 1 (3.7 GB) See All AIX (x86 systems, 64-bit) File 1 (3.1 GB) See All
- Oracle Software Cloud (eDelivery)
Oracle Database 220.127.116.11 for MS Windows is available as of today for download.
Download it from:
The 64bit and 32bit clients are downloadable as well – click on the “See All” link and scroll down a bit on OTN.
The Oracle Lifetime Support Policy brochure for tech products has been updated now as well in order to reflect the addition and availability of Oracle Database 12.2 on-premises:
Please note that this table and the brochure never makes a distinction between patch sets and base releases.… [Read More]