Professional Web Applications Themes

Handling multiple database server instances - failover - Coldfusion Database Access

Hi all, I have a oracle tnsentry like this. It has multiple failover instances for the oracle database. TESTSID = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = srvr28a.test.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = srvr28b.test.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = srvr28c.test.com)(PORT = 1521)) (LOAD_BALANCE = yes) (FAILOVER = true) ) (CONNECT_DATA = (SERVICE_NAME = TESTSID) ) ) I dont know, how to configure this datasource to access from coldfusion admin. Please advise. Thanks, Amjath...

  1. #1

    Default Handling multiple database server instances - failover

    Hi all,

    I have a oracle tnsentry like this. It has multiple failover instances for the
    oracle database.

    TESTSID =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvr28a.test.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvr28b.test.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvr28c.test.com)(PORT = 1521))
    (LOAD_BALANCE = yes) (FAILOVER = true)
    )
    (CONNECT_DATA =
    (SERVICE_NAME = TESTSID)
    )
    )


    I dont know, how to configure this datasource to access from coldfusion admin.
    Please advise.

    Thanks,
    Amjath

    Amja Guest

  2. #2

    Default Re: Handling multiple database server instances -failover

    The problem here is if I want to create a dsn in coldfusion MX, it asks for SID and the server name. But here I have multiple servers how do I handle this while creating a DSN.

    Amja Guest

  3. #3

    Default Re: Handling multiple database server instances -failover

    Can't you create one name that represents the "cluster" to the outside world?
    We have MSSQL clusters that are accessed through a virtual name, that is, the
    server known as "public" doesn't really exist; it's a pointer to the cluster
    set. Yet all our apps think that "public" is a living, breathing SQL server.

    philh Guest

  4. #4

    Default Re: Handling multiple database server instances -failover

    Thanks phil.

    This is in oracle.
    I have resolved the issue., while creating the dsn, I gave the following
    information. I didnt select the oracle native driver, instead, I went to the
    'other drivers' section and gave the following information.

    CF Data Source Name : mycfdatasourcename
    JDBC URL : jdbc:oracle:thin:(DESCRIPTION = (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvr28a.test.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvr28b.test.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvr28c.test.com)(PORT = 1521))
    (LOAD_BALANCE = yes) (FAILOVER = true)
    )
    (CONNECT_DATA =
    (SERVICE_NAME = TESTSID)
    )
    )
    Driver Class : oracle.jdbc.OracleDriver
    Driver Name : Oracle Thin Driver
    username : myuser
    password : ???????
    Description : ANything




    Amja Guest

Similar Threads

  1. Blazeds server push and multiple flex instances
    By Solerous in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: April 8th, 02:58 PM
  2. ORIGIN Servers: Multiple, or Failover?
    By J-Chicago in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: May 3rd, 07:32 PM
  3. Different JVM Heap Size on Multiple Server Instances?
    By spikehenning in forum Coldfusion Server Administration
    Replies: 2
    Last Post: December 13th, 12:43 PM
  4. Draging multiple instances of multiple objects
    By equinox007 webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 2
    Last Post: January 23rd, 01:31 AM
  5. Multiple Instances of SQL Server 2000
    By Ian Henderson in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 10th, 02:49 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139