Hi Everyone,
My article published in IOUG (Independent Oracle User Group) 2011 Best Practices Booklet and distributed at Oracle Open World.
Understand the Power of Oracle RMAN – Page 47
By Satishbabu Gunukula
Please find the link.
http://www.slideshare.net/satishbabugunukula/ioug-tip-book11gunukula
Hope you like the article.
Regards
Satishbabu Gunukula
http://www.oracleracexpert.com
Thursday, October 20, 2011
Friday, October 14, 2011
ORA-01187: cannot read from file 201 because it failed verification tests
You may receive this error under below circumstances.
1. when your temp file drive failed
2. when you duplicate your database.
3. When you trying to take backup controlfile to trace….etc
ORA-01187: cannot read from file 201 because it failed verification tests
ORA-01110: data file 201: '/u03/oradata/TEST/temp01.dbf'
The temp data file didn’t not pass the checks to insure it is part of the database and reads are not allowed until it is verified.
You will see the status as “ONLINE” when you check the status of the temp file using v$tempfile. But when you query DBA_TEMP_FILES’, you will receive the error.
SQL> SELECT FILE_ID,FILE_NAME, STATUS FROM DBA_TEMP_FILES;
ERROR at line 1:
ORA-01187: cannot read from file 201 because it failed verification tests
ORA-01110: data file 201: '/u03/oradata/AGX/temp01.dbf'
To resolve this issue first run below command and query DBA_TEMP_FILES.
SQL> ALTER SYSTEM CHECK DATAFILES
If you still have the issues then add a tempfile and drop the file which has issues.
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE ‘'/u03/oradata/TEST/temp02.dbf' SIZE 100M;
SQL> ALTER DATABASE TEMPFILE TEMPFILE ‘'/u03/oradata/TEST/temp01.dbf' DROP;
This should resolve your issue.
Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com
1. when your temp file drive failed
2. when you duplicate your database.
3. When you trying to take backup controlfile to trace….etc
ORA-01187: cannot read from file 201 because it failed verification tests
ORA-01110: data file 201: '/u03/oradata/TEST/temp01.dbf'
The temp data file didn’t not pass the checks to insure it is part of the database and reads are not allowed until it is verified.
You will see the status as “ONLINE” when you check the status of the temp file using v$tempfile. But when you query DBA_TEMP_FILES’, you will receive the error.
SQL> SELECT FILE_ID,FILE_NAME, STATUS FROM DBA_TEMP_FILES;
ERROR at line 1:
ORA-01187: cannot read from file 201 because it failed verification tests
ORA-01110: data file 201: '/u03/oradata/AGX/temp01.dbf'
To resolve this issue first run below command and query DBA_TEMP_FILES.
SQL> ALTER SYSTEM CHECK DATAFILES
If you still have the issues then add a tempfile and drop the file which has issues.
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE ‘'/u03/oradata/TEST/temp02.dbf' SIZE 100M;
SQL> ALTER DATABASE TEMPFILE TEMPFILE ‘'/u03/oradata/TEST/temp01.dbf' DROP;
This should resolve your issue.
Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com
Monday, October 3, 2011
ORA-12547: TNS:lost contact
When I tried to login into oracle I have received below error
sapec4:ec4adm 61> sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Thu Sep 29 14:00:17 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> connect / as sysdba
ERROR:
ORA-12547: TNS:lost contact
Here is the simple solution for that
Solution1:-
1.Check “oracle:dba” should have ownership on $ORACLE_HOME/bin/sqlplus
$chown oracle:dba $ORACLE_HOME/bin/sqlplus
2.$ORACLE_HOME/bin/sqlplus should have 6751 permission
$chmod 6751 $ORACLE_HOME/bin/sqlplus
If you still have the problems try solution 2.
Solution2:-
You may receive this error if oracle binaries are not linked correctly, stop databases and relink the binaries.
$ ORACLE_HOME/bin/ relink all
If you find below errors in listener.log then problem related to limit of PROCESSES value.
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Solution:- Increase the PROCESSES parameter in the init.ora to a higher value
SQL> Alter system set processes= “”
After fixing TNS issue you may see below error
ORA-27140: attach to post/wait facility failed
Solution:-
$ cd $ORACLE_HOME/bin
$ chmod 6751 oracle
Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com
sapec4:ec4adm 61> sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Thu Sep 29 14:00:17 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> connect / as sysdba
ERROR:
ORA-12547: TNS:lost contact
Here is the simple solution for that
Solution1:-
1.Check “oracle:dba” should have ownership on $ORACLE_HOME/bin/sqlplus
$chown oracle:dba $ORACLE_HOME/bin/sqlplus
2.$ORACLE_HOME/bin/sqlplus should have 6751 permission
$chmod 6751 $ORACLE_HOME/bin/sqlplus
If you still have the problems try solution 2.
Solution2:-
You may receive this error if oracle binaries are not linked correctly, stop databases and relink the binaries.
$ ORACLE_HOME/bin/ relink all
If you find below errors in listener.log then problem related to limit of PROCESSES value.
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Solution:- Increase the PROCESSES parameter in the init.ora to a higher value
SQL> Alter system set processes= “
After fixing TNS issue you may see below error
ORA-27140: attach to post/wait facility failed
Solution:-
$ cd $ORACLE_HOME/bin
$ chmod 6751 oracle
Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com
Subscribe to:
Posts (Atom)
