Archive

Archive for December, 2009

Useful Info in Cape town

December 15, 2009 Leave a comment

Hotels
=====
townhouse hotel
t +27 (0)21 465 7050
f +27 (0)21 465 3891
60 Corporation Street, Cape Town 8001
PO Box 5053, Cape Town 8000,
South Africa
http://www.townhouse.co.za

Ashanti Lodge
===========
Address Details
11 Hof Street, Gardens, 8001,
Cape Town, South Africa
Tel: (+27-21) 423 8721
Fax: (+27-21) 423 8790
600R / day single

Website to Book tickets to Table Top and Robbens Island
http://www.webtickets.co.za/
Aquarium/Lower Cableway Station/City Sightseeing Bus R360
Robben Island R200 return trip across Table Bay, a visit to the Maximum Security Prison, and a bus tour of the Island
Table Top mountain R155

Rikkis Taxis
Rikki taxi on (021) 418-6713 or (021) 425-7312.

Gyms
Virgin Active (foreshore)
21 Lower long Street
8001 Cape town

85R /day

75R/day
http://www.bookcapetown.com/home

renaissancebsi

Cricket Tickets
—————–
http://www.computicket.com/web/

Things to do

Categories: personal

recreating undo tablespace

December 13, 2009 3 comments

if your undo tablespace has grown to a large size and you need to recreate it , you can do so with the following steps

SQL> SELECT name,value FROM v$parameter WHERE name IN (‘undo_management’,’undo_tablespace’);

NAME VALUE
————————
undo_management AUTO
undo_tablespace UNDOTBS01

SQL>
SQL> CREATE UNDO TABLESPACE undotbs02
DATAFILE ‘/u01/app/oracle/oradata/nespets/undotbs02.dbf’ SIZE 1024M
REUSE AUTOEXTEND ON NEXT 4096K MAXSIZE 10240M;

SQL> ALTER SYSTEM SET undo_tablespace = ‘UNDOTBS02′;
SQL> ALTER TABLESPACE undotbs01 OFFLINE;
SQL> DROP TABLESPACE undotbs01 INCLUDING CONTENTS AND DATAFILES;
SQL>

With these steps we created a new undo tablespace, set it as the system default undo tablespace and drop the old tablespace including the datafiles.

Categories: Oracle

error while loading shared libraries: $ORACLE_HOME/lib/libnnz11.so:

December 13, 2009 Leave a comment

If you get the following error in RHEL 5

error while loading shared libraries: $ORACLE_HOME/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied

If you ever had any of the previous symptons while trying to install Oracle Software, create a instance / database with DBCA, create a listener or even run sqlplus… then you probably have SELinux mode set to “Enforcing”.

Under Oracle Enterprise Linux or Redhat Enterprise Linux, if needed we can switch SELinux from the default “Enforcing” mode that it is running in, to the “Permissive” mode by running following commands as root user:

[root@server~]# getenforce
Enforcing
[root@server~]# setenforce 0
[root@server~]# getenforce
Permissive

The previous commandes changed the default mode to “permissive” and allows SELinux to continue running, and logging denial messages, but will not deny any operations. If you would like to return to Enforcing mode just run as root:

[root@server~]# setenforce 1
[root@server~]# getenforce
Enforcing

Categories: Oracle

Oracle RAC Cluster Diag information

December 8, 2009 1 comment

Useful commands and log files to trace the cluster

+ crsd.log
Located in $ORA_CRS_HOME/log//crsd/

+ crs_stat -t
+ crs_stat -p

+ OCRDUMP
su root
cd $ORA_CRS_HOME/bin
./ocrdump MyOCRDUMP

export SRVM_TRACE=TRUE
script /tmp/srvm.out
srvctl start instance …..
exit

Categories: Oracle Rac