Tools Issue

Hi can anyone assist please.

Got my 8.1.7 database up and running on my machine at home and have tried to install 6i Forms and Reports.

I can connect to the database in a SQL+ session using the scott schema.

Unfortunately I can not get the tools to work with the database.

OS: Windows XP
db: 8.1.7
forms: [32 Bit] Version 6.0.8.11.3 (Production)
reports:Report Builder 6.0.8.11.3

error messages
ORA-12203: TNS: unable to connect to destination

REP-0501 unable to connect to the specified destination
ORA-12203: TNS: unable to connect to destination

I have looked at the database TNSNAMES and the Tools TNSNAMES files, copying entries from database TNSNAMES to Tools but still no joy.

Could the problem be using TCPIP protocol when both database and tools reside on one machine?

two things:

Which versions of sql-net are you using? make sure the listener is running (on some platforms it doesn't auto-start).

are you specifying the connect string (db-name) when you try to connect to the database with tools? Connecting "locally" is different than connecting "remotely" in that you don't have to specify a name in the local connection, but you do in the remote. Your TNSNAMES.ORA file must contain a connect string and database alias (TOOLS) in order to connect. It thinks you are running client/server.

Thanks for the insight.

Firstly , it appears to be sql net 8 v8.1.7.

When I run the Forms or Reports wizards and specify my connection I give user account / password and SID details of the 8i database that I can connect to through a SQL+ session.

With respect to the TNSNAMES.ORA file, which one(s) would need this TOOLS entery you mention? The database TNSNAMES.ORA file or the relevant TNSNAMES.ORA file for the TOOL?


Thanks for your help.