If you're adding an Oracle Connection Pool the tendency is to use the TNS Alias. This implies, though , the following problems
1: Admin Client needs the TNS Entry ( AND addition of TNS_ADMIN environmental variables into the Windows Envars, which you may not have Admin access to do on your workstation ).... sooo how to fix
2: Server needs the TNS entry in $ORACLE_HOME/network/admin, where Oracle_HOME=MW_HOME/Oracle_BI1 - e.g.
Means you have a pain keeping them in sync, especially as databases get created/added etc
Easy fix : just use the full connection string in the connection pool DS string
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = mydbhost.org.com)(PORT= 1521)) ) (CONNECT_DATA = (SERVICE_NAME = MYSERVICE) ) )
( all on one line ) . Now you don't have to maintain anything ! YES a 10gRAC string will be long but it's a simple copy and paste
FINALLY. If you are adding a Connection POOL SAVE the definition and Check it IN before importing Metadata.
Ran into a problem on the import that locked the CP definition as checked OUT and had to bounce nqsserver - nqserror 36004