Author: bsingh@yahoo.com

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 schema it fails because OID is unique database wide. Here are the solutions. nnOn oracle…

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 within the Activity Monitor for this status code before continuing. Please confirm hardware and software…

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 appears in the database log file but there is nothing in the dsmerror.log or dsmsched.log.…

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 errors are reported: Recovery Manager: Release 8.0.4.0.0 – Production RMAN-06005: connected to target database: TARGET…

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 also been implemented in Oracle10g Release 1 (10.1.0.2.0). As a result of that fix, an…

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. “Our nightly Oracle job is hanging, but nothing was changed!”, is the plain message. “Nothing…

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 sess%notfound THEN RAISE no_data_found; END IF; LOOP SELECT value INTO v_session_cpu FROM v$sesstat WHERE sid…

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 reason. Sometimes, we fail to restart some Oracle instance because the IPC resources allocated for…