Service "ORADATA" has 2 instance(s).
Service "ORADATAXDB" has 1 instance(s).
Kindly guide whats wrong with my configuration.
I think you are trying to connect from server not a remote client?
and you should look for "space" character around of ORADATA. Did you add below tns using netmanager or manual?
If that doesn't help then check whether TNS_ADMIN variable is set properly in Environment variable by issuing the following command in CMD.
If the path is not the directory where the tnsnames.ora file resides, then try changing the TNS_ADMIN path and then try connecting the db.
Removing blank space didn't help in tnsnames.ora file.
Finally removed the existing tnsnames.ora file and used Net Configuration Assistance and Using "Local Net Service Name Configuration" created a new service.