Trouble Shootings

Trouble Shootings

ASMCA tabs Volume and ASM Cluster File System are grayed out ORA-01427 While running DBMS_HM.RUN_CHECK How to load flat files containing Arabic (any non-English) characters using SQLLDR ORA-01704: String Literal Too Long. Cause: String Literal is Longer Than 4000 Characters Recovering/Opening database for which archive log is missing Privileges required for Debugging Oracle Procedure Column with NVARCHAR(4000) not appearing in Resultset using DG4MSQL ORA-15177: cannot operate on system aliases INS-20802 Grid Infrastructure Configuration Failed - 11gR2 on Windows ORA-00214: control file version inconsistent with file version ORA-01624: log %s needed for crash recovery of instance %s (thread %s) FRM-40733 PL/SQL built in DBMS_error_code failed ORA-02114 - Undocumented error RAC on Windows: Oracle Clusterware Node Evictions a.k.a. Why do we get a Blue Screen (BSOD) Caused By Orafencedrv.sys? ORA-01031 insufficient privileges ORA-01152: file 1 was not restored from a sufficiently old backup ORA-00245 control file backup failed ORA-12528: TNS: listener: all appropriate instances are blocking new connections ORA 1775 looping chain of synonyms  Recompiling Invalid Objects  Checking integrity of dump file ORA-29270 Too Many Open HTTP Requests ORA-12631: Username retrieval failed Datapump import gets ORA-600 [kpudpxcs_ctxConvertStream_ref_1] while importing Spatial data  Send Message to Users by OS Command using PL/SQL  How To Connect database in sqlplus without tnsnames.ora  OPatch failure issue while patching RAC (11.2.0.3)  CRS-4535: Cannot communicate with Cluster Ready Services

SP2-1503: Unable to initialize Oracle call interface

ORA-01002: fetch out of sequence

TNS-12535 / ORA-12535 on Connection to Database

ORA-273xx & ORA-04030 Errors

Export did not include some table in dump file

Alter system kill session and ORA-00031: session marked for kill

ORA-02449 during tablespace drop

FRM-92100 when running a long running report

How can I tell if a procedure/package is running

TNS-12531: TNS:cannot allocate memory

ORA-19815: WARNING: db_recovery_file_dest_size

WUC-14 Object Cache Error: Specified object handle {0} not found in the cache.

Schedule Killing sessions dynamically

Configuring SQL*Net for External Procedures

ORA-01017 May Cause ORA-3136 WARNING : Inbound Connection Timed Out in Alert Log

Oracle DBConsole service failed to start on Windows

Slow TNSPING time

TG4MSQL and slow response

Setting the Default Connect String

ORA-20000 on executing DBMS_STATS.GATHER_TABLE_STATS on table

DG4MSQL - Where clause does not return data