If I remove the 'Allow In Process' on OraOLEDB.Oracle provider.I get the following error when executing

SELECT * FROM OPENQUERY(TestOraLink, 'select * from test_table2')

Error MSG

OLE DB provider "OraOLEDB.Oracle" for linked server "TestOraLink" returned message "ORA-01017: invalid username/password; logon denied".

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "TestOraLink".

If 'Allow In Process; is selected,I receive the following message

OLE DB provider "OraOLEDB.Oracle" for linked server "TestOraLink" returned message "ORA-12154: TNS:could not resolve the connect identifier specified".