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: January 2010
Misleading ORA-01009
Client’s RAC to single instance standby database was having problems, throwing error ORA-01009. This was not helpful. $ oerr ora 100901009, 00000, “missing mandatory parameter”// *Cause:// *Action: So, How to resolve this ……..
Checking Standby Databases.
A client required to be sent a mail to update them on the status of two standby database’s. We could write something which logs onto each machine, checks the information and mails them out, or we can check just the … Continue reading
Oracle Managed Files.
Oracle Managed Files. Released with oracle 9i, OMF allows simplified management of database data files. I dont like OMF, and dont recommend that anyone use them, period. They are useful only where you are creating a database for testing or … Continue reading
Posted in Oracle
Comments Off
Recycled Triggers.
A client complained that a number of triggers were in the users schema, with confusing names, which turned out to be from the recyclebin. Here’s how it’s done and the confusion it causes.
map : Permission Denied Error.
Logging in as a non-dba group user, we were receiving the errors:$ sqlplus /nolog790688 : map : Permission Denied790688 : map : Permission Denied790688 : map : Permission DeniedHere’s how we fixed it.
Where can I found the release notes for Netezza 5.0 server?
Dear all, I am doting the producet certification for our product. We try to support Netezza 5.0. We have download the Netezza Client 5.0.4 and I try to find the release notes of the server 5.04. Coud anyone can tell me or give some tips on the Continue reading
Free and occupied space in the datafiles.
A client has a full OS, at 100% on certain mount points. The concern is that there is no space left in the datafiles.How to check the free space in the datafiles to see what growth is left before the … Continue reading
Recover standby with missing archived logs.
Recovering a database with missing archives. We face a situation sometimes where a standby database is missing redo logs, and the primary no longer has them available. Here’s a means to get past that problem using rman.
ORA-16139 signalled during: alter database commit to switchover to primary…
On a client’s recovery, I recieved the error ORA-16139 signalled during: alter database commit to switchover to primary…, here’s why…..
Posted in Oracle
Tagged ALTER, commit, database, during:, ORA-16139, primary..., signalled, switchover, to
Comments Off
