ORA Error ! Oracle database symptoms (ORA Error)

In this post we will fix ORA Error in oracle database.

Oracle database symptoms ORA Error :- 

 

oracle error codes list with description

 

 



 
 
1. Symptoms

 

Memory heap error ORA-7445[kssrem] and ORA-7445[kggchk] is reported in the alert.log and PMON terminates.
 
ORA-07445: exception encountered: core dump [kssrem()+176] [SIGSEGV] [Address
not mapped to object] [0x000000008] [] []
ORA-07445: exception encountered: core dump [kggchk()+52] [SIGSEGV] [Address
not mapped to object] [0x44000000020] [] [] MMAN: terminating instance due to error 472
ORA-00472: PMON process terminated with error
 
Cause:-
 
This is bug where various dumps / ORA-600 errors and ultimately an instance
crash can occur when a session performs a rollback to a savepoint type operation.
 
Action: Contact your customer support representative
 
2. Symptoms:-
 
ORA-00600 [kokcup:01] and ORA-00600 [kssadpm: null parent]
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
 
Cause:
 
This is the generic internal error number for Oracle program exceptions.  This indicates that a process has encountered an exceptional condition.
 
Action: Report as a bug – the first argument is the internal error number
 
 
3. Symptoms.
 
ORA-00060: Deadlock detected.
00060, 00000, “deadlock detected while waiting for resource”
 
Cause:  Transactions deadlocked one another while waiting for resources.
 
Action: Look at the trace file to see the transactions and resources involved. Retry if necessary.
 
 
4. Symptoms.
 
ORA-1652: unable to extend temp segment by 256 in tablespace     TEMP
 
Cause:  Failed to allocate an extent of the required number of blocks for Cause:  Failed to allocate an extent of the required number of blocks for a temporary segment in the tablespace indicated.
 
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated
 
Below are some ORA-ERROR which every DBA face:
  1.ORA 12514:    
TNS:listener does not currently know of service requested in connect descriptor
           Cause:
The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.
           Action:
– Wait a moment and try to connect a second time.
– Check which services are currently known by the listener by executing: lsnrctl services <listener name>
– Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener.
– If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener.
– Check for an event in the listener.log file.
 
 

2.     ORA-12537: TNS: connection closed error

Question:  I’m trying to connect to Oracle and I get the ORA-12537: TNS: connection closed error.  How do I fix an ORA-12537?
Answer: The ORA-12537 is an informational error, and the “real” error is the secondary error message.
Tnsping Net Service Name fails with TNS-12537: TNS:connection closed or Sqlplus connection errors out with Ora-12537
Cause:

* In the Sqlnet.ora file the parameter TCP.VALIDNODE_CHECKING is enabled and TCP.INVITEDNODES is set to some specific IP’s of the Client Machine.

* If trying to connect to the Apps database, by default, with Oracle Apps Installation the parameter TCP.VALIDNODE_CHECKING is enabled and TCP.INVITEDNODES is set to Server Machines IP or Hostname.

 

Solution:-

 

/* You can disable these parameters in the Sqlnet.ora

* Or add the client machines ip address in the TCP.INVITEDNODES list.

 
  ORA-00600/ORA-07445
     
        Clause: Most likely it is related to bug
     
        Solution: go to metalink and apply patch set.
4       
 ORA-04031

 

       
       Clause: Mis-configuration of SGA, insufficient memory
       
       Solution: Sametime need to add memory on system, or sametime need to reduce SGA memory
5     
      ORA-12154
      
       Clause: Wrong TNS_ENTRY is used.
       Solution: Using NETCA tools configure tns entry or check tnsnames.ora file for correct entry.
6       
     ORA-12368
      
       Clause: It is generic error lots of reason
       Solution: Edit SQLNET.ORA and change NONE from NTS “SQLNET.AUTHENTICATION_SERVICES=NONE”
        
     ORA-12500
       
       Clause: It is generic error lots of reason
       Solution: increase “processes” parameter, increase physical memory
       
      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)
 

 

 

1 thought on “ORA Error ! Oracle database symptoms (ORA Error)”

  1. If you have Herpes in your whole body such as fever blisters, hsv, or roofing shingles you know what it is like to stay with the pain and discomfort that herpes delivers. I don't need to tell you how awesome it would be to find something that works so well that you no longer need to fear about stress or outbreak,Dr Itua herbal medicine cure my herpes in two weeks of taking it.is genuine and natural herbal medicine it has no side effect, The reason I'm writing this is that I promised Dr Itua I will share his herbal work to the world to see Herpes is no more a big deal.also Dr Itua can as well cure the following diseases…HIV,Hsv 1/2,Hepatitis B,Cancer, Diabetes, Men/Woman Infertility, Scoliosis,Fibromyalgia,Fluoroquinolone Toxicity
    Syndrome Fibrodysplasia Ossificans Progressiva.Fatal Familial Insomnia Facator V Leiden Mutation , Lottery Spell,Copd, Shingles,Fibroid, Fibromyalgia, Liver/Kidney Inflamotry, Epilepsy,Hpv,Weak Erection,Wart Remover,Cold Sore, Coeliac disease,Creutzfeldt–Jakob disease,Cerebral Amyloid Angiopathy, Ataxia,Arthritis,Amyotrophic Lateral Sclerosis,Alzheimer's disease,Adrenocortical carcinoma.Asthma,Allergic Asthma. Here His Contact…[email protected]/Whatsapp Phone.+2348149277976. I paid for his herbal medicine and sent it to me through Courier Service which I pick it urgently and used.

    Reply

Leave a Comment