一葫录、Linux 開發(fā)環(huán)境

• 環(huán)境

1. SLE12-SP1
2. go 1.8
3. git 2.10.0 能訪問 GitHub
4. gcc 4.8.5
5. pkg-config 0.28

• 安裝 Oracle Instant Client -- 從 Oracle 官網(wǎng) 下載 zip 包并解壓

unzip -ojd /usr/lib64  instantclient-basiclite-linux.x64-12.2.0.1.0.zip
ln -snf /usr/lib64/libclntsh.so.12.1 /usr/lib64/libclntsh.so
unzip -ojd /usr/include  instantclient-sdk-linux.x64-12.2.0.1.0.zip

• 下載 go-oci8 及依賴包

export GOPATH=/home/codes/go
git clone https://github.com/golang/net.git ${GOPATH}/src/golang.org/x/net
git clone https://github.com/mattn/go-oci8.git ${GOPATH}/src/github.com/mattn/go-oci8

• 示例代碼 sql.go

cat >sql.go <<\EOF
package main

import (
    "database/sql"
    "fmt"
    "log"
    "os"

    _ "github.com/mattn/go-oci8"
)

func main() {
    if len(os.Args) != 2 {
        log.Fatalln(os.Args[0] + " user/password@host:port/sid")
    }

    db, err := sql.Open("oci8", os.Args[1])
    if err != nil {
        log.Fatalln(err)
    }
    defer db.Close()

    rows, err := db.Query("select user from dual")
    if err != nil {
        log.Fatalln(err)
    }
    defer rows.Close()

    for rows.Next() {
        var data string
        rows.Scan(&data)
        fmt.Println(data)
    }
    if err = rows.Err(); err != nil {
        log.Fatalln(err)
    }
}
EOF

• 修改 pc 文件

sed -i -e "s|includedir=.*|includedir=/usr/include|" -e "s|libdir=.*|libdir=/usr/lib64|" \
${GOPATH}/src/github.com/mattn/go-oci8/oci8.pc

• 編譯

# export LD_LIBRARY_PATH=/usr/lib64  # -- 非必須
export PKG_CONFIG_PATH=${GOPATH}/src/github.com/mattn/go-oci8
go build -o sql sql.go

二拓哺、Linux 運(yùn)行環(huán)境

• 安裝依賴的動態(tài)鏈接庫

unzip -ojd /usr/lib64  instantclient-basiclite-linux.x64-12.2.0.1.0.zip  \
instantclient_12_2/libclntsh.so.12.1  instantclient_12_2/libclntshcore.so.12.1  \
instantclient_12_2/libipc1.so  instantclient_12_2/libmql1.so  \
instantclient_12_2/libnnz12.so  instantclient_12_2/libociicus.so  instantclient_12_2/libons.so

• 設(shè)置主機(jī)名楚昭，解決以下問題
  ORA-21561: OID generation failed (12.1.0.2.0)
  ORA-24454: client host name is not set (12.2.0.1.0)

echo "127.0.0.1 $(hostname)" >>/etc/hosts

• 運(yùn)行

./sql <username>/<password>@<IP>:<port>/<instance>

參考文檔

Go database/sql tutorial