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.