美文网首页Database OperationJavaThe Sca...
Oracle集群/非集群JDBC驱动格式

Oracle集群/非集群JDBC驱动格式

作者: 雨笋情缘 | 来源:发表于2018-12-14 09:16 被阅读3次

    1. Oracle非集群url配置

           非集群中java连接的url

      url=jdbc:oracle:thin:@127.0.0.1:1521:bester

    2. Oracle集群中url配置

         (1)Oracle集群中plsql连接配置:

      db_1_2 = ( DESCRIPTION = 

                ( ADDRESS = (PROTOCOL = TCP)(HOST = 59.208.39.193)(PORT = 1521) )

                ( ADDRESS = (PROTOCOL = TCP)(HOST = 59.208.39.195)(PORT = 1521) )

                (LOAD_BALANCE=yes)

                (CONNECT_DATA =

                            (SERVICE_NAME = bester)

                 )

               )

          (2)Oracle集群中java程序连接的url

    datasource.url = jdbc:oracle:thin:@( DESCRIPTION =

        (ADDRESS = (PROTOCOL = TCP)(HOST =59.208.39.193)(PORT = 1521))

        (ADDRESS = (PROTOCOL = TCP)(HOST =59.208.39.195)(PORT = 1521))

        (LOAD_BALANCE=yes)

        (CONNECT_DATA  = (SERVICE_NAME = bester))

    )

    转自:https://blog.csdn.net/xiaomin1991222/article/details/50979584

    相关文章

      网友评论

        本文标题:Oracle集群/非集群JDBC驱动格式

        本文链接:https://www.haomeiwen.com/subject/eerwhqtx.html