golang 连接oracle的两种方式(服务名和Sid）

1、引入驱动

go_ora "github.com/sijms/go-ora/v2"

2、服务名连接方式

    conn, err := go_ora.NewConnection(fmt.Sprintf("oracle://%s:%s@%s:%d/%s", "system", "123456", "172.16.107.34", 1521, "oracle11"))
    if err != nil {
        log.Println("[数据库连接失败]:", err)
        return
    }
    err = conn.Open()
    if err != nil {
        log.Println("[数据库连接失败]:", err)
        return
    }
    defer conn.Close()
    if conn == nil {
        log.Println("connect failure")
        return
    }
    ctx, cancel := context.WithTimeout(context.Background(), time.Second*5)
    defer cancel()
    err = conn.Ping(ctx)
    if err != nil {
        log.Println("connect failure 2")
        return
    }
    log.Println("success")

3、Sid方式连接

    conn, err := go_ora.NewConnection(fmt.Sprintf("oracle://%s:%s@%s:%d?SID=%s", "system", "12345689", "192.168.10.34", 1521, "orcl"))
    if err != nil {
        log.Println("[数据库连接失败]:", err)
        return
    }
    err = conn.Open()
    if err != nil {
        log.Println("[数据库连接失败]:", err)
        return
    }
    defer conn.Close()
    if conn == nil {
        log.Println("connect failure")
        return
    }
    ctx, cancel := context.WithTimeout(context.Background(), time.Second*5)
    defer cancel()
    err = conn.Ping(ctx)
    if err != nil {
        log.Println("connect failure 2")
        return
    }
    log.Println("success")