1.8 Details of Support for Objects and Operations in Oracle DDL
The following tables are excluded by default.
"*.AQ$*", // advanced queues
"*.DR$*$*", // oracle text
"*.M*_*$$", // Spatial index
"*.MLOG$*", // materialized views
"*.OGG$*", // AQ OGG queue table
"*.ET$*", // Data Pump external tables
"*.RUPD$*", // materialized views
"*.SYS_C*", // constraints
"*.MDR*_*$", // Spatial Sequence and Table
I was faced with a very strange situation.
When using SETENV (ORACLE_SID = db01), replicat ABEND with OGG-00664 OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available
When using SETENV (ORACLE_HOME=/u01/app/oracle/product/188.8.131.52/dbhome_1), replicat starts without any issues.
I know what you are thinking, why not set both ORACLE_SID and ORACLE_HOME and you are correct since this is best practices.
The client already knows this and wanted to troubleshoot why it was failing?
Any ideas? (more...)
Truthfully, I am feeling a little lazy to write a nice blog.
Configuring listener.ora and tnsnames.ora, varying names for database, connecting to database.
db_name string tmnt
db_unique_name string tmnt_a
instance_name string tmnt01
ADR Home /u01/app/oracle/diag/rdbms/tmnt_a/tmnt
Service "april" has 1 instance(s).
Instance "tmnt01", status READY, has 1 handler(s) for this service...
Service "tmnt" has 1 instance(s).
Instance "tmnt", status UNKNOWN, has 1 handler(s) for this service...
Service "tmnt_a" has 1 instance(s).
I’ve been using standby databases, on and off, since Oracle 8i. I first wrote about Data Guard for Oracle 9i. I’ve had an article on 11gR2 Data Guard for ages, but up until recently I’ve always used the manual setup.
We’ve got a project coming up that *may* use Data Guard and *may* be installed by a 3rd party, so I figured I better get up to speed with the Data Guard Broker, in case they (more...)
Since the release of OBIEE 12c in 2015, we have received countless inquiries about how we would be offering our training. Our customers are familiar with our ability to provide on-site private training for a team and we are well known for hosting training classes in our offices in the UK and the US. But what most people aren’t aware of is that we now offer OBI remote training.
Our public training schedule offers a (more...)
Just a quick note as I play with CDB/PDB.
No more triggers!
PDB State Management Across CDB
select con_name, instance_name, state from DBA_PDB_SAVED_STATES;
alter pluggable database PDB1 SAVE STATE;
alter pluggable database ALL SAVE STATE;
alter pluggable database ALL DISCARD STATE;
alter pluggable database ALL OPEN;
startup force mount exclusive restrict;
Drop database still does not clean up ADR.
SQL*Plus: Release 184.108.40.206.0 Production (more...)
How do you typically create database, using dbca or sqlplus?
I am still surprised with all the bloatware added for creating database using dbca.
Also, is there a reason to prefix PDB with pdb?
-rw-r--r--. 1 oracle oinstall 801 Jul 19 12:59 cr_cdb.sql
-rw-rw----. 1 oracle oinstall 1544 Jul 19 13:06 hc_tmnt.dat
-rw-r--r--. 1 oracle oinstall 216 Jul 19 12:48 inittmnt.ora
-rw-r-----. 1 oracle (more...)
I received an email recently that demonstrated something the author considered strange when the init.ora parameter optimizer_feature_enable (OFE) is set in a database session. I thought I'd mention it here because the behavior he spotted is expected, but I don't think that it is entirely obvious.
Let's assume that... [Read More
Recently at Rittman Mead we have been asked a lot of questions surrounding Oracle’s new Data Visualization Desktop tool and how it integrates with OBIEE. Rather than referring people to the Oracle docs on DVD, I decided to share with you my experience connecting to an OBIEE 12c instance and take you through some of the things I learned through the process.
In a previous blog, I went though database connections with Data Visualization (more...)
I have followed the steps in Oracle Documentation link: https://docs.oracle.com/cd/E63000_01/EMXIG/ch2_deployment.htm#EMXIG215 to configure Exadata Database Machine in OEM13c. If you want to configure your Exadata in OEM13c you have to follow the above mentioned link. In this post I will share the mandatory steps for configuration, and some of the issues which I faced while configuring the Exadata…
this third and last part of a three part series on subprocesses we will
explore a special type of subprocess referred to as an “Event”
This type of subprocess is triggered by an event that
can occur anytime during the execution of a process flow that allows you
to interrupt the normal flow of an instance.
Such capability can be
applicable in various use cases. For example, an error might occur in
Exadata provides the highest-performing and most-available infrastructure for
running Oracle Database, whether it’s in the Oracle Cloud, on premises, or a
combination of both.
Oracle Exadata architecture features a scale-out design
with industry-standard servers and intelligent storage, including
state-of-the-art flash technology and a high-speed InfiniBand internal fabric.
This architecture provides 100 percent Oracle Database portability from on
premises to Oracle Public Cloud and back.
This new release includes bug fixes as well as new features including:
- New Cloud Adapters for Oracle and 3rd-party applications
- Operational Enhancements
- BAM and Real-Time Integration Business Insight Enhancements
- Major expansion of MFT functionality
For a list of new features in this release, please check the list of new features in SOA Suite and Managed File Transfer 220.127.116.11.0. Get SOA Suite 18.104.22.168 here
SOA & BPM Partner Community
This is probably not a 12.2 specific features and since I only tested for 12.2, I am not going to vouch for other versions.
Be careful when qualifying schema with DDL replication especially when the source and target schemas are not the same.
Example: Source schema is DEMO and Target schema is DEMO_REP
What happens to DDL replication when the following is used?
alter table demo.t add constraint t_pk primary key(id) using (more...)
This is a series of 8 short videos explaining how to create a
BPM application using Oracle Process Cloud Services. Part 1 will show
how to login and create a new application:
SOA & BPM Partner Community
regular information (more...)
At this Wednesday’s Oracle Midlands event someone asked me if Oracle would use the statistics on invisible indexes for the index sanity check. I answered that there had been a bug in the very early days of invisible indexes when the distinct_key statistic on the index could be used even though the index itself would not be considered as a candidate in the plan (and the invisible index is still used to avoid foreign key (more...)
A few weeks back I was copied on an email conversation about a important change with Global Temporary Tables (GTT) in Oracle Database 12c.
Something you need to be aware of when using GTTs in Oracle Database 22.214.171.124:Prior to this release GTTs shared statistics between sessions. Statistics were SHARED between... [Read More
Use of ANSI SQL is a personal thing.
Historically I have not been a fan apart from where it makes things easier/possible.
This reticence was mainly due to optimizer bugs and limitations in the earlier days.
Recently I have been using it much more because I find that the developers I interact with prefer it / understand it better.
You might/should be aware that Oracle will rewrite ANSI SQL to an Oracle syntax representation, this (more...)
Our partner OpRiskSolutions developed two solutions based on BPM Suite 12c:
Aria4Automotive is a comprehensive solution, designed to address the
specific requirements of Project Schedule Management in the Automotive
Industry. The solution supports specific automotive industry planning
concepts, such as enterprise-wide scheduling.
Aria4Pharma is a comprehensive enterprise solution that addresses the
specific needs, planning concepts and processes of drug development in
the pharmaceutical industry.
For more information about the Solutions Catalog & Cloud (more...)
Credits to Chris Smids from Proximus in Belgium Thanks, Chris!!!
Upgrade to Oracle 126.96.36.199 is slow in phase: #65 ?
You are wondering why phase: #65 of the database upgrade to Oracle Database 188.8.131.52 takes quite a while. You dig down into the catupgrd0.log and recognized this statement taking a... [Read More