Friday, October 21, 2011

Webinar: Oracle Real Application Cluster

Oracle Real application cluster allows multiple database instances on different servers in the cluster against a shared database. Oracle RAC provides Reliability, Recoverability, Error Detection and Continuous operations.

Date and time: Monday, November 14th 2011 8:00am - 9:00am PST

You will get an opportunity to learn
  • What is Real Application Cluster?
  • Oracle Cluster Benefits & Components
  • Oracle Cluster Ready Services
  • Interconnect & Cache fusion
  • Oracle RAC Database & ASM
  • Transparent Application Failover (TAF)
  • Backup & Recovery
  • New Features in Oracle 11g RAC
To register for Webinar, please send an email to SatishbabuGunukula@gmail.com and reserve your spot. You will receive an email confirmation with Webinar link.

Registration is limited.

Click here for presentation link

Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com

Thursday, October 20, 2011

Understand the Power of Oracle RMAN

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

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

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