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
Controlling Connections Established by Database Links
Tracing can be done using – ALTER SYSTEM SET EVENTS ‘2049 trace name ERRORSTACK level 3’;
Nice note from MOS.
How to Obtain a System State Trace BEFORE the Error ORA-2049 Occurs, While Still Experiencing the Contention (Doc ID 789517.1)
Commit after select from dblink – blocking lock.
04:45:30 ARROW:(DEMO@leo):PRIMARY> select name from v$pdbs@mdinh_april;
04:45:36 ARROW:(DEMO@leo):PRIMARY> commit;
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/184.108.40.206/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).
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 220.127.116.11.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 have never delved into networking for GoldenGate since things just work. Due to security tightening, telnet is no longer available to verify opened port.
What’s to follow is a demo for ports being listened by GoldenGate when manager started and ports listened and when PUMP Extract is started as part using DYNAMICPORTLIST.
Also, how to test opened port using (nc – arbitrary TCP and UDP connections and listens)
Both source and target are running on the (more...)
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...)
Admittedly, I did not realize the benefit at first until there came a need.
# Set ORACLE_SID
### This retrieve the numeric value from PROD1/PROD2, i.e. 1,2 respectively
backup tag 'ARCHIVED_LOG' archivelog all delete input skip inaccessible;
alter database backup controlfile to trace as '/rman_bkup$n/$ORACLE_SID/cf_@.sql' REUSE RESETLOGS;
create pfile='/rman_bkup$n/$ORACLE_SID/init@.ora' from spfile;
create pfile from spfile;
Just like anything, there is good and bad.
Unfortunately for me, my experience with Oracle education has been predominately bad and former manager experienced the same where he was able to retake a course almost a year later since the original was unrealistic for real world scenarios.
With Oracle education, the most simplistic setup is used, e.g. no ASM, no Grid Infrastructure as it may add a little more complexity to set up?