 | |
11g - ORA 12154 error after installation of ODAC1110610beta
comp.databases.oracle.tools comp.databases.oracle.tools
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
11g - ORA 12154 error after installation of ODAC1110610beta -
11-25-2007
, 10:06 AM
#2
| |||
| |||
|
|
OS: Win XP SP2 Oracle 11g installed. 1. Database was successfully created and was accessible from SQLPlus, Database Control (Web interface) and TOAD 9.5 2. Installed ODAC 11.1.0.6.1.0 beta and.. 3. Receive "ORA 12154: TNS could not resolve the connect identifier specified" error always trying to connect trough TOAD or from my own .NET applications, but... 4. Full functional access still works from SQLPlus and from Database Control Web interface. I have read all posts related with ORA 12154 but most of them are very old and do not help. tnsnames and listener settings are ok - everything worked fine until the last ODAC was installed. Any ideas of how to resolve the problem are very appreciated. -Roman |
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#3
| |||
| |||
|
|
rom_vl1 (AT) mail (DOT) ru wrote: OS: Win XP SP2 Oracle 11g installed. 1. Database was successfully created and was accessible from SQLPlus, Database Control (Web interface) and TOAD 9.5 2. Installed ODAC 11.1.0.6.1.0 beta and.. 3. Receive "ORA 12154: TNS could not resolve the connect identifier specified" error always trying to connect trough TOAD or from my own .NET applications, but... 4. Full functional access still works from SQLPlus and from Database Control Web interface. I have read all posts related with ORA 12154 but most of them are very old and do not help. tnsnames and listener settings are ok - everything worked fine until the last ODAC was installed. Any ideas of how to resolve the problem are very appreciated. -Roman what is ODAC? If in a new ORACLE_HOME you must alter its tnsnames.ora. -- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org |
hit.
Shakespeare
#4
| |||
| |||
|
|
"DA Morgan" <damor... (AT) psoug (DOT) org> schreef in berichtnews:1196022529.367949 (AT) bubbleator (DOT) drizzle.com... rom_... (AT) mail (DOT) ru wrote: OS: Win XP SP2 Oracle11ginstalled. 1. Database was successfully created and was accessible from SQLPlus, Database Control (Web interface) and TOAD 9.5 2. Installed ODAC 11.1.0.6.1.0 beta and.. 3. Receive "ORA12154: TNS could not resolve the connect identifier specified" error always trying to connect trough TOAD or from my own .NET applications, but... 4. Full functional access still works from SQLPlus and from Database Control Web interface. I have read all posts related with ORA12154but most of them are very old and do not help. tnsnames and listener settings are ok - everything worked fine until the last ODAC was installed. Any ideas of how to resolve the problem are very appreciated. -Roman what is ODAC? If in a new ORACLE_HOME you must alter its tnsnames.ora. -- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damor...@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org Oracle Data Access Components. Google for ODAC Oracle and it's your first hit. Shakespeare- Скрыть цитируемый текст - - Показать цитируемый текст - |
Do you have any ideas about the problem?
What actions can I do to discover what is the reason?
#5
| |||
| |||
|
|
OS: Win XP SP2 Oracle 11g installed. 1. Database was successfully created and was accessible from SQLPlus, Database Control (Web interface) and TOAD 9.5 2. Installed ODAC 11.1.0.6.1.0 beta and.. 3. Receive "ORA 12154: TNS could not resolve the connect identifier specified" error always trying to connect trough TOAD or from my own .NET applications, but... 4. Full functional access still works from SQLPlus and from Database Control Web interface. I have read all posts related with ORA 12154 but most of them are very old and do not help. tnsnames and listener settings are ok - everything worked fine until the last ODAC was installed. Any ideas of how to resolve the problem are very appreciated. -Roman |
first now - and in that directory, the correct tnsnames.ora
cannot be found.
Either copy your *.ora files from your database_home\network\admin
directory to the ODAC\network\admin directory, or introduce
the tns_admin environment variable (via a "SET" command, or via
the registry), and make it point to the correct (database home!)
network\admin directory.
That should do the trick.
#6
| |||
| |||
|
|
On 25 nov, 17:06, rom_... (AT) mail (DOT) ru wrote: OS: Win XP SP2 Oracle11ginstalled. 1. Database was successfully created and was accessible from SQLPlus, Database Control (Web interface) and TOAD 9.5 2. Installed ODAC 11.1.0.6.1.0 beta and.. 3. Receive "ORA12154: TNS could not resolve the connect identifier specified" error always trying to connect trough TOAD or from my own .NET applications, but... 4. Full functional access still works from SQLPlus and from Database Control Web interface. I have read all posts related with ORA12154but most of them are very old and do not help. tnsnames and listener settings are ok - everything worked fine until the last ODAC was installed. Any ideas of how to resolve the problem are very appreciated. -Roman Your path setting probably list the ODAC installation directory first now - and in that directory, the correct tnsnames.ora cannot be found. Either copy your *.ora files from your database_home\network\admin directory to the ODAC\network\admin directory, or introduce the tns_admin environment variable (via a "SET" command, or via the registry), and make it point to the correct (database home!) network\admin directory. That should do the trick.- Hide quoted text - - Show quoted text - |
You are right.
I thought about it, but I could not check what version of tsnnames.ora
uses ODAC
#7
| |||
| |||
|
|
what is ODAC? If in a new ORACLE_HOME you must alter its tnsnames.ora. -- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org Oracle Data Access Components. Google for ODAC Oracle and it's your first hit. Shakespeare |
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#8
| |||
| |||
|
|
On Nov 26, 12:32 pm, "frank.van.bor... (AT) gmail (DOT) com" frank.van.bor... (AT) gmail (DOT) com> wrote: On 25 nov, 17:06, rom_... (AT) mail (DOT) ru wrote: OS: Win XP SP2 Oracle11ginstalled. 1. Database was successfully created and was accessible from SQLPlus, Database Control (Web interface) and TOAD 9.5 2. Installed ODAC 11.1.0.6.1.0 beta and.. 3. Receive "ORA12154: TNS could not resolve the connect identifier specified" error always trying to connect trough TOAD or from my own .NET applications, but... 4. Full functional access still works from SQLPlus and from Database Control Web interface. I have read all posts related with ORA12154but most of them are very old and do not help. tnsnames and listener settings are ok - everything worked fine until the last ODAC was installed. Any ideas of how to resolve the problem are very appreciated. -Roman Your path setting probably list the ODAC installation directory first now - and in that directory, the correct tnsnames.ora cannot be found. Either copy your *.ora files from your database_home\network\admin directory to the ODAC\network\admin directory, or introduce the tns_admin environment variable (via a "SET" command, or via the registry), and make it point to the correct (database home!) network\admin directory. That should do the trick.- Hide quoted text - - Show quoted text - Thank you very much. You are right. I thought about it, but I could not check what version of tsnnames.ora uses ODAC |
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#9
| |||
| |||
|
|
Put the same, working, TNSNAMES.ORA into every /network/admin directory. |
environment variable TNS_ADMIN.
Regards,
Maciek
#10
| |||
| |||
|
|
DA Morgan pisze: Put the same, working, TNSNAMES.ORA into every /network/admin directory. ... or make one directory with tnsnames.ora and sqlnet.ora and set environment variable TNS_ADMIN. Regards, Maciek |
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.