golang oracle安装教程

golang oracle 安装教程win

1.使用的是

go get github.com/godror/godror

连接代码

type Oracle struct {
	User     string
	PassWord string
	Host     string
	Port     string
	DataBase string
}

func setOracle(ip, usr, pwd string) *Oracle {
	return &Oracle{
		User:     usr,
		PassWord: pwd,
		Host:     ip,
		Port:     "1521",
		DataBase: "",
	}
}

func (o *Oracle) String() string {
	return fmt.Sprintf("%s:%s@(%s:%s)/%s", o.User, o.PassWord, o.Host, o.Port, o.DataBase)
}

func (o *Oracle) BlastOracle() bool {
	str := o.String()
	db, err := sql.Open("godror",str)
	if err != nil{
		fmt.Println(err)
		return false
	}
	defer db.Close()
	err = db.Ping()
	if err != nil {
		fmt.Println("Oracle err:",err)
		return false
	}
	return true
}

连接中可能需要以下要求

1.报错:

exec: "gcc": executable file not found in %PATH%

需要安装gcc :(我下载的是 x86_64-8.1.0-release-posix-sjlj-rt_v6-rev0.7z),下载解压后,将安装位置到bin的路径添加到pash环境变量

链接:https://sourceforge.net/projects/mingw-w64/

2.报错:

DPI-1047: Cannot locate a 64-bit Oracle Client library: "The specified module could not be found". See https://oracle.github.io/odpi/doc/installation.html#windows for help

oracle本地客户端:(我下载的是 instantclient-basic-windows.x64-21.11.0.0.0dbru),下载解压后将安装位置可以看到运行文件.exe的路径添加到pash环境变量

链接:https://www.oracle.com/cn/database/technologies/instant-client/winx64-64-downloads.html

完结 撒花!!!