Just a quick note to highlight that the Oracle pre-built Developer VMs have been updated for Oracle 12c.
Oracle pre-built Developer VMs
This post is about exploring the mechanisms used by Oracle Clusterware 18.104.22.168 to restrict remote service registration, i.e. the 12c new feature "Restricting Service Registration for Oracle RAC Deployments"Why is this useful?
This improvement of 12c clusterware and listeners over the 11.2 version is useful mainly for security purposes, for example as a measure against TNS poisoning attacks (see also CVE-2012-1675
), and it is particularly relevant for (more...)
At March I will be presenting my very successful seminar “Mastering Backup and Recovery” in some countries of Latin America for the very first time. Thank you Panama, Chile and Brazil OUGs for inviting me to your amazing countries! Please, use the following links for registration and also to find more information about the seminar: […]
Hi All, On February 4, 2014 at 9:30 am PT I will be talking on the next OTN Virtual Developer Day about Oracle VM and Oracle Database. Come and discover the answers for the following questions: Does an Oracle Database perform well on a virtualized environment? What virtualization technology is more stable and […]
In Part I, we looked at some of the issues associated with locking and unusable indexes when Moving both tables and table partitions. The Oracle 12c Database has introduced a number of great new capabilities associated with online DDL activities. One of these really useful features is the capability to now move table partitions online while […]
It’s sometimes amazing, how many bugs there are still with elementary SQL.
Here is one concerning updatable views:
email@example.com > create table t ( v varchar2(30) );
firstname.lastname@example.org > create view v as
2 select v as dontdothatman, v as canbelostwheninserted
3 from t;
email@example.com > insert /* this is fine */ into v
2 values('fine', 'fine');
1 row created.
firstname.lastname@example.org > select * from v;
First post for 2014 !! Although it’s generally not an overly common activity with Oracle databases, reorganising a table can be somewhat painful, primarily because of the associated locking implications and the impact it has on indexes. If we look at the following example: So we have a table with a couple of indexes. We […]
In the Oracle technical universe, it seems that the end of the calendar year is always eventful. First there’s OpenWorld: obviously significant for official announcements and insight into Oracle’s strategy. It’s also the week when many top engineers around the world meet up in San Francisco to catch up over (more...)
Oracle has released the much-anticipated version of cellsrv compatible with Oracle Database 22.214.171.124 (patch #16980054). Before thinking about upgrading, read MOS note #1571789.1 carefully. Unless you are planning to run database 12c on your Exadata, it would be advisable to continue down the 11.2 branch (more...)
In a multitenant database environment, PDBs are plugged into a CDB container sharing single SGA. All the PDB objects are loaded into a single SGA component and there are no ISPDB_MODIFIABLE SGA parameters. Looking at the V$LATCH_CHILDREN, all the CBC latches defined under CON_ID 1 which is CDB$ROOT.
What did I mean? Actually, I thought how to rename "ADMIN" user?or How to rename "Email Address" on Multitenant Self-Service Provisioning? Why I interested in it?
I created New Database by using "ADMIN" user.
I didn't get email about credentials (Because no email address for ADMIN user
I didn't write about setting SQL Developer to connect PDB. I just tested connection by using SQL Developer with pdb_admin. As you know - The PDB_ADMIN user in newly created PDBs has SYSDBA system privilege so it can fully manage the PDB.
SQL> conn / as sysdba
SQL> alter (more...)
Last post, I posted about Oracle Multitenant Self-Service Provisioning - BETA 2
and read more about what changes have been made in this Beta 2 release.
Users with the PDBA role in the Oracle Multitenant Self-Service Provisioning application can only view PDBs that they created or have been made an (more...)
Got news on tweeter about Multitenant Self-Service Provisioning - BETA 2
. It's very interesting. You will find something change. For example On Oracle Multitenant Self Service Provisioning - BETA 1 runs in APEX pdb
(Downloaded pdbss_1030.zip and installed)This version, the Oracle Multitenant Self-Service Provisioning application now runs in (more...)
Removing a service via srvctl has not historically resulted in the service being fully removed from the database and it would still be visible in DBA_SERVICES as show below in an 126.96.36.199 database:
Create the service:
$ srvctl add service -d orcl -s demo -r "ORCL1,ORCL2"
This is the third and final post on follow up questions from the Redgate webinar I did on 12c Adaptive Optimization (the link goes to a recording of the webcast by the way).
Also, here are links to the 2 earlier posts:
12c Adaptive Optimization – Part 1.
12c Adaptive (more...)
This is the second post on follow up questions from the Redgate webinar I did on 12c Adaptive Optimization. The first post is here: 12c Adaptive Optimization – Part 1. Since there were several comments and questions about hints and how they interact with Adaptive Plans, I decided to limit (more...)
If you are working with JDeveloper 12c (12.1.2), you will probably have experienced quite a few crashes – I had several during my the live demos in my presentations at the UKOUG Tech 2013 conference in Manchester this week.
A few things that help:
- Increase memory (google “JDeveloper (more...)
Since PL/SQL now is closely integrated into SQL, we hence can happily state
email@example.com > with function bestpractice return varchar2
4 return 'Do not use PL/SQL when it can be done with SQL alone !';
5 end bestpractice;