ORA-12564: TNS connection refused when using BuildJDBC

[ColinLeeCampbell]

I'm currently facing an issue when trying to connect using BuildJDC function with the a orclNetDescString similar to the following: DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=host.com)(PORT=port))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=service))(SECURITY=(SSL_SERVER_CERT_DN="CN=cname,O=org,L=location")))

Using the following code

package main

import (
	"database/sql"
	"log"
	"path/filepath"

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

func main() {

	desc :=`DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=host.com)(PORT=port))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=service))(SECURITY=(SSL_SERVER_CERT_DN="CN=cname,O=org,L=location")))`

	username := "admin"
	password := "secret"

	walletPath, err := filepath.Abs("wallet")
	if err != nil {
		log.Fatal(err)
	}

	urlOptions := map[string]string{
		"TRACE FILE": "trace.log",
		"AUTH TYPE":  "TCPS",
		"SSL":        "TRUE",
		"SSL VERIFY": "FALSE",
		"WALLET":     walletPath,
	}
	connectString := go_ora.BuildJDBC(username, password, desc, urlOptions)
	db, err := sql.Open("oracle", connectString)
	if err != nil {
		log.Fatal(err)
	}

	err = db.Ping()
	if err != nil {
		log.Fatal(err)
	}

	log.Printf("Connected to Oracle: %s\n\n", connectString)
}

I am getting the ORA-12564: TNS connection refused error.

But when I create a connection string, using the values from the orclNetDescString, I'm able to connect successfully. Here's an example:

package main

import (
	"database/sql"
	"log"
	"path/filepath"

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

func main() {
	username := "admin"
	password := "secret"

	walletPath, err := filepath.Abs("wallet")
	if err != nil {
		log.Fatal(err)
	}

	connectString := fmt.Sprintf("oracle://%s:%s@%s:%s/%s?SSL=TRUE&SSL VERIFY=FALSE&AUTH TYPE=TCPS&WALLET=%s", username, password, "host.com", "port", "service", walletPath)
	db, err := sql.Open("oracle", connectString)
	if err != nil {
		log.Fatal(err)
	}

	err = db.Ping()
	if err != nil {
		log.Fatal(err)
	}

	log.Printf("Connected to Oracle: %s\n\n", connectString)
}

Any ideas as to what could be causing the ORA-12564: TNS connection refused error when only using BuildJDBC function?

[sijms]

hi @ColinLeeCampbell remove security section (SECURITY=(SSL_SERVER_CERT_DN="CN=cname,O=org,L=location") and test again

[ColinLeeCampbell]

@sijms - Is there any way we can look into allowing for the security section? It's needed to verify certs.

[sijms]

we will discuss this issue with #517

[sijms]

Custom configuration is supported in v2.8.12