oracle / oracle-database-operator

The Oracle Database Operator for Kubernetes (a.k.a. OraOperator) helps developers, DBAs, DevOps and GitOps teams reduce the time and complexity of deploying and managing Oracle Databases. It eliminates the dependency on a human operator or administrator for the majority of database operations.
Universal Permissive License v1.0
141 stars 45 forks source link

SIDB instance is not created when running in k8s cluster with IPV6 addresses #72

Open sankarpn opened 1 year ago

sankarpn commented 1 year ago

The DB operator creates a SIDB pod but the the PDB is not available for connections.

`[speriyat@speriyat-1 speriyat]$ kubectl get singleinstancedatabase -n ns-visgtc my-oracle-sidb -o "jsonpath={.status.pdbConnectString}" fc00:f853:ccd:e793::2:30361/ORCLPDB1

[speriyat@speriyat-1 speriyat]$ kubectl exec -it -n ns-visgtc pod/my-oracle-sidb-t9bwa bash

Defaulted container "my-oracle-sidb" out of: my-oracle-sidb, init-permissions (init), init-wallet (init)

[oracle@my-oracle-sidb-t9bwa ~]$ sqlplus

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 1 03:26:13 2023 Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Enter user-name: sys as sysdba Enter password:

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0

SQL> connect sys/Oradoc_db1@[fc00:f853:ccd:e793::2]:30361/ORCLPDB1 as sysdba ERROR: ORA-12541: TNS:no listener

Warning: You are no longer connected to ORACLE.`