Common Ora Error Codes
Contents |
Topic Backup and recovery Database Admin View All Cloud infrastructure Availability Database design Export, import and migration Installation, upgrades and patches Oracle performance problems ora error codes and description and tuning Oracle security Oracle DBA tools Error messages ora error codes list MySQL database Real Application Clusters (RAC) Applications View All Enterprise and business performance
Oracle Error Codes
management Implementing and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All
Oracle Error Codes Table
BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters oracle error codes pdf (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fusion I
and other http://www.oracle.com/pls/db92/db92.error_search?prefill=ORA- troubleshooting information in these books. List of Message Types ORA-00000 to ORA-00899 ORA-00900 to ORA-01499 ORA-01500 to ORA-02099 ORA-02100 to ORA-04099 ORA-04100 to http://www.orafaq.com/node/2598 ORA-07499 ORA-07500 to ORA-09857 ORA-09858 to ORA-12299 ORA-12300 to ORA-12399 ORA-12400 to ORA-12699 ORA-12700 to ORA-19399 ORA-19400 to ORA-24279 ORA-24280 to ORA-29249 error codes ORA-29250 to ORA-32799 ORA-32800 to ORA-32999 ORA-33000 to ORA-65535 BFILE-Related Messages (LFI) DBNEWID Messages (NID) DBVERIFY Messages (DBV) Export Messages (EXP) External Naming Messages (NNF) External Tables Messages (KUP) Import Messages (IMP) interMedia Audio Messages (AUD) interMedia Image Messages (IMG) interMedia Video Messages (VID) Network ora error codes Security Messages (NZE) Object Type Translator Initialization Messages (O2I) Object Type Translator Type File Messages (O2F) Object Type Translator Unparser Messages (O2U) Oracle Names Client Messages (NNC) Oracle Names Control Utility Messages (NNL) Oracle Names Server Messages (NNO) Oracle Names Server Network Presentation Layer Messages (NPL) Oracle Net Messages (TNS) Oracle OLAP Catalog Metadata Messages (AMD) Oracle Text Messages (DRG) Oracle Trace Collection Services Messages (EPC) Parameter Messages (LCD) Parameter Messages (LRM) PCF FIPS Messages (PCF) PL/SQL and FIPS Messages (PLS) Pro*C/C++ Messages (PCC) Pro*COBOL Messages (PCB) Recovery Manager Messages (RMAN) Remote Operation Messages (NCR) Simple Network Management Protocol Messages (NMP) SQL Runtime Messages (SQL) SQL*Module Messages (MOD) Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM) XML Parser Messages (LPX) XML Schema Processor Messages (LSX) Copyright © 2016, Oracle. All rights reserved.
How to change column order when using SELECT * Oracle 12cR2 - the next release, cloud only? Send SMTP Mail using UTL_SMTP Package Tips to install Oracle 11gr2 RAC on AIX (6.1/7.1) Create RAID hardware on Sun Sparc T5-2 Solaris 10 - Create software RAID 1 Some tips on installation Oracle 11gr2 on RHEL6 Migration ASM, the ARC diskgroup to the new storage How indexes can degrade performance Roles , PL/SQL, and ORA-00942: table or view does not exist More You are hereHome » Blogs » mazqurayahoocom's blog Common ORA errors Submitted by mazqurayahoocom on Tue, 2011-11-22 05:58 articles:Technical ArticlesBelow are some ORA-ERROR which every DBA face: 1. ORA-00600/ORA-07445 Clause: Most likely it is related to bug Solution: go to metalink and apply patch set. 2. ORA-03113 Clause: It is generic error means lots of reason behind this. Solution: Depends on condition but best way to search on google/forms. 3. ORA-04031 Clause: Mis-configuration of SGA, insufficient memory Solution: Sametime need to add memory on system, or sametime need to reduce SGA memory 4. ORA-12154 Clause: Wrong TNS_ENTRY is used. Solution: Using NETCA tools configure tns entry or check tnsnames.ora file for correct entry. 5. ORA-12368 Clause: It is generic error lots of reason Solution: Edit SQLNET.ORA and change NONE from NTS "SQLNET.AUTHENTICATION_SERVICES=NONE" 6. ORA-12500 Clause: It is generic error lots of reason Solution: increase "processes" parameter, increase physical memory 7. ORA-12528 Clause: It is BUG in 10g (if you face this error in 10g) Solution: Don't use TNS_ENTRY with connect string or edit listener configuration from STATIC to DYNAMIC.(search on my blog for more) Below are some question which everyone is confused 1. select count(*) or count(columname) which is faster ? Answer: Both are same in performance in speed. 2. How frequently index should be rebuild. Answer: NO, We never need to rebuild index becuase it is not increase database performance 3. For Oracle Database Windows is good OS or Linux is good. Answer: Linux is much better than Windows for Oracle. 4. How to increase Database Performance? Answer: Database performance use below methology. 1. Define what database performance is acceptable. 2. When you face performa