Deleting database in 10g 2 node RAC Cluster ---using DBCA
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Feb 2008
    Location
    California
    Posts
    10

    Unhappy 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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    yes

  3. #3
    Join Date
    Feb 2008
    Location
    California
    Posts
    10

    Listener error

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width