TNSNames Updates for Accessing InfoAccess
Posted: 2016-08-08 14:58:33 Expiration: 2016-08-15 14:58:33
An update for accessing InfoAccess has been emailed to the Infoaccess users. The corresponding entries in the TNSNames file will need to be replaced before the enduser can connect.
The following error will be displayed when attempting to connect without a valid entry in the TNSNames file:
"Oracle error-1:ORA-12505: TNS:listener does not know of SID given in connect descriptor"
InfoAccess has been migrated to the Exadata environment. The production database for InfoAccess is known by two names, INFOACCESS and DWHP. Customers will need to update both entries in the TNSNames file so they can access the InfoAccess information.
The edit should be done with administrator level access. For more information, see EPM - Editing 'tnsnames.ora' and 'sqlnet.ora' Files
Please contact the DoIT Help Desk if you did not receive the email or need further assistance.
-- InfoAccess Team