Comments
- Phil Dunn (@Phil_Oracle) on Oracle’s New T5 TPC-C: Where’s the SPARC?, Part II
- ODBC on Installing the Netezza ODBC Driver.
- ashish on View deleted data in Netezza with view_deleted_records.
- Gary on Installing the Netezza ODBC Driver.
- venkat on Installing the Netezza ODBC Driver.
- Gary on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- arnab on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- Hank Classe on ANS1017E (RC-50) Session rejected: TCP/IP connection failure
- Sean Robinson on Registering with Multiple listeners.
- Gary on Sending nzevent emails for system state changes.
Meta
Tag Archives: 10g
Exadata, You Bully !
Yesterday I was reviewing a presentation and had an “aha” moment. In one case, results were being compared between technologies that were at about the same currency. In another case comparisons were being done between brand new spanking technology — and systems that were many years old. This morning I again came face to face [...]
Continue reading
Recording Database Size.
A user asks “I would like to check the growth of a particular tablespace on the database for a month or so, do you perhaps, have a script that can assist.” If you have no process capturing the size of … Continue reading
Posted in Database Size, Monitoring
Tagged 10g, database growth, database size, datafile size, EM, MONITORING, reporting, tablespace size
Comments Off
Obtaining x rows dual.
Connect by Level. Someone asked how to obtain a list of dates in the future for a table which does not have data yet. Interesting investigation….. (Thanks to Bruno Vroman)
ORA-19526: only one location allowed for parameter db_recovery_file_dest
ORA-19526: only one location allowed for parameter db_recovery_file_dest. Oracle 10g and 11g are supposed to allow multiple values in the db_recovery_file_dest, however this does not work and returns the above error. Here’s things I’ve found which cause this problem.
Posted in Configuration., Oracle
Tagged 10g, 11g, create~pfile~from~spfile, CREATE~SPFILE~FROM~PFILE, DB_RECOVERY_FILE_DEST, ORA-19526, PFILE, SPFILE
Comments Off
Tracing by module.
Tracing by module. A client required to run a trace on an application connecting to the database. dbms_monitor in 10g does not allow tracing by module without a service name. Here’s a work around.
Posted in Oracle
Tagged 10g, AUDITING, DBMS_MONITOR, LOGON~TO~DATABASE, TRACING, trigger, UTL_FILE
Comments Off
Unsupported OS and database.
I had metalink in the health warnings inform me on OCM 10.3.2 that my AIX 5.3 and oracle 10.2.0.4 were not certified. I checked with note 957549.1 and it told me it was !!!
Posted in Configuration.
Tagged 10g, AIX, AIX5.3, AIX5L, AIX5L5.3, CERTIFICATION, uncertified
Comments Off
Flashback Versions Query.
Oracle 10 r1 introduced the ability to query data in a table historically from the undo tablespace.This allowed us to view the data in a table and the changes over time, as well as the time and date that the … Continue reading
Posted in Flashback Query, Flashback Technologies, Oracle
Tagged 10g, 10g R1, FLASHBACK, Flashback~Versions~Query, New~Features, query, truncate
Comments Off
Refreshing a Physical Standby.
The client opened the standby database without stopping the primary. This destroys the dataguard setup. Here’s where I perform a refresh.
Posted in DataGuard, Oracle, Physical Standby, Standby
Tagged 10g, physical standby, refresh, standby
Comments Off
