Between natural disasters, cybercrime and basic human error, organizations are looking for tools that support disaster recovery endeavors, as well as the professionals capable of using them.
A fair number of administrators often use Oracle's advanced recovery features to help them ensure business continuity for database-driven applications. The database vendor recently unveiled a couple of new offerings that tightly integrate with their Oracle Database architecture.
As I mentioned last week, Oracle sequences are often topics of conversation when discussing replication. Last week we covered the basics of sequences and I pointed out a few important facts; there may be ‘gaps’ in the sequence as Oracle does not guarantee that they will be in order, that there is an option to have […]
All ready to roll with RMOUG 2015 Training days presentation "OS Truth, little white lies, and the Oracle Wait Interface".
Best of course to come to RMOUG 2015 Training days ... but this is link to pdf version of the presentation here: John Hurley RMOUG 2015
If you are out there ( very excited personally my first time at this conference ) please kick me and say hello. Ok maybe skip the kicking part ...
Licensing may be required ... please check if applicable.
A query like this can be used to check how much blocking and what session it was ... ( so then you can drill into those blockers sessions ). Probably can be done easily with some kind of rollup query?
Adjust SAMPLE_TIMEs in where clause below.
select ash_data.*, substr(sqlinfo.sql_text,1,70)
We are upgrading oracle database version 126.96.36.199 to 188.8.131.52. Before upgrade invalid object count was 0 (Zero). But after upgrade one of the object in Quest schema become invalid. Due to which catsbp.sql is also incomplete. Kindly help..
Part of log file.
*** Invalid Objects after recompiling ***
OWNER OBJECT_ID OBJECT_TYPE OBJECT_NAME
QUEST 408304 PACKAGE BODY QUEST_SPC_ANALYZE
*** END RECOMPILING OBJECTS ***
When trying to integrated JDeveloper with SOA server the below error Appeared :-Testing JSR-160 Runtime ... failed.Cannot establish connection.Testing JSR-160 DomainRuntime ... skipped.Testing JSR-88 ... skipped.Testing JSR-88-LOCAL ... skipped.Testing JNDI ... skipped.Testing JSR-160 Edit ... skipped.Testing HTTP ... success.Testing Server MBeans Model ... skipped.
It seems impossible to raise an exception when handling no_data_needed.
Last Monday evening we had the first Singapore Oracle Sessions - an informal meetup of Oracle professionals thrown together at the last minute by a few of us.