SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Connect Error: Database not available

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Connect Error: Database not available
Author Message
srinivasysr2003



Joined: 03 Sep 2015
Posts: 1
Country: United States

Post Connect Error: Database not available Reply with quote
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
Thu Sep 03, 2015 9:08 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6512

Post Reply with quote
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.
Sat Sep 12, 2015 1:27 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.