> I have been working on this all day and am still getting
> errors - I can connect using sqlplus in solaris without
> problems but cannot connect through cfadministrator - I
> tried a page to sdee if it would work even though it was
> failing connectivity but with no joy. Error code is below:
>
> ORA-12154: TNS:could not resolve service name
>
> I am not sure what this means but I presume that it is at
> least seeing Oracle (therefore it is setup correctly).
Have you successfully created and tested a connection within the Net8 Oracle
client? You'll need to do that first, or add the client entry directly into
your tnsnames.ora file. Here's a sample tnsnames.ora file:
# TNSNAMES.ORA Configuration
File:/opt/u01/app/oracle/product/8.1.5/network/ad
min/tnsnames.ora
# Generated by Oracle Net8 Assistant
ORMAST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myoradb)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ormast.myoradb.figleaf.com)
)
)
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
