nnnnnOracle import fails when importing into the same database but to a different schema, with this error. Problem is the type is exported with its object id (OID) in it’s definition. When oracle tries to recreate it in a different…

nnnnnStatus 25: “Cannot connect on socket” Exact Error Message 25 cannot connect on socket Details: Overview:When performing backups or restores, socket errors are being produced. Troubleshooting:Please follow all steps within the VERITAS NetBackup ™ Troubleshooting Guide or the NetBackup Troubleshooter…

nnnnnIBM: TSM (ADSM) back-up – TCP/IP connection failure J1gh2 (MIS) 11 Aug 04 7:15 Hi folks For a few months now a level 0 backup fails about once a week with “ANS1017E (RC-50) Session rejected: TCP/IP connection failure”. This error…

nnnnnBackupButler BB – ORA-1861 Using Date Format in Rman Recovery ‘SET UNTIL TIME’ ORA-1861 Using Date Format in Rman Recovery ‘SET UNTIL TIME’You are trying to use the RMAN command SET UNTIL TIME command to perform a Point-In-Time-Recovery. The following…

nnnnnVERY IMPORTANT!!!!!! EXP ERROR CauseThis problem during export has been introduced with the 9.2.0.5 patchset. In that patchset, a fix has been included for Bug 2948717 “Queries against DBA_SEGMENTS can be slow accessing BYTES/BLOCKS/EXTENTS columns”. Note that this fix has…

nnnnnHappy New Peek By Jaromir D.B. Nemec It is 6 A.M. of the New Years day, some DBA recapitulate the resolutions while others are already sleeping. In neither of those situations an alerting call is welcome. Though, exactly that happens.…

nnnnnLimit of 1050 columns for ANSI joins Please reference:http://www.halfcooked.com/mt/archives/000936.htmlThere’s a metalink bug “4369235 – ANSI joins may fail with ORA-1445” thatstates that this was fixed in the 10.2.0.2 patchset and that the workaroundis to “Transform the ansi join queries manually”

nnnnn CPU used by a database user on per session basis on OracleDECLAREv_session_cpu NUMBER;v_system_cpu NUMBER;v_cpu_ratio NUMBER;v_sid NUMBER;v_serial NUMBER;v_osuser v$session.osuser%type;v_username v$session.username%type;my_exception EXCEPTION;CURSOR sess ISSELECT sid,serial#,username FROM v$sessionWHERE username is not nullORDER BY username; BEGIN OPEN sess; FETCH sess into v_sid,v_serial,v_username; IF…

nnnnnChunyu Hu’s Weblog – How to tell which IPC resouces belongs to which instance: It’s quite common that there are more than 1 Oracle instance on 1 host. For example,we run many standby databases instances on 1 host for cost…