首页 > 解决方案 > 尝试连接到启用 TLS1.2 的 Oracle DB 时出现“ORA-28759:无法打开文件”

问题描述

我正在尝试连接到启用TLS1.2的Oracle DB。我正在使用godror 包(Go Driver for Oracle DB)。尝试连接时,我收到“ ORA-28759:打开文件失败”。请找到正在使用的附加代码片段:

package main

import (
    "database/sql"
    "log"
    "time"

    godror "github.com/godror/godror"
)


func main() {

    var P godror.ConnectionParams
    
    P.Username = <username>
    P.Password = godror.NewPassword("<password>")
    P.ConnectString = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=<hostname>)(PORT=<port>))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<service_name>)))"

    db := sql.OpenDB(godror.NewConnector(P))

    dberr := db.Ping()
    
    if dberr != nil {
        log.Printf("Oracle Database connection failed  %s", dberr)
    } else {
        log.Printf("Oracle Database connection established using existing password!")
    }
}

标签: go

解决方案


推荐阅读