oracle数据库通过域名链接

Love The Way You Lie 2022-10-24 15:25 267阅读 0赞

### 背景 ###

今日收到通知，由于数据库服务器已经运行5年了，需要对数据库服务器进行升级，早期的应用是使用ip:port直接链接数据库的。本次的升级是更换这个数据库集群的机器，机器的IP也会发生变化，为了应对之后可能发生的数据库升级事情，计划使用域名链接数据库，在使用域名之前，尚不得知oracle数据库是否支持因此做了一下测试

### 环境准备 ###

我是在本地环境做的测试  
第一步修改hosts文件内容

# Copyright (c) 1993-2009 Microsoft Corp.
    #
    # This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
    #
    # This file contains the mappings of IP addresses to host names. Each
    # entry should be kept on an individual line. The IP address should
    # be placed in the first column followed by the corresponding host name.
    # The IP address and the host name should be separated by at least one
    # space.
    #
    # Additionally, comments (such as these) may be inserted on individual
    # lines or following the machine name denoted by a '#' symbol.
    #
    # For example:
    #
    #      102.54.94.97     rhino.acme.com          # source server
    #       38.25.63.10     x.acme.com              # x client host
    
    # localhost name resolution is handled within DNS itself.
    #	127.0.0.1       localhost
    #	::1             localhost
    10.0.254.154 www.test-oracle.com

新增一行解析记录

10.0.254.154 www.test-oracle.com

这里修改之后然后在测试一下域名解析配置是否生效

C:\Users\pc>ping www.test-oracle.com
    
    正在 Ping www.test-oracle.com [10.0.254.154] 具有 32 字节的数据:
    来自 10.0.254.154 的回复: 字节=32 时间=38ms TTL=62
    来自 10.0.254.154 的回复: 字节=32 时间=36ms TTL=62
    
    10.0.254.154 的 Ping 统计信息:
        数据包: 已发送 = 2，已接收 = 2，丢失 = 0 (0% 丢失)，
    往返行程的估计时间(以毫秒为单位):
        最短 = 36ms，最长 = 38ms，平均 = 37ms

这里看到也生效了  
接下来编写java代码使用jdbc链接数据库，并执行查询

import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    public class OracleTest { 
    
    	public static void main(String[] args) throws ClassNotFoundException, SQLException { 
    		
    		String url="jdbc:oracle:thin:@www.test-oracle.com:1521/orcl";
    		String user="t_order";
    		String password="gweltGfkjwHrg3ewt&";
    
    		Class.forName("oracle.jdbc.driver.OracleDriver");
    		Connection connection = DriverManager.getConnection(url, user, password);
    		
    		Statement createStatement = connection.createStatement();
    		String sql = "select count(1) from t_order";
    		
    		ResultSet executeQuery = createStatement.executeQuery(sql);
    		
    		while (executeQuery.next()) { 
    			int count = executeQuery.getInt(1);
    			System.out.println("订单总记录数为：" +count );	
    		}	
    	}
    }

控制台输出结果为  
![在这里插入图片描述][20210130093608633.png]  
到此测试完毕，域名链接oracle数据库可用

[20210130093608633.png]: /images/20221024/fd7bf5aa265d475196293322694a73fb.png