I have two servers:
server 1 is Oracle Linux Dell server with OEL 5.11
server 1 has a functional instance of Oracle EBS on it, apps + db (DB = 12.1.0.2 SID = TEST)
server 2 is an Oracle Database Appliance (X7-2M) that has a newly created db - 12.1.0.2, SID = GFT1
from a windows workstation I can connect to GFT1 as sys using TOAD
from server 2 I want to be able to connect to GFT1 using sqlplus
from server 2, TNS ping is successfull to GFT1
from server 2, "sqlplus sys/***MASKED***@GFT1" issued command generates error:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
What am I missing?
or
Anyone know of a good succinct doc or explanation of the steps to make one db accessible via sqlplus from a remote OEL server with same version DB?