Download VMware-workstation for windows 8

• Latest version:
  VMware Workstation 9.0.2 Build 1031769
• Requirements:
  Windows XP / 2003 / Vista / Windows 7 / Windows 8
• File size / license:
  429.91 MB / Commercial Trial

http://www.filehorse.com/download-vmware-workstation/download/

Change XS$NULL Default tablespace

Oracle database not allow SYS alter user xs$null, from version 11.2.0.1. It explains why I get ORA-01031: insufficient privileges when I try to alter its default tablespace.

SQL>  alter user xs$null default tablespace TBS_1 quota unlimited on TBS_1;
 alter user xs$null default tablespace TBS_1 quota unlimited on TBS_1
*
ERROR at line 1:
ORA-01031: insufficient privileges

But still you can change it by setting the default tablespace name with out giving XS$NULL in the statement .

SQL> alter database default tablespace TBS_1;

Database altered.

SQL> select default_tablespace from dba_users where username='XS$NULL';

DEFAULT_TABLESPACE
------------------------------
TBS_1

Ref: MOS ID 1325766.1, “nobody eve user SYS can alter xs$null“.  

Enable Telnet on Windows 2008 server

http://www.petri.co.il/enabling-telnet-client-in-windows-server-2008-and-windows-vista.htm

http://www.petri.co.il/enabling-telnet-client-in-windows-server-2008-and-windows-vista.htm

Grid Control blocked agents...

http://newappsdba.blogspot.com/2011/06/grid-control-11gblocked-agents.html

Thanks to the above link site owner...

Auditing and reporting Oracle user activity

http://www.dba-oracle.com/art_builder_sec_audit.htm

by Don

Oracle 10g - Manually Create a Physical Standby Database Using Data Guard

http://www.orafaq.com/node/2030

Scripts to find out SIZE of the DB

Query to find the DB size in Bytes.

select a.data_size+b.temp_size+c.redo_size "total_size"
from ( select sum(bytes) data_size
         from dba_data_files ) a,
     ( select nvl(sum(bytes),0) temp_size
         from dba_temp_files ) b,
     ( select sum(bytes) redo_size
         from sys.v_$log ) c;

Another query ("Free space" reports data files free space):

col "Database Size" format a20
col "Free space" format a20
select round(sum(used.bytes) / 1024 / 1024 /1024  ) || ' GB' "Database Size"
,      round(free.p / 1024 / 1024 / 1024 ) || ' GB' "Free space"
from (select bytes from v$datafile
      union all
      select bytes from v$tempfile
      union all
      select bytes from v$log) used
,    (select sum(bytes) as p from dba_free_space) free
group by free.p
/

RAC Architecture (Includes ASM)

http://www.datadisk.co.uk/html_docs/rac/architecture.htm

Superfast Database Copying / Cloning

http://www.dba-oracle.com/oracle_tips_db_copy.htm

Dataguard Step-by-Step configuration

http://www.orafaq.com/forum/t/81450/2/