We need to update tnsname.ora during deployment.
We have active/standby deployment with dataguard. We don't see any option to create configmap for this, even if we create configmap during deployment oraoperator will try to update then....
sample tnsnames.ora:
[oracle@site2-db-1-ffn8o PSMF]$ cat /opt/oracle/oradata/dbconfig/PSMF/tnsnames.ora
PSMF=localhost:1521/PSMF
PSMFPDB1=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PSMFPDB1)
)
)
PSMF.world =
(DESCRIPTION = (SDU=32120)
(ADDRESS =(PROTOCOL = TCP)(Host = "local/Self Oracle DB")(Port = 1521) )
(CONNECT_DATA = (SERVICE_NAME = PSMFPDB1) )
)
SITE1.world =
(DESCRIPTION = (SDU=32120)
(ADDRESS =(PROTOCOL = TCP)(Host = SITE1-DB)(Port = 1521) )
(CONNECT_DATA = (SERVICE_NAME = PSMFPDB1) )
)
SITE2.world =
(DESCRIPTION = (SDU=32120)
(ADDRESS =(PROTOCOL = TCP)(Host = SITE2-DB)(Port = 1521) )
(CONNECT_DATA = (SERVICE_NAME = PSMFPDB1) )
)
SITE3.world =
(DESCRIPTION = (SDU=32120)
(ADDRESS =(PROTOCOL = TCP)(Host = SITE3-DB)(Port = 1521) )
(CONNECT_DATA = (SERVICE_NAME = PSMFPDB1) )
)
SITE4.world =
(DESCRIPTION = (SDU=32120)
(ADDRESS =(PROTOCOL = TCP)(Host = SITE4-DB)(Port = 1521) )
(CONNECT_DATA = (SERVICE_NAME = PSMFPDB1) )
)
We need to update tnsname.ora during deployment.
We have active/standby deployment with dataguard. We don't see any option to create configmap for this, even if we create configmap during deployment oraoperator will try to update then....
sample tnsnames.ora:
[oracle@site2-db-1-ffn8o PSMF]$ cat /opt/oracle/oradata/dbconfig/PSMF/tnsnames.ora
PSMF=localhost:1521/PSMF
PSMFPDB1=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PSMFPDB1)
)
)
PSMF.world =
(DESCRIPTION = (SDU=32120)
(ADDRESS =(PROTOCOL = TCP)(Host = "local/Self Oracle DB")(Port = 1521) )
(CONNECT_DATA = (SERVICE_NAME = PSMFPDB1) )
)
SITE1.world =
(DESCRIPTION = (SDU=32120)
(ADDRESS =(PROTOCOL = TCP)(Host = SITE1-DB)(Port = 1521) )
(CONNECT_DATA = (SERVICE_NAME = PSMFPDB1) )
)
SITE2.world =
(DESCRIPTION = (SDU=32120)
(ADDRESS =(PROTOCOL = TCP)(Host = SITE2-DB)(Port = 1521) )
(CONNECT_DATA = (SERVICE_NAME = PSMFPDB1) )
)
SITE3.world =
(DESCRIPTION = (SDU=32120)
(ADDRESS =(PROTOCOL = TCP)(Host = SITE3-DB)(Port = 1521) )
(CONNECT_DATA = (SERVICE_NAME = PSMFPDB1) )
)
SITE4.world =
(DESCRIPTION = (SDU=32120)
(ADDRESS =(PROTOCOL = TCP)(Host = SITE4-DB)(Port = 1521) )
(CONNECT_DATA = (SERVICE_NAME = PSMFPDB1) )
)