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

[pkata]

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.

[davey23uk]

yes

[pkata]

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.