Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

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
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

No comments: