Hello everyone,
First and formost, i'm very new to clusterware and rac. So please excuse me if i used wrong termanology. The easiest way to explained my dilemma is to show you the following first. Below is the listener status of scan listener.
[oracle@zso-oda1-1 MASTER_zso-oda1-0]$ lsnrctl status LISTENER_SCAN1
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 27-AUG-2018 09:43:31
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN1
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 27-AUG-2018 09:11:40
Uptime 0 days 0 hr. 31 min. 50 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/12.2.0.1/oracle/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/zso-oda1-1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.90.215)(PORT=1521)))
Services Summary...
Service "-MGMTDBXDB" has 1 instance(s).
Instance "-MGMTDB", status READY, has 1 handler(s) for this service...
Service "6ce77dd55821dc45e053d25a0a0a0718" has 1 instance(s).
Instance "-MGMTDB", status READY, has 1 handler(s) for this service...
Service "MASTER.zeusinc.com" has 1 instance(s).
Instance "MASTER", status READY, has 1 handler(s) for this service...
Service "MISDGXDB.zeusinc.com" has 1 instance(s).
Instance "MASTER", status READY, has 1 handler(s) for this service...
Service "_mgmtdb" has 1 instance(s).
Instance "-MGMTDB", status READY, has 1 handler(s) for this service...
Service "gimr_dscrep_10" has 1 instance(s).
Instance "-MGMTDB", status READY, has 1 handler(s) for this service...
The command completed successfully
i was able to connect to MASTER database using scan address, sqlplus sys/<sys password>@scan-name:1521/MASTER.zeusinc.com.
My dilemma,
I'm leveraging this utility call gDBClone (snopshot cloning of ACFS file system).
However that utiliy kept failing with ORA-12514 TNS:listener does not currently know of service requested in connect descriptor.
What I noticed in the log file
export oracle_home=/u01/app/oracle/product/12.1.0.2/dbhome_13,
/u01/app/oracle/product/12.1.0.2/dbhome_13/bin/sqlplus -L sys/password@<scan-name>:1521/MASTER as sysdba
Obviously service name MASTER was never register with scan listener. How can i register that service "MASTER" with scan listener.
Below are the parameter values of what i think is contributing to m dilemma.
SQL> show parameter local
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string MASTER
SQL> show parameter remote
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_dependencies_mode string TIMESTAMP
remote_listener string zso-oda1-scan:1521
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string MASTER.zeusinc.com, MASTER
gDBCloe utility want to used scan listener for (im sure there is a good reason behind it). If this was a regular non-default listener, i could add a static service to listener.ora. How can i do this for GRID_HOME.