I am upgrading from 8.1 to 8.5 and am in the process of setting up all the Database connections. This question relates to the Oracle piece of it.
We have Oracle 11g as our database and we have installed the client on the 8.5 server which is on Red Hat.
We changed platforms from Windows 2003 to Linux.
I copied my tnsnames.ora file from the Windows server to the Linux server.
There basically two minor issues that I am seeing after this setup is done.
a) My drop-down for a DSN in my Import Table Definition lists ALL the lines of my TNSnames.ora file.
For example, this is what my DSN drop-down looks like:
EDW.xxxxx.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx-xxx-xxxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = EDW2)
)
)
Rather than just say EDW...
Do I need to change something in my tnsnames.ora?
b)I'm having to fully qualify my connections when I run the jobs, so where previously on Windows I was able to just say "EDW for DSN, I'm now having to provide EDW.xxxxx.com for the connect identifier, otherwise it fails with a TNS:Cannot resolve connect identifier specified.
Is there a way around this?
Thanks!
tnsnames.ora and DSN in stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 44
- Joined: Wed May 27, 2009 3:01 pm
-
- Participant
- Posts: 44
- Joined: Wed May 27, 2009 3:01 pm
Ok, you can just remove the .xxxxx.com part from the EDW.xxxxx.COM(database alias) of the tnsnames.ora file. Also ensure to comment out the parameter NAMES.DEFAULT_DOMAIN = xxxxx.com if it is specified in the SQLNET.ora file. Then, you should be able just type the EDW as the connect identifier and get connected to the database.