The solutionTnsping works fine, with DBCA we get an error, solving the entry format conform the NETCA layout.
joords_XPT.joords.nl= (DESCRIPTION=(ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=joords_scan)(PORT=1521))) (CONNECT_DATA=(SERVICE_NAME=joords_XPT.joords.nl)(UR=A)))
Change the entry confrom the NETCA format:
joords_XPT.joords.nl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = joords_scan)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = joords_XPT.joords.nl)(UR = A)) )
An other solution is:
- Remove tnsnames.ora file & Recreate using netca
- Remove the specific entry, which is reported as part of ‘null RHS’ error