go-ora
go-ora copied to clipboard
Published
20 hours ago •
sijms
sijms
connect to response: EOF
port ,_ := strconv.Atoi(os.Args[4]) connUrl := go_ora.BuildUrl(os.Args[3],port,os.Args[5],os.Args[1],os.Args[2],nil) db,err := sql.Open("oracle",connUrl) if err != nil { fmt.Printf("connect error:%s\n",err) return } defer func() {_=db.Close()}() err = db.Ping() if err != nil { fmt.Printf("ping connect error:%s\n",err) return } fmt.Println("connect success")
result: ping connect error:EOF
I need more information can you make a log file and see at what stage the connection stop
I encountered the same problem, db.Ping() returns &errors.errorString{s:"EOF"}. The fix was to import github.com/sijms/go-ora/v2 instead of github.com/sijms/go-ora. But if you are interested, here is the code and log file (enabled with the database url oracle://<username>:<password>@<host>:<port>/serviceName?SID=<sid>&TRACE FILE=trace.log).
package main
import (
"database/sql"
"fmt"
"log"
"net/url"
_ "github.com/sijms/go-ora" // use "github.com/sijms/go-ora/v2" instead
)
var (
username = "XXX"
password = "XXX"
host = "XXX.XX.XX.XXX"
sid = "XXX"
)
func main() {
log.SetFlags(log.Lshortfile)
databaseUrl := fmt.Sprintf("oracle://%s:%s@%s:1521/service_name?SID=%s&TRACE FILE=trace.log", url.PathEscape(username), url.PathEscape(password), host, url.QueryEscape(sid))
db, err := sql.Open("oracle", databaseUrl)
if err != nil {
log.Fatal(err)
}
err = db.Ping()
if err != nil {
log.Fatal(fmt.Sprintf("%#v", err))
}
defer db.Close()
}
$ go run .
main.go:32: &errors.errorString{s:"EOF"}
exit status 1
trace.log
2023-05-02T16:40:11.4570: Connect 2023-05-02T16:40:11.5222: using: XXX.XX.XX.XXX:1521 ..... [SUCCEED] 2023-05-02T16:40:11.5222: Open :(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XXX.XX.XX.XXX)(PORT=1521))(CONNECT_DATA=(SID=TDB)(CID=(PROGRAM=C:\Users\BOKWOO~1\AppData\Local\Temp\go-build3883301677\b001\exe\data-migration.exe)(HOST=SGPRLPF0TXU6B)(USER=bokwoonchua)))) 2023-05-02T16:40:11.5222: Write packet: 00000000 00 46 00 00 01 00 00 00 01 3d 01 2c 0c 01 ff ff |.F.......=.,....| 00000010 ff ff 4f 98 00 00 00 01 00 ea 00 46 00 00 00 00 |..O........F....| 00000020 01 01 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................| 00000030 00 00 00 00 00 00 00 00 00 00 00 20 00 00 00 20 |........... ... | 00000040 00 00 00 00 00 00 |......| 2023-05-02T16:40:11.5227: Write packet: 00000000 00 f4 00 00 06 00 00 00 00 00 28 44 45 53 43 52 |..........(DESCR| 00000010 49 50 54 49 4f 4e 3d 28 41 44 44 52 45 53 53 3d |IPTION=(ADDRESS=| 00000020 28 50 52 4f 54 4f 43 4f 4c 3d 74 63 70 29 28 48 |(PROTOCOL=tcp)(H| 00000030 4f 53 54 3d 31 37 32 2e 31 36 2e 32 39 2e 31 33 |OST=XXX.XX.XX.XX| 00000040 32 29 28 50 4f 52 54 3d 31 35 32 31 29 29 28 43 |X)(PORT=1521))(C| 00000050 4f 4e 4e 45 43 54 5f 44 41 54 41 3d 28 53 49 44 |ONNECT_DATA=(SID| 00000060 3d 54 44 42 29 28 43 49 44 3d 28 50 52 4f 47 52 |=TDB)(CID=(PROGR| 00000070 41 4d 3d 43 3a 5c 55 73 65 72 73 5c 42 4f 4b 57 |AM=C:\Users\BOKW| 00000080 4f 4f 7e 31 5c 41 70 70 44 61 74 61 5c 4c 6f 63 |OO~1\AppData\Loc| 00000090 61 6c 5c 54 65 6d 70 5c 67 6f 2d 62 75 69 6c 64 |al\Temp\go-build| 000000a0 33 38 38 33 33 30 31 36 37 37 5c 62 30 30 31 5c |3883301677\b001\| 000000b0 65 78 65 5c 76 69 6e 2d 64 61 74 61 2d 6d 69 67 |exe\vin-data-mig| 000000c0 72 61 74 69 6f 6e 2e 65 78 65 29 28 48 4f 53 54 |ration.exe)(HOST| 000000d0 3d 53 47 50 52 4c 50 46 30 54 58 55 36 42 29 28 |=SGPRLPF0TXU6B)(| 000000e0 55 53 45 52 3d 62 6f 6b 77 6f 6f 6e 63 68 75 61 |USER=bokwoonchua| 000000f0 29 29 29 29 |))))| 2023-05-02T16:40:11.5566: Read packet: 00000000 00 20 00 00 02 00 00 00 01 3a 0c 01 20 00 ff ff |. .......:.. ...| 00000010 01 00 00 00 00 20 41 01 00 00 00 00 00 00 00 00 |..... A.........| 2023-05-02T16:40:11.5566: Handshake Complete 2023-05-02T16:40:11.5566: Advance Negotiation 2023-05-02T16:40:11.5568: Write packet: 00000000 00 9d 00 00 06 00 00 00 00 00 de ad be ef 00 93 |................| 00000010 0b 20 02 00 00 04 00 00 04 00 03 00 00 00 00 00 |. ..............| 00000020 04 00 05 0b 20 02 00 00 08 00 01 00 00 10 1c 66 |.... ..........f| 00000030 ec 28 ea 00 12 00 01 de ad be ef 00 03 00 00 00 |.(..............| 00000040 04 00 04 00 01 00 02 00 03 00 01 00 03 00 00 00 |................| 00000050 00 00 04 00 05 0b 20 02 00 00 02 00 03 e0 e1 00 |...... .........| 00000060 02 00 06 fc ff 00 02 00 03 00 00 00 00 00 04 00 |................| 00000070 05 0b 20 02 00 00 05 00 01 00 02 0f 10 11 00 01 |.. .............| 00000080 00 02 01 00 03 00 02 00 00 00 00 00 04 00 05 0b |................| 00000090 20 02 00 00 06 00 01 00 01 03 04 05 06 | ............| 2023-05-02T16:40:11.5593: Read packet: 00000000 00 7f 00 00 06 00 00 00 00 00 de ad be ef 00 75 |...............u| 00000010 00 00 00 00 00 04 00 00 04 00 03 00 00 00 00 00 |................| 00000020 04 00 05 0b 20 03 00 00 02 00 06 00 1f 00 0e 00 |.... ...........| 00000030 01 de ad be ef 00 03 00 00 00 02 00 04 00 01 00 |................| 00000040 01 00 02 00 00 00 00 00 04 00 05 0b 20 03 00 00 |............ ...| 00000050 02 00 06 fb ff 00 02 00 02 00 00 00 00 00 04 00 |................| 00000060 05 0b 20 03 00 00 01 00 02 00 00 03 00 02 00 00 |.. .............| 00000070 00 00 00 04 00 05 0b 20 03 00 00 01 00 02 00 |....... .......| 2023-05-02T16:40:11.5603: TCP Negotiation 2023-05-02T16:40:11.5603: Write packet: 00000000 00 1c 00 00 06 00 00 00 00 00 01 06 00 4f 72 61 |.............Ora| 00000010 63 6c 65 43 6c 69 65 6e 74 47 6f 00 |cleClientGo.| 2023-05-02T16:40:11.5638: Read packet: 00000000 00 ee 00 00 06 00 00 00 00 00 01 06 00 78 38 36 |.............x86| 00000010 5f 36 34 2f 4c 69 6e 75 78 20 32 2e 34 2e 78 78 |_64/Linux 2.4.xx| 00000020 00 69 03 01 0a 00 66 03 40 03 01 40 03 66 03 01 |.i....f.@[email protected]..| 00000030 66 03 48 03 01 48 03 66 03 01 66 03 52 03 01 52 |f.H..H.f..f.R..R| 00000040 03 66 03 01 66 03 61 03 01 61 03 66 03 01 66 03 |.f..f.a..a.f..f.| 00000050 1f 03 08 1f 03 66 03 01 00 64 00 00 00 60 01 24 |.....f...d...`.$| 00000060 0f 05 0b 0c 03 0c 0c 05 04 05 0d 06 09 07 08 05 |................| 00000070 05 05 05 05 0f 05 05 05 05 05 0a 05 05 05 05 05 |................| 00000080 04 05 06 07 08 08 23 47 23 47 08 11 23 08 11 41 |......#G#G..#..A| 00000090 b0 47 00 83 03 69 07 d0 03 00 00 00 00 00 00 00 |.G...i..........| 000000a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................| 000000b0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 27 06 |..............'.| 000000c0 01 01 01 0f 01 01 06 01 01 01 01 01 01 01 7f ff |................| 000000d0 03 0a 03 03 01 00 7f 01 7f ff 01 07 01 01 3f 01 |..............?.| 000000e0 04 06 00 01 07 03 07 02 01 00 01 18 00 03 |..............| 2023-05-02T16:40:11.5648: Server Charset: 873 2023-05-02T16:40:11.5648: Server National Charset: 2000 2023-05-02T16:40:11.5648: Data Type Negotiation 2023-05-02T16:40:11.5648: Write packet: 00000000 0a 65 00 00 06 00 00 00 00 00 02 69 03 69 03 03 |.e.........i.i..| 00000010 29 06 01 00 00 4a 01 01 0c 01 01 01 01 01 01 00 |)....J..........| 00000020 29 90 03 07 03 00 01 00 4f 01 37 04 01 00 00 00 |).......O.7.....| 00000030 1c 00 00 0a a0 00 b3 00 0f 06 07 02 01 00 00 00 |................| 00000040 00 02 80 00 00 00 44 3c 3c 80 00 00 00 00 00 00 |......D.>.| 000001c0 01 00 00 01 3f 01 3f 00 01 00 00 01 40 01 40 00 |....?.?.....@.@.| 000001d0 01 00 00 01 41 01 41 00 01 00 00 01 42 01 42 00 |....A.A.....B.B.| 000001e0 01 00 00 01 43 01 43 00 01 00 00 01 47 01 47 00 |....C.C.....G.G.| 000001f0 01 00 00 01 48 01 48 00 01 00 00 01 49 01 49 00 |....H.H.....I.I.| 00000200 01 00 00 01 4b 01 4b 00 01 00 00 01 4d 01 4d 00 |....K.K.....M.M.| 00000210 01 00 00 01 4e 01 4e 00 01 00 00 01 4f 01 4f 00 |....N.N.....O.O.| 00000220 01 00 00 01 50 01 50 00 01 00 00 01 51 01 51 00 |....P.P.....Q.Q.| 00000230 01 00 00 01 52 01 52 00 01 00 00 01 53 01 53 00 |....R.R.....S.S.| 00000240 01 00 00 01 54 01 54 00 01 00 00 01 55 01 55 00 |....T.T.....U.U.| 00000250 01 00 00 01 56 01 56 00 01 00 00 01 57 01 57 00 |....V.V.....W.W.| 00000260 01 00 00 01 58 01 58 00 01 00 00 01 59 01 59 00 |....X.X.....Y.Y.| 00000270 01 00 00 01 5a 01 5a 00 01 00 00 01 5c 01 5c 00 |....Z.Z.....\.\.| 00000280 01 00 00 01 5d 01 5d 00 01 00 00 01 62 01 62 00 |....].].....b.b.| 00000290 01 00 00 01 63 01 63 00 01 00 00 01 67 01 67 00 |....c.c.....g.g.| 000002a0 01 00 00 01 6b 01 6b 00 01 00 00 01 7c 01 7c 00 |....k.k.....|.|.| 000002b0 01 00 00 01 7d 01 7d 00 01 00 00 01 7e 01 7e 00 |....}.}.....~.~.| 000002c0 01 00 00 01 7f 01 7f 00 01 00 00 01 80 01 80 00 |................| 000002d0 01 00 00 01 81 01 81 00 01 00 00 01 82 01 82 00 |................| 000002e0 01 00 00 01 83 01 83 00 01 00 00 01 84 01 84 00 |................| 000002f0 01 00 00 01 85 01 85 00 01 00 00 01 86 01 86 00 |................| 00000300 01 00 00 01 87 01 87 00 01 00 00 01 89 01 89 00 |................| 00000310 01 00 00 01 8a 01 8a 00 01 00 00 01 8b 01 8b 00 |................| 00000320 01 00 00 01 8c 01 8c 00 01 00 00 01 8d 01 8d 00 |................| 00000330 01 00 00 01 8e 01 8e 00 01 00 00 01 8f 01 8f 00 |................| 00000340 01 00 00 01 90 01 90 00 01 00 00 01 91 01 91 00 |................| 00000350 01 00 00 01 94 01 94 00 01 00 00 01 95 01 95 00 |................| 00000360 01 00 00 01 96 01 96 00 01 00 00 01 97 01 97 00 |................| 00000370 01 00 00 01 9d 01 9d 00 01 00 00 01 9e 01 9e 00 |................| 00000380 01 00 00 01 9f 01 9f 00 01 00 00 01 a0 01 a0 00 |................| 00000390 01 00 00 01 a1 01 a1 00 01 00 00 01 a2 01 a2 00 |................| 000003a0 01 00 00 01 a3 01 a3 00 01 00 00 01 a4 01 a4 00 |................| 000003b0 01 00 00 01 a5 01 a5 00 01 00 00 01 a6 01 a6 00 |................| 000003c0 01 00 00 01 a7 01 a7 00 01 00 00 01 a8 01 a8 00 |................| 000003d0 01 00 00 01 a9 01 a9 00 01 00 00 01 aa 01 aa 00 |................| 000003e0 01 00 00 01 ab 01 ab 00 01 00 00 01 ad 01 ad 00 |................| 000003f0 01 00 00 01 ae 01 ae 00 01 00 00 01 af 01 af 00 |................| 00000400 01 00 00 01 b0 01 b0 00 01 00 00 01 b1 01 b1 00 |................| 00000410 01 00 00 01 c1 01 c1 00 01 00 00 01 c2 01 c2 00 |................| 00000420 01 00 00 01 c6 01 c6 00 01 00 00 01 c7 01 c7 00 |................| 00000430 01 00 00 01 c8 01 c8 00 01 00 00 01 c9 01 c9 00 |................| 00000440 01 00 00 01 ca 01 ca 00 01 00 00 01 cb 01 cb 00 |................| 00000450 01 00 00 01 cc 01 cc 00 01 00 00 01 cd 01 cd 00 |................| 00000460 01 00 00 01 ce 01 ce 00 01 00 00 01 cf 01 cf 00 |................| 00000470 01 00 00 01 d2 01 d2 00 01 00 00 01 d3 01 d3 00 |................| 00000480 01 00 00 01 d4 01 d4 00 01 00 00 01 d5 01 d5 00 |................| 00000490 01 00 00 01 d6 01 d6 00 01 00 00 01 d7 01 d7 00 |................| 000004a0 01 00 00 01 d8 01 d8 00 01 00 00 01 d9 01 d9 00 |................| 000004b0 01 00 00 01 da 01 da 00 01 00 00 01 db 01 db 00 |................| 000004c0 01 00 00 01 dc 01 dc 00 01 00 00 01 dd 01 dd 00 |................| 000004d0 01 00 00 01 de 01 de 00 01 00 00 01 df 01 df 00 |................| 000004e0 01 00 00 01 e0 01 e0 00 01 00 00 01 e1 01 e1 00 |................| 000004f0 01 00 00 01 e2 01 e2 00 01 00 00 01 e3 01 e3 00 |................| 00000500 01 00 00 01 e4 01 e4 00 01 00 00 01 e5 01 e5 00 |................| 00000510 01 00 00 01 e6 01 e6 00 01 00 00 01 ea 01 ea 00 |................| 00000520 01 00 00 01 eb 01 eb 00 01 00 00 01 ec 01 ec 00 |................| 00000530 01 00 00 01 ed 01 ed 00 01 00 00 01 ee 01 ee 00 |................| 00000540 01 00 00 01 ef 01 ef 00 01 00 00 01 f0 01 f0 00 |................| 00000550 01 00 00 01 f2 01 f2 00 01 00 00 01 f3 01 f3 00 |................| 00000560 01 00 00 01 f4 01 f4 00 01 00 00 01 f5 01 f5 00 |................| 00000570 01 00 00 01 f6 01 f6 00 01 00 00 01 fd 01 fd 00 |................| 00000580 01 00 00 01 fe 01 fe 00 01 00 00 02 01 02 01 00 |................| 00000590 01 00 00 02 02 02 02 00 01 00 00 02 04 02 04 00 |................| 000005a0 01 00 00 02 05 02 05 00 01 00 00 02 06 02 06 00 |................| 000005b0 01 00 00 02 07 02 07 00 01 00 00 02 08 02 08 00 |................| 000005c0 01 00 00 02 09 02 09 00 01 00 00 02 0a 02 0a 00 |................| 000005d0 01 00 00 02 0b 02 0b 00 01 00 00 02 0c 02 0c 00 |................| 000005e0 01 00 00 02 0d 02 0d 00 01 00 00 02 0e 02 0e 00 |................| 000005f0 01 00 00 02 0f 02 0f 00 01 00 00 02 10 02 10 00 |................| 00000600 01 00 00 02 11 02 11 00 01 00 00 02 12 02 12 00 |................| 00000610 01 00 00 02 13 02 13 00 01 00 00 02 14 02 14 00 |................| 00000620 01 00 00 02 15 02 15 00 01 00 00 02 16 02 16 00 |................| 00000630 01 00 00 02 17 02 17 00 01 00 00 02 18 02 18 00 |................| 00000640 01 00 00 02 19 02 19 00 01 00 00 02 1a 02 1a 00 |................| 00000650 01 00 00 02 1b 02 1b 00 01 00 00 02 1c 02 1c 00 |................| 00000660 01 00 00 02 1d 02 1d 00 01 00 00 02 1e 02 1e 00 |................| 00000670 01 00 00 02 1f 02 1f 00 01 00 00 02 30 02 30 00 |............0.0.| 00000680 01 00 00 02 35 02 35 00 01 00 00 02 3c 02 3c 00 |....5.5.....<.>.>.| 000006a0 01 00 00 02 3f 02 3f 00 01 00 00 02 40 02 40 00 |....?.?.....@.@.| 000006b0 01 00 00 02 42 02 42 00 01 00 00 02 33 02 33 00 |....B.B.....3.3.| 000006c0 01 00 00 02 34 02 34 00 01 00 00 02 43 02 43 00 |....4.4.....C.C.| 000006d0 01 00 00 02 44 02 44 00 01 00 00 02 45 02 45 00 |....D.D.....E.E.| 000006e0 01 00 00 02 46 02 46 00 01 00 00 02 47 02 47 00 |....F.F.....G.G.| 000006f0 01 00 00 02 48 02 48 00 01 00 00 02 49 02 49 00 |....H.H.....I.I.| 00000700 01 00 00 00 03 00 02 00 0a 00 00 00 04 00 02 00 |................| 00000710 0a 00 00 00 05 00 01 00 01 00 00 00 06 00 02 00 |................| 00000720 0a 00 00 00 07 00 02 00 0a 00 00 00 09 00 01 00 |................| 00000730 01 00 00 00 0d 00 00 00 0e 00 00 00 0f 00 17 00 |................| 00000740 01 00 00 00 10 00 00 00 11 00 00 00 12 00 00 00 |................| 00000750 13 00 00 00 14 00 00 00 15 00 00 00 16 00 00 00 |................| 00000760 27 00 78 00 01 00 00 00 3a 00 00 00 44 00 02 00 |'.x.....:...D...| 00000770 0a 00 00 00 45 00 00 00 46 00 00 00 4a 00 00 00 |....E...F...J...| 00000780 4c 00 00 00 5b 00 02 00 0a 00 00 00 5e 00 01 00 |L...[.......^...| 00000790 01 00 00 00 5f 00 17 00 01 00 00 00 60 00 60 00 |...._.......`.`.| 000007a0 01 00 00 00 61 00 60 00 01 00 00 00 64 00 64 00 |....a.`.....d.d.| 000007b0 01 00 00 00 65 00 65 00 01 00 00 00 66 00 66 00 |....e.e.....f.f.| 000007c0 01 00 00 00 68 00 0b 00 01 00 00 00 69 00 00 00 |....h.......i...| 000007d0 6a 00 6a 00 01 00 00 00 6c 00 6d 00 01 00 00 00 |j.j.....l.m.....| 000007e0 6d 00 6d 00 01 00 00 00 6e 00 6f 00 01 00 00 00 |m.m.....n.o.....| 000007f0 6f 00 6f 00 01 00 00 00 70 00 70 00 01 00 00 00 |o.o.....p.p.....| 00000800 71 00 71 00 01 00 00 00 72 00 72 00 01 00 00 00 |q.q.....r.r.....| 00000810 73 00 73 00 01 00 00 00 74 00 66 00 01 00 00 00 |s.s.....t.f.....| 00000820 76 00 00 00 77 00 00 00 79 00 00 00 7a 00 00 00 |v...w...y...z...| 00000830 7b 00 00 00 88 00 00 00 92 00 92 00 01 00 00 00 |{...............| 00000840 93 00 00 00 98 00 02 00 0a 00 00 00 99 00 02 00 |................| 00000850 0a 00 00 00 9a 00 02 00 0a 00 00 00 9b 00 01 00 |................| 00000860 01 00 00 00 9c 00 0c 00 0a 00 00 00 ac 00 02 00 |................| 00000870 0a 00 00 00 b2 00 b2 00 01 00 00 00 b3 00 b3 00 |................| 00000880 01 00 00 00 b4 00 b4 00 01 00 00 00 b5 00 b5 00 |................| 00000890 01 00 00 00 b6 00 b6 00 01 00 00 00 b7 00 b7 00 |................| 000008a0 01 00 00 00 b8 00 0c 00 0a 00 00 00 b9 00 b9 00 |................| 000008b0 01 00 00 00 ba 00 ba 00 01 00 00 00 bb 00 bb 00 |................| 000008c0 01 00 00 00 bc 00 bc 00 01 00 00 00 bd 00 bd 00 |................| 000008d0 01 00 00 00 be 00 be 00 01 00 00 00 bf 00 00 00 |................| 000008e0 c0 00 00 00 c3 00 70 00 01 00 00 00 c4 00 71 00 |......p.......q.| 000008f0 01 00 00 00 c5 00 72 00 01 00 00 00 d0 00 d0 00 |......r.........| 00000900 01 00 00 00 d1 00 00 00 e7 00 e7 00 01 00 00 00 |................| 00000910 e8 00 e7 00 01 00 00 00 e9 00 e9 00 01 00 00 00 |................| 00000920 fc 00 fc 00 00 00 00 00 f1 00 6d 00 01 00 00 02 |..........m.....| 00000930 03 00 00 02 4e 02 4e 00 01 00 00 02 4f 02 4f 00 |....N.N.....O.O.| 00000940 01 00 00 02 50 02 50 00 01 00 00 02 65 02 65 00 |....P.P.....e.e.| 00000950 01 00 00 02 66 02 66 00 01 00 00 02 67 02 67 00 |....f.f.....g.g.| 00000960 01 00 00 02 68 02 68 00 01 00 00 02 63 02 63 00 |....h.h.....c.c.| 00000970 01 00 00 02 64 02 64 00 01 00 00 02 51 02 51 00 |....d.d.....Q.Q.| 00000980 01 00 00 02 52 02 52 00 01 00 00 02 53 02 53 00 |....R.R.....S.S.| 00000990 01 00 00 02 54 02 54 00 01 00 00 02 55 02 55 00 |....T.T.....U.U.| 000009a0 01 00 00 02 56 02 56 00 01 00 00 02 57 02 57 00 |....V.V.....W.W.| 000009b0 01 00 00 02 58 02 58 00 01 00 00 02 59 02 59 00 |....X.X.....Y.Y.| 000009c0 01 00 00 02 5a 02 5a 00 01 00 00 02 5b 02 5b 00 |....Z.Z.....[.[.| 000009d0 01 00 00 02 5c 02 5c 00 01 00 00 02 5d 02 5d 00 |....\.\.....].].| 000009e0 01 00 00 02 6e 02 6e 00 01 00 00 02 6f 02 6f 00 |....n.n.....o.o.| 000009f0 01 00 00 02 70 02 70 00 01 00 00 02 71 02 71 00 |....p.p.....q.q.| 00000a00 01 00 00 02 72 02 72 00 01 00 00 02 73 02 73 00 |....r.r.....s.s.| 00000a10 01 00 00 02 74 02 74 00 01 00 00 02 75 02 75 00 |....t.t.....u.u.| 00000a20 01 00 00 02 76 02 76 00 01 00 00 02 77 02 77 00 |....v.v.....w.w.| 00000a30 01 00 00 02 78 02 78 00 01 00 00 02 7d 02 7d 00 |....x.x.....}.}.| 00000a40 01 00 00 02 7e 02 7e 00 01 00 00 02 7c 02 7c 00 |....~.~.....|.|.| 00000a50 01 00 00 02 7f 02 7f 00 01 00 00 02 80 02 80 00 |................| 00000a60 01 00 00 00 00 |.....|
Hi @bokwoon95 you code is ok but you can use
urlOptions := map[string] string {
"trace file": "trace.log",
}
go_ora.BuildUrl(server, port, service, user, password, urlOptions)
v1 is use for connection with oracle 9 otherwise use v2