Connect Error: Database not available

Hi,

I am getting error as below.

Connect Error
Database not available
ORA-12154: TNS:could not resolve the connect identifier specified

I am able to connect with same value as Host String through SQL*Plus.

SQL*Plus installed through "Oracle forms developer 10g" installation.

I have gone though the documentation and looks like below is the cause of my error reason, but unable to fix it.
**************************************************************
ORA-12154: TNS:could not resolve service name
(DBMS O73) The tnsnames.ora file was not found in Oracle_HOME\NETWORK\ADMIN directory.
(DBMS OR8) The tnsnames.ora file was not found in Oracle_HOME\NET80\ADMIN directory.
(Oracle 7.x) No matching service name in tnsnames.ora file. Be sure to include the complete name
(including the domain) as it appears in the tnsnames.ora file. For example, if the entry is orsrvr.world in the
tnsnames.ora entry, the server specified in the database profile would be @orsrvr.world. This is true even if
the service name specified in SQL*Plus was orsrvr.
(DBMS OR8)If the service name contains a preceding "@" or "@TNS:", this error will occur. If the specified
service name was not found in the tnsnames.ora, this error will occur.
**************************************************************

My SQL*Plus Client is 10.1.0.4.2. My folder structure as below. I have selected the folder icon to select my client version.

C:\DevSuiteHome_1\BIN\
\NETWORK\ADMIN\tnsnames.org

I have entered my database name as "TSOADEV4"/"TSOADEV4.world". No luck.

Thanks,
Srinivas

Do you have 32-bit or 64-bit Oracle client installed? DB audit GUI console is a 32-bit app, it can only work with 32-bit client and so it can only read TNS names from a 32-bit client's TNSNAMES.ORA file.

A tip: If you use DB audits's web-based console you can have it connect to the target Oracle server directly, it doesn't need an Oracle client for that nor TNSNAMES.ORA files.