search

gotsysdba / oracle-ords-operator

Oracle ORDS Operator for Kubernetes
Universal Permissive License v1.0
0 stars 0 forks source link

Missing credential in multi_pool.md #37

Closed mmalvezz closed 4 months ago

mmalvezz commented 4 months ago

I'm testing oracle-ords-operator/docs/examples/multi_pool.md The init_ords.sh scripts fails with the following error on pdb1 

Found Pool: pdb1...
db.password in pool pdb1, not defined
db.adminUser.password in pool pdb1, not defined
db.cdb.adminUser.password in pool pdb1, not defined
FATAL: db.password must be specified for pdb1
Pool: pdb1, Exit Code: 1

it seems that some credential is missing in the multi_pool.md example 

echo "
apiVersion: database.oracle.com/v1
kind: RestDataServices
metadata:
  name: ords-multi-pool
spec:
  image: container-registry.oracle.com/database/ords:23.4.0
  forceRestart: true
  globalSettings:
    database.api.enabled: true
  poolSettings:
    - poolName: pdb1
      autoUpgradeORDS: true
      autoUpgradeAPEX: true
      db.connectionType: tns
      db.tnsAliasName: DB1
      tnsAdminSecret:
        secretName: multi-tns-admin
      restEnabledSql.active: true
      feature.sdw: true
      plsql.gateway.mode: proxied
      db.username: ORDS_PUBLIC_USER
      db.secret:
        secretName: pdb1-ords-auth
      db.adminUser: SYS
      db.adminUser.secret:
        secretName: pdb1-priv-auth" | kubectl apply -f -
mmalvezz commented 4 months ago

There is nothing wrong with yaml file , I mistakenly forgot to set the environment running the init_script. I'm testing the above yaml using on premises database ; in my case, the init_script fails when we check adb. 

SQLERROR: 
Error starting at line : 9 in command -
                SELECT COUNT(*) FROM (
                        SELECT JSON_VALUE(cloud_identity, '$.DATABASE_OCID') AS database_ocid
                        FROM v$pdbs) t
                WHERE t.database_ocid like '%AUTONOMOUS%'
Error at Command Line : 10 Column : 22
Error report -
SQL Error: ORA-00904: "CLOUD_IDENTITY": invalid identifier
00904. 00000 -  "%s: invalid identifier"
*Cause:    The identifier or column name entered was invalid.
*Action:   Ensure the following
gotsysdba commented 4 months ago

Thanks, was just testing this and couldn't reproduce. However, I did catch the ORA-00904 on 23ai databases. Fix for that on its way up.

gotsysdba commented 4 months ago

v0.3.0 avail to resolve ORA-00904