IN ORACLE MILIEU …

Beyond Knowledge

Category Archives: ORA Errors

Avoiding “no data found” : Tips

3 Comments Posted by on April 29, 2011

Some time we face issue about no data found depending on selection criteria. And when this happens in PLSQL procedure we get annoying error ORA-01403: No data found and execution stops. One way to get around this error is to add exception block in our PLSQL procedure as shown below EXCEPTION WHEN NO_DATA_FOUND THEN <Take Action> [...]

ORA Errors, Oracle Database 11g , , ,

WARNING: inbound connection timed out (ORA-3136)

Leave a Comment Posted by on March 17, 2011

Many times I faced this issue “WARNING: inbound connection timed out (ORA-3136)” in alert log and if you are using data guard, then you can see that dgmgrl status will show failed because standby is not able to sync up with primary. The “WARNING: inbound connection timed out (ORA-3136)” in the alert log indicates that [...]

ORA Errors, Oracle Database 10g , , ,

ORA-12705: Cannot access NLS data files or invalid environment specified

1 Comment Posted by on June 2, 2008

Some times we get this error in Oracle Applications R12 while running autoconfig for the first time on database side. This might be the case when we are cloning an environment or upgrading the database to new version. For example from 10g to 11g. The cause for the error is that Oracle is not able [...]

ORA Errors ,

ORA-12705: Cannot access NLS data files or invalid environment specified

3 Comments Posted by on March 31, 2008

While running autoconfig in oracle apps on database side, you might encounter this error. Also you can see this when you do sqlplus from command prompt. Cause:  Either your NLS_LANG parameter is not set correctly or NLS_ORA10 parameter is not set correctly. Solution : check $ORA_NLS10 path. This should point to ORACLE_HOME/nls/data/9idata if this is [...]

ORA Errors ,

ORA-00600: internal error code, arguments: [kcratr1_lastbwr]

17 Comments Posted by on March 31, 2008

Some time we encounter this error while starting the database. Below is the solution for recovering through this error. Error: SQL> startup ORACLE instance started. Total System Global Area 1073741824 bytes Fixed Size 1264916 bytes Variable Size 264241900 bytes Database Buffers 801112064 bytes Redo Buffers 7122944 bytes Database mounted. ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [...]

ORA Errors

Follow

Get every new post delivered to your Inbox.

Join 156 other followers