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: October 2010
An introduction to TwinFin
What would be possible in your world if you had a database that could use all of the information relevant to your analysis: as much business history as you have; all telemetry data generated each day; every customer action and interac… Continue reading
Posted in best_practices, brian, data_warehouse_appliance, enzee, Netezza, twinfin
Tagged Netezza
Comments Off
Insufficient privileges purging scheduler logs.
Cannot purge the job history logs ? If you get insufficient privileges, you require the SCHEDULER_ADMIN role.
Posted in Oracle
Tagged CLASSES, CREATE~ANY~JOB;, CREATE~JOB, dbms_scheduler, JOB, programs, windows
Comments Off
ORA-02800: Requests timed out
I had a simple job to run, which failed. exec dbms_scheduler.run_job(‘CHECKJOB’); returned the following. ERROR at line 1:ORA-02800: Requests timed outORA-06512: at “SYS.DBMS_ISCHED”, line 150ORA-06512: at “SYS.DBMS_SCHEDULER”, line 441ORA-06512: at line 2
Posted in Oracle
Tagged 473551, 473551.1, dbms_scheduler, dbms_scheduler.run_job, Metalink, ORA-02800, RUN_JOB
Comments Off
Netezza Receives 2010 DMA Innovation Award
MARLBOROUGH, Mass., — October 26, 2010 — Netezza Corporation (NYSE: NZ), the global leader in data warehouse, analytic and monitoring appliances, has received honors from the Direct Marketing Association (DMA) for outstanding advancements in dire… Continue reading
User cannot see package body.
A database user could not see the package body of another users package. Even with execute on the package granted, this still was not possible. That seemed odd, but here’s how oracle works it.
Posted in Configuration., Oracle, PLSQL
Tagged Access, DBA_SOURCE, DBA_SYS_PRIVS, package, PACKAGE~BODY
4 Comments
Windows Agent will not start.
Lost communication with agent from Grid on Windows 2003 server. I was unable to communicate with the agent on a server. Note that the symptoms are nothing to do with the cause. EM displayed the following : Error Communication between … Continue reading
Posted in Enterprise Manager
Tagged A~SERVICE~SPECIFIC~ERROR, EMAGENT~IS~THRASHING, EMCTL, EMCTL~START~AGENT, NET~HELPMSG~3547, THRASHING, windows
Comments Off
Netezza Explain Plan
Each query that is submitted to Netezza results in a corresponding query plan. These plans are kept under /nz/data/plans and the archived ones are located under /nz/kit/log/planshist on the Netezza host. Archived files are kept up to a certain number and are purged; something like 5000 files. To save them on a permanent basis, [...]
Continue reading
ExactTarget Hits Bullseye with Netezza’s TwinFin Appliance
Global Provider of Email and Interactive Marketing Solutions Uses Netezza to Enhance Targeting Precision and Increase Campaign Response Rates
MARLBOROUGH, Mass., — October 21, 2010 — Netezza Corporation (NYSE: NZ), the global leader in data war… Continue reading
Database Backup from Scheduler.
I wanted to backup a database using an OS script, but scheduled from the database rather than from the OS. Here’s the setup for it.
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 10.02.00.02 in TARGET database is not current
Rman reported an interesting error. PL/SQL package SYS.DBMS_BACKUP_RESTORE version 10.02.00.02 in TARGET database is not current This occurs where the wrong rman version is used on a different version database. Here’s how it occured.
Posted in Enterprise Manager
Tagged backup, BACKUP~DATABASE, NOT~CURRENT, Rman, SYS.DBMS_BACKUP_RESTORE, Target, TARGET~DATABASE, VERSION
Comments Off
