mail-question wrote:
QUOTE:
How do I find what is the $ORACLE_HOME that DreamCoder is looking for ? I got ORacle 12504 error recently but my sql plus does not have this problem.....ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Question from : Sam Hung
The DreamCoder for Oracle load all the oracle homes available in the field "home", but you need to choose the right home and database server name. Please check any old Oracle client has installed in your system and check the path env variable and remove old Oracle client paths.
Example:
MENTAT64 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.3.11)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MENTAT64)
)
)
ORA-12504: TNS:listener was not given the SID in CONNECT_DATA
Cause: The SID was missing from the CONNECT_DATA.
Action: Check that the connect descriptor corresponding to the service name in TNSNAMES.ORA has an SID component in the CONNECT_DATA.
You can try to use TCP-IP Direct connection.
http://forums.sqlplex.com/mentat-technologies-database-tools/category-dreamcoder-for-oracle/cannot-find-OCI-DLL.html
Regards,
Peter
