Tag: computer

what is your backup and recovery strategy?

what is your backup and recovery strategy?

December 11, 2010 | By | Add a Comment

Hello friends, Yes our title is explaining every thing. What backup and recovery plan you are using? There are lot of alternatives find out in Oracle database server.  Take example replication, advance replication, oracle stream, dataguard, physical standby, logical standby, datapump, export/import, user managed cold backup, user managed hot backup and RMAN etc. Recovery manager […]

Read More

Oracle DBA Scripts- PGA management and pga_aggregate_target

Oracle DBA Scripts- PGA management and pga_aggregate_target

November 10, 2010 | By | Add a Comment

Hi Friends, Here you can find out some useful and important Oracle DBA scripts for managing and administrating Database very easily. Oracle DBA Scripts-1: How to check hidden PGA parameter setting from Oracle hidden parameters. Following scripts are very useful to get hidden pga parameters. Kindly execute with SYSDBA privilege. select a.ksppinm name, b.ksppstvl value […]

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

Type of DBA Roles and Importance of DBA Roles

Type of DBA Roles and Importance of DBA Roles

November 3, 2010 | By | Add a Comment

Hi Friends, People is having confusion regarding DBA roles and importance of DBA roles. Some people are knowing that Production DBA has all skill sets and there is no importance of another type of DBA roles. Below mention article explains type of Oracle DBA roles in present market and importance as well as characteristics of […]

Read More