I'm re-learning client connectivity but obviously I've missed something.
I have two instances, ORACLE_SIDs= omf and orcl, both are using the same ORACLE_HOME.
I believe I've included all the relevant info in accompanying files.
I've designated a connect identifier "tns" in tnsnames.ora.
I cannnot > tnsping tns nor > tnsping tns.websmiths.com. I get 'failed to resolve name'.
Is it possible the instances retaining UNKNOWN status in listener are picking up the tnsping request and failing there?
On those UNKNOWN statuses, I (believe I've) tried every possible combination of initialization parameters LOCAL_LISTENER and DB_DOMAIN, and sqlnet.ora's NAME.DOMAIN_NAME, yet I can't stop/start listener and not have those after 'register'ing or waiting for auto registration.
ANY assistance to correct or that's beyond what I have shown here would be deeply appreciated. I've put 20+ hours into this. Generated a lot of my own documentation and more, but I'm obviously missing something.