Category: DBA

Transparent Application Failover-Oracle RAC

Transparent Application Failover-Oracle RAC

November 29, 2012 | By | Add a Comment

Transparent Application Failover TAF in Oracle RAC Transparent Application Failover TAF is an automatic database session re-establishment or reconnection characteristic built into Oracle Call Interface (OCI) in Oracle Network. It is principally aimed for Real Application Cluster RAC environments to re-establish database sessions in case of cluster node failure or instance breakdown, but the utility […]

Read More

What is definition of Database

What is definition of Database

July 25, 2011 | By | Add a Comment

Definition of data and database – A quick look

Read More

Database character set conversion pre-checks Oracle utility

Database character set conversion pre-checks Oracle utility

December 6, 2010 | By | Add a Comment

Hi Friends, Conversion of Database character set is more difficult when large database involves. Database character set conversion is also very important procedure while we need or application needs change of character set. Oracle provides very good utility for pre-checking of database character set migration. It calls CSSCAN. Using CSSCAN we can check possible problems […]

Read More

Oracle Utilities Undocumented-dbfsize

Oracle Utilities Undocumented-dbfsize

December 6, 2010 | By | Add a Comment

Hi Friends, There is hidden and undocumented Oracle utility available called DBFSIZE. This Oracle utility provides exact size of file, which is connected with Oracle software. Means we can get size of control file, redo log file, datafile size using DBFSIZE undocumented Oracle utility. DBFSIZE utility doesn’t available for Windows platforms. How to use DBFSIZE […]

Read More

Compare MySQL Oracle

Compare MySQL Oracle

December 3, 2010 | By | Add a Comment

Hi Friends, Excellent article found to compare MySQL Oracle at database administration level. From the article…….. So many times, question is raining in every Database Administrator that what are the difference between MySQL and Oracle. Both are popular RDBMS. But in characteristic of MySQL Oracle and Oracle are different. Compare to Oracle, usage of MySQL […]

Read More

ORA-01045: user SCOTT lacks CREATE SESSION privilege

ORA-01045: user SCOTT lacks CREATE SESSION privilege

November 7, 2010 | By | Add a Comment

Hi Friends, This is general error getting from Oracle 10g database. It calls as ORA-01045 that lacking of create session privilege. Reason of ORA-01045: From Oracle 10g, connect role doesn’t contain create session privilege. Solution of ORA-01045: If you granted connect role to any user and database was upgraded then you should need to give […]

Read More