Archive for April 2012

ORA-01157: cannot identify/lock data file

You may see this message in RAC when trying to start up instance or database. This error is being caused by unmounted ASM diskgroup. ERROR: ORA-01157: cannot identify/lock data file 37 – see DBWR trace file ORA-01110: data file 37: ‘+MIDATA2GRP/midb/datafile/iotest.256.772203865’ WWW.STONESAGATEAMETHYST.COM/WEB/PDL/pay a loanlenders provide such emergencyonline […]

Read more

ORA-00900: invalid SQL statement

SQL> select  file# ||’ to ‘|| name from v$dbfile; loans no proof of incomeVERITRIX.COM/MOBI/CALLCENTERCAFE.COM/FACEBOOK/ select  file# ||’ to ‘|| name from v$dbfile * ERROR at line 1: ORA-00900: invalid SQL statement When you try to concatenate a field name with “#”, it could result in above error […]

Read more

TNS-04404: no error caused by: TNS-04414: File error caused by: TNS-04612

This error is seen in Oracle 10gR2, on tnsnames.ora alias definition error during database creation. The error is likely to report SQL*Net alias in tnsnames.ora file. Look for “DESCRIPTION” line in the alias, add a space if “DESCRIPTION” in line with alias and a space between “DESCRIPTION” […]

Read more
100 Arbor Oak Drive, #200
Ashland, Virginia 23005-2261
Phone: 1-(804)-368-8631
Toll Free: 1-(877)-230-7449