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
Monthly Archives: August 2008
Backup 11g in windows.
I had a windows server which I could not get oracle to authenticate against. As an interim, I created the following to schedule backups.
Posted in Oracle, Recovery Manager
Tagged algorithm, archived, archivelog, autobackup, backups, COMPRESSION, configure, controlfile, database, default, defaultconfigure, deleted, deletion, encryption, following, maxsetsize, mydatabase, snapshot, unlimited, warning
Comments Off
Using dbms_Stats.export_database/schema_Stats
We had a migration which resolved a problem only when statistics were re-collected on a table. To store these statistics, we followed the following procedure, allowing restoration of the statistics if required.
Posted in Oracle
Tagged alternatively, completed, database, dbpostmacx, fashion, identify, ownname, performance, postmacx, problems, procedure, process, required, resolved, restoration, similar, statistics, statown, stattab, successfully
Comments Off
Oracle 11g EMCA configuration
I struggled to get the Enterprise Manager working on a database installation. Here’s how to clear everything out and start fresh.
Posted in Enterprise Manager, Oracle
Tagged cfgtoollogs, Configuration, control, database, dbcontrol, dbcontrolutil, emconfig, emdbpostconfig, emreposconfig, following, information, invokeinfo, notifications, password, product, pwcinternal, repository, settings, successfully, zapwcdw
Comments Off
Compile Invalid Objects.
Posted in Oracle
Tagged ALTER, Compile, DBMS_DDL, DBMS_UTILITY, Invalid, MANUAL~COMPILE, UTLRP.SQL, UTL_RECOMP
Comments Off
