SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
sql scripts and ORA-12154

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
sql scripts and ORA-12154
Author Message
Neville Bird



Joined: 28 Mar 2001
Posts: 1

Post sql scripts and ORA-12154 Reply with quote

I have successfully installed DB Mail on an Oracle Version 7.3.4.3 database using a (slightly) modified version of db_mail_install_7.sql.
I have also attempted the same on an Oracle Version 8.1.6 database, again using a modified version of db_mail_install_8i.sql.
When I run "reconnect", starting the daemon and connectivity works fine for the V7 database, but generates ORA-12154 error when attempting to connect to the V8.1.6 database. There are three tnsnames.ora files on my (NT) pc - in
c:\orant\network\admin ; c:\oem\network\admin (a copy of the aforementioned file); and c:\oem\network\admin\sample.
I also use "TOAD" for example, which has no trouble connecting to any of the V7/8 databases for which I am responsible. Any suggestions ?\

Other minor problems with scripts having tortologous ';' followed by '/' for table/synonym/grant etc statements; "LARGE" is not a recognised Oracle datatype; is it intentional to exclude a "grant execute" to other users/roles; and is it intentional that "Reconnect" stops/starts daemons for ALL databases rather than just one or more "selected" databases ?

Wed Mar 28, 2001 2:03 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: sql scripts and ORA-12154 Reply with quote

ORA-12154: TNS:could not resolve service name
(DBMS O71,O72,O73) The tnsnames.ora file was not found in Oracle_HOME\NETWORK\ADMIN directory.
(DBMS OR8, O84) The tnsnames.ora file was not found in Oracle_HOME\NET80\ADMIN directory.

It looks like you don'have tnsnames.ora file in C:\ORACLE\NET80\ADMIN which is causing the connection to fail.

What dou you mean by ""grant execute" to other users/roles"?
ther is a public synonym and "grant to PUBLIC"? In general you can customize it anyway you want.

In reality "Reconnent" does more that reconnect to all database. It is some sort of full restart without reloading the software. You should use that reconnect when you change one or more global settings.

: I have successfully installed DB Mail on an Oracle Version 7.3.4.3 database
: using a (slightly) modified version of db_mail_install_7.sql.
: I have also attempted the same on an Oracle Version 8.1.6 database, again
: using a modified version of db_mail_install_8i.sql.
: When I run "reconnect", starting the daemon and connectivity works
: fine for the V7 database, but generates ORA-12154 error when attempting to
: connect to the V8.1.6 database. There are three tnsnames.ora files on my
: (NT) pc - in
: c:\orant\network\admin ; c:\oem\network\admin (a copy of the aforementioned
: file); and c:\oem\network\admin\sample.
: I also use "TOAD" for example, which has no trouble connecting to
: any of the V7/8 databases for which I am responsible. Any suggestions ?\

: Other minor problems with scripts having tortologous ';' followed by '/' for
: table/synonym/grant etc statements; "LARGE" is not a recognised
: Oracle datatype; is it intentional to exclude a "grant execute"
: to other users/roles; and is it intentional that "Reconnect"
: stops/starts daemons for ALL databases rather than just one or more
: "selected" databases ?

Wed Mar 28, 2001 10:09 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.