Hi everyone! Hope you can give me the right kickstart to finish my dataguard (test-)environment in a non critical environment.
First, my configuration:
Server: DBATEST001
DB_NAME: DBAT
UNIQUE_NAME: DBAT1
SID/Instance: DBAT
Server: DBATEST002
DB_NAME: DBAT
UNIQUE_NAME: DBAT1_STBY
SID/Instance: DBAT
Both are connected flawless to eachother. I've already made an dataguard configuration “MY_DG”:
Welcome to DGMGRL, type "help" for information.
Connected to "DBAT1"
Connected as SYSDBA.
DGMGRL> **validate network configuration for all**
Connecting to instance "DBAT" on database "DBAT1" ...
Connected to "DBAT1"
Checking connectivity from instance "DBAT" on database "DBAT1 to instance "DBAT" on database "dbat1_stby"...
**Succeeded**.
Connecting to instance "DBAT" on database "dbat1_stby" ...
Connected to "DBAT1_STBY"
Checking connectivity from instance "DBAT" on database "dbat1_stby to instance "DBAT" on database "DBAT1"...
**Succeeded**.
Oracle Clusterware is not configured on database "DBAT1".
Connecting to database "DBAT1" using static connect identifier "(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER))(CONNECT_DATA=(SERVICE_NAME=DBAT1_DGMGRL)(INSTANCE_NAME=DBAT)(SERVER=DEDICATED)(STATIC_SERVICE=TRUE)))" ...
**Succeeded**.
**The static connect identifier allows for a connection to database "DBAT1".**
Oracle Clusterware is not configured on database "dbat1_stby".
Connecting to database "dbat1_stby" using static connect identifier "(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER))(CONNECT_DATA=(SERVICE_NAME=DBAT1_STBY_DGMGRL)(INSTANCE_NAME=DBAT)(SERVER=DEDICATED)(STATIC_SERVICE=TRUE)))" ...
Unable to connect to database using (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER))(CONNECT_DATA=(SERVICE_NAME=DBAT1_STBY_DGMGRL)(INSTANCE_NAME=DBAT)(SERVER=DEDICATED)(STATIC_SERVICE=TRUE)))
**ORA-12514: TNS:listener does not currently know of service requested in connect descriptor**
That are my TNSNAMES and LISTENER.ORA
Primary:
$ cat listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbatest001tXXXXXXXXX)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = REGISTER))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DBAT1_DGMGRL)
(SID_NAME = DBAT)
(ORACLE_HOME = /oracle/product/19c))
(SID_DESC =
(GLOBAL_DBNAME = DBAT1)
(ORACLE_HOME=/oracle/product/19c)
(SID_NAME = DBAT))
)
STANDBY:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbatest002t)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = REGISTER))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DBAT1_STBY_DGMGRL)
(SID_NAME = DBAT)
(ORACLE_HOME = /oracle/product/19c))
(SID_DESC =
(GLOBAL_DBNAME = DBAT1_STBY)
(ORACLE_HOME=/oracle/product/19c)
(SID_NAME = DBAT))
)
TNSNAMES PRIMARY:
DBAT1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbatest001t)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = DBAT1)
)
)
DBAT1_STBY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbatest002t)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = DBAT1_STBY)
)
)
TNSNAMES STANDBY:
DBAT1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbatest001t)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = DBAT1)
)
)
DBAT1_STBY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbatest002t)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = DBAT1_STBY)
)
)
I've read nearly everything about dataguard but i guess im just dumb right now.
Welcome to DGMGRL, type "help" for information.
Connected to "DBAT1"
Connected as SYSDBA.
DGMGRL> show configuration
Configuration - my_dg
Protection Mode: MaxPerformance
Members:
DBAT1 - Primary database
dbat1_stby - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 43 seconds ago)
Thanks in advance!