I am able to launch Oracle Reports via X-windows. I can make modifications to the report layout, but when I attempt to connect to the database I get the ORA-12154 error. I know this means that the alias that I'm using to connect to the database isn't correct.
I found my tnsnames.ora file in the path /u01/app/oracle/product/7.3.4/network/admin and it looks like this:
So I use 'tasp' as my database name entry when trying to connect, but I still get the 12154 error.
I only have this problem when running Oracle Reports on my server. When running it from my desktop I have no problems at all. The only difference I can see is that on my desktop I have a tnsnames.ora file and a sqlnet.ora file. On my server I cannot find an sqlnet.ora file.
I believe that this is my problem, but I don't know where I would create the sqlnet.ora file, would it be in the same directory path as the tnsnames.ora?