Client Side Connectivity

Once a database/PDB is created, database connectivity can be tested with any of the client side tools. For example, using SQL*Plus:

sqlplus <Database.Spec.Users.Name>/<Database.Spec.Users.Password>@<Instance.Status.URL>/<Database.Spec.Name>.<Instance.Spec.DbDomain>

In practice, this could look like the following:

sqlplus scott/tiger@ip-address:6021/pdb1.gke

We currently don't allow changing a listener port. Use port-forwarding if you need to use a port other than the default. For example:

kubectl port-forward svc/mydb-svc 1521:6021 -n db
Forwarding from 127.0.0.1:1521 -> 6021
Forwarding from [::1]:1521 -> 6021
Handling connection for 1521

You can then connect to port 1521 (or any port of a customer choice) using localhost:

sqlplus scott/tiger@localhost:1521/pdb1.gke