Oracle 12c forms is released now. Please find the download link here
ORA-65040: operation not allowed from within a pluggable database
This error could occur if a tablespace is being dropped from within PDB and this tablespace is a former default tablespace having some of the system objects. Even system objects cannot be moved with simple alter statements from within PDBs.
So in order to move these objects from within (more...)
It is well-known that AWR, and Statspack before, take snapshots of V$ views (or rather the underlying objects) to produce the data in AWR.
It is also well-known that, when considering sql and its statistics in the shared pool, if something big hitting happens but the big-hitter is no longer in the shared pool by the time of the snapshot, then it can’t be recorded in your AWR picture of activity.
But like many things (more...)
Here’s a query which I find useful in order to have a very quick comparison across AWR snapshots of the high level time model statistics.
The numbers should match those in the associated section in the AWR report.
If you feel compulsed, obsessively, with tuning then you may see some blips here and there which then encourage you to dive into the AWR detail for that snapshot.
Or quite often I get in in the (more...)
Unfortunately it has some drawbacks as well.
One of those I hit recently when running datapatch on 2 instances which uses the same ORACLE_HOME.
At some time in it's progress (more...)
Oracle 12c introduced feature to move table partitions and sub-partitions as online operations.So, this blog is related to this feature and the issue I faced.
The database was upgraded from 184.108.40.206 to 220.127.116.11 and this issue is seen in upgraded databases only.
SQL> create table sales_part (product char(25),channel_id number,cust_id number, amount_sold number, time_id date) partition by range (time_id) ( partition sale_jan values less than (to_date('01-02-2015','dd-mm-yyyy')), partition (more...)
Prior to 18.104.22.168 version, whenever container database was restarted,the pluggable databases within the container database remained in MOUNT state. Startup trigger were written to open the database in READ-WRITE/READ-ONLY mode.Starting from 22.214.171.124, this can be done with PDB save state feature
SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ----------------- ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ALPDB READ WRITE NO
Lets create a new PDB
ORDIM – The Oracle Multimedia component might be in INVALID state after the database upgrade to 12c. While I was testing the upgrade on test server, received below errors after the catctl.pl completion.
Serial Phase #:69 Files: 1 Use of uninitialized value $gsRTInclusion in concatenation (.) or string at catctl.pl line 1500. Time: 49s ------------------------------------------------------ Phases [0-73] End Time:[2015_08_08 08:06:45] ------------------------------------------------------ Grand Total Time: 4848s *** WARNING: ERRORS FOUND DURING UPGRADE *** (more...)
If you do not change your running mode, the flow trace window will look like this:
We will switch the Audit Level of your local SOA domain to Development (more...)
After the Oracle Restart (Grid Infrastructure) upgrade from 11.2. to 126.96.36.199 , you might encounter the below lines in the ASM alert log file
Tue Jun 23 01:16:01 2015 WARNING: unknown state for ASM password file location resource, Return Value: 3 WARNING: unknown state for ASM password file location resource, Return Value: 3
After the upgrade, below command can get the error
[grid@oracle1 ~]$ srvctl config asm ASM home: <crs home=''> (more...)
When you do both ADF & SOA development, this can be annoying when you just want to run your ADF application and the IntegratedWLS is busy starting up the SOA domain. One way to (more...)
Customers have been waiting for a Standard Edition release for version 188.8.131.52. Then, in July, a support engineer leaked that there will be a whole new type of “Edition”, called “Standard Edition 2″ to replace both “Standard Edition” and “Standard Edition One”. The respective MOS Note disappeared shortly after the accidental publication. Now today the release finally became official and can be downloaded via OTN. The “SE2″ is priced exactly as the (more...)
This post is for some of you who are planning to upgrade to 12c.I worked on upgrading single instance database from 184.108.40.206.13 to 220.127.116.11.3, so thought to share my experience.
From 12c catupgrade.sql has been deprecated and Oracle has introduced catctl.pl script for upgrade. With catctl.pl script Oracle tries to perform as much work as possible in parallel, therefore minimizing downtime for upgrade.
My thoughts on SQL plan management decision points:
SQL Patches are also available and not covered in the above flowchart.
Most examples I've seen have used the default AFTER MATCH SKIP PAST LAST ROW as most often the logic dictates, that when we have found a match in a group of rows, we want to search for further matches after those rows to avoid unwanted "double" matches.
But can there be uses where we want (more...)
Today my presentation is confirmed: “Bob the Builder: Build/Deploy of ADF enterprise applications”.
I will speak over our experiences with following
- build tools
- deployment tools
- versioning & branching
- continuous integration
- hot deployment in development
- compile & runtime dependencies
If you speak german and you are interested in some of this, you should come and attend DOAG 2015.
Filed under: Deploying, Development Tagged: 11g, 12c, ADF, ADF Architecture, Branching, (more...)
You need to clear some directories in your JDevHome before the application deployment works again. Before clearing the directories, make sure you close JDeveloper.
Go to the folder: (more...)
This post is just a compilation of the links to other people’s articles and short descriptions about new SQL PLAN OPERATIONS and HINTS with a couple little additions from me.