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 ?
|
