Deleting database in 10g 2 node RAC Cluster ---using DBCA

Hello all,

I am the new member .

I have doubt about deleting database using DBCA.

I have installed RAC on windows server 2003 64bit.....its a2 node cluster and there are four databases in this cluster. While creating the first database using DBCA I have selected the wrong character set WE8MSWIN1252 instead of UTF8 I realized after I created the database. Now I want to change the character set to UTF8.

by some means I have found that UTF8 is not super set WE8MSWIN1252 so I just can't use *alter ....* so I have delete the database and recreate it. is it safe to just delete the databse using DBCA and recreate it using DBCA in RAC environment.??

Any help is grealty appreaciated.

yes

Thanks for the reply davey.


Yes I could delete and recreate the database using DBCA. I had no problem.


but I have another issue. Let me explain my scenario.

as mentioned earliar I have installed a 2 node RAC database on windows with 4 databases. The installation went fine. but the problem I have is 2 of the 4 databases are fine and up but with the two databases I am getting the below error when I trying to connect to the database.

TNS-12516: TNS:listener could not find available handler with matching protocol stack.



TNS-12519: TNS:no appropriate service handler found.


I have check the listener and the tnsnames both look fine.
here the listener file for 3rd database which is APACCRM with 2 instances APACCRM1 & APACCRM2


# listener.ora.sis-test-db-1 Network Configuration File: D:\oracle\product\10.2.0\db_3\network\admin\listener.ora.sis-test-db-1
# Generated by Oracle configuration tools.

LISTENER_SIS-TEST-DB-1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = SIS-TEST-DB-1-vip.apu.edu)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.32.25)(PORT = 1521)(IP = FIRST))
)
)


here is the tnsnames.ora for APACCRM.

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_3\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENERS_APACCRM =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SIS-TEST-DB-1-vip.apu.edu)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = sis-test-db-2-vip.apu.edu)(PORT = 1521))
)

APACCRM2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sis-test-db-2-vip.apu.edu)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = APACCRM.apu.edu)
(INSTANCE_NAME = APACCRM2)
)
)

APACCRM1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SIS-TEST-DB-1-vip.apu.edu)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = APACCRM.apu.edu)
(INSTANCE_NAME = APACCRM1)
)
)

APACCRM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SIS-TEST-DB-1-vip.apu.edu)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = sis-test-db-2-vip.apu.edu)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = APACCRM.apu.edu)
)
)


Any suggession are greatly appreaciated.