Connecting to the Remote Database using Oracle Report Builder 11g
Hello All,
This might me silly question but i have installed Oracle Forms and Reports 11g on Win 7 machine. I have copied "tnsnames.ora" file at folder "ORACLE_HOME/Network/Admin". We are using Oracle EBS R12 and I want to create new report using 11g.
Using Report Wizard after providing simple Query we need to connect to the Database. And even after providing TNS entry i am getting following error while connecting to the database,
"REP-0501: The Specified database cannot be connected
ORA-12154: TNS: could not resolve the connect identifier specified"
I am able to connect to the same database using Report Builder(10.1.2.0). Is there any other place where i need to define TNS entry?? How could i resolve this error?? please guide ....
Regards,
Priyanka