Is the tnsnames.ora correctly formatted with the BBSA Core DB ?
Run a TNSPING <BBSA CORE DB> to check first.
Does the tnsnames.ora on the db server(s) have the same entries?
I didnt know the DB needed tnsnames.ora - The DB is managed seperatly so I have emailed that team to ask. What are you thinking could be the cause?
The tnsnames.ora need to have the same tns entries that are on the reports server or it will have problems creating the linked server.
I matched the tnsnames.ora entries exactly and receive the same error. Will need to raise a supp case now but open to further suggestions.
Is the format of the tnsnames.ora correct ?
The one I saw only had SID and not SERVICE, this could be worth looking into.
Mit freundlichen Grüssen/Cordialement/Kind Regards
Hey Pal. Yes I am using SERVICE_NAME now