Monthly Archives: July 2011

How to drop a RAC database manually

As we’re all used since the advent of the “new” command “drop database” on oracle, that sometimes, for a clean and total remove of oracle’s database it’s used. But if you try just use on a RAC environment, it’s necessary a little trick.

The steps are:

1) on cluster (or on the instance it self) do a:

srvctl stop database -d <databasename>

2) startup on restrict mode:

sqlplus / as sysdba

startup mount restrict exclusive;

3) The Trick !!! Change the parameter CLUSTER_DATABASE to false!!!

alter system set cluster_database=false scope=spfile;

4) restart it again restricted:

shutdown immediate;
startup mount restricted exclusive;

5) Finally: drop database !!! (becareful, it has no rollback!!!)

drop database;

6) Done !

Cheers!

Configure CheckPoint VPN SecureClient 256-bit encryption on Mac OSX Snow Leopard (10.6) 64bits

Download CheckPoint VPN SecureClient for Mac OSX Snow Leopard (10.6) 64bits

After CheckPoint VPN SecureClient installation, open a terminal and do the following

sudo vi /opt/CPsrsc-50/database/users.C

Change the phase2_aes_key_size to 256

Save and exit users.C file.

Restart SecureClient.

 

I hope it was useful!!!
Cheers

Error remote connection to SCAN after Oracle RAC 11gR2 installation

If after the installation of Oracle RAC 11gR2, when you try to connect remotely you have the following error:

ORA-12545: Connect failed because target host or object does not exist

connecting on both nodes of RAC you have the following error:

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

and both LISTENER and LISTENER_SCAN1 are ok.

Then look at database parameter local_listener.

If it’s pointing to one of vip name’s (NODE1-vip or NODE2-vip), change it to RAC name (RAC01)

SQL> show parameter local_listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=NODE1-vip)(PORT=1521))))

SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=RAC01)(PORT=1521))))';

System altered.

SQL> alter system register;

System altered.

I hope it was useful!!!
Cheers

Optimization WordPress Plugins & Solutions by W3 EDGE