The biggest problem is the ORA-12502 error. This is saying that the CONNECT_DATA string in your TNS alias is empty. You'll need to verify that the CONNECT_DATA string in your TNSNAMES.ORA file contains a valid database to connect to.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.