RE: multiple versions of SQLPlus.exe [now evolved to: multiple versions of tnsnames.ora in NT/W2K]
Yup it is a string and not a key - thanks for pointing that out :) -Original Message- Sent: Wednesday, May 30, 2001 05:36 To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] If under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE you have one or multiple folders, like: HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0 HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME1 then you have to create TNS_ADMIN string value (not key) in each of those folders pointing to your master tnsnames.ora file. Works for me. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 10:56 AM versions of tnsnames.ora in NT/W2K] On NT 4 with Developer 6i and Oracle 816/817 I have never been able to get Oracle db to work off of the tns_admin key. Only forms would work off of the tns_admin, and without that key forms would not connect to the dbs. Just thought I would mention that. Kev -Original Message- Sent: Wednesday, May 30, 2001 7:16 AM To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] You CAN actually set the TNS_ADMIN variable in the registry under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ - It may not be there at first, all you need to do is create a new key called TNS_ADMIN with a value of the path to your master tnsnames.ora file. HTH Mark -Original Message- Granaman Sent: Tuesday, May 29, 2001 09:45 To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] In Unix, one can create links to a master by $ ls -s some master tnsnames.ora some other location/file. (I know, I could, and probably should, use the TNS_ADMIN environmental variable instead.) There seems to be no equivalent of this in NT though. Creating a shortcut doesn't seem to work. Copying files around seems primitive at best. Am I missing something? [OK, OK! I'll reform and use the environmental variable!] -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 2:01 PM Dave, It seems to me that you are having a problem reading the proper TNSNAMES.ORA for the different DBs. What I would do in your situation is to search for all TNSNAMES.ORA files in your PC, since you have products installed in more than one home and more than one version you should have multiple. Edit them and see which ones contain the entries that you need, in one or more of them some entries will be missing, what you can do is copy/paste the missing entries, once you have the file you want then copy it to all the different Homes and you should be able to connect to the different DB's. [... snip ...] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
RE: multiple versions of SQLPlus.exe [now evolved to: multiple versions of tnsnames.ora in NT/W2K]
On NT 4 with Developer 6i and Oracle 816/817 I have never been able to get Oracle db to work off of the tns_admin key. Only forms would work off of the tns_admin, and without that key forms would not connect to the dbs. Just thought I would mention that. Kev -Original Message- Sent: Wednesday, May 30, 2001 7:16 AM To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] You CAN actually set the TNS_ADMIN variable in the registry under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ - It may not be there at first, all you need to do is create a new key called TNS_ADMIN with a value of the path to your master tnsnames.ora file. HTH Mark -Original Message- Granaman Sent: Tuesday, May 29, 2001 09:45 To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] In Unix, one can create links to a master by $ ls -s some master tnsnames.ora some other location/file. (I know, I could, and probably should, use the TNS_ADMIN environmental variable instead.) There seems to be no equivalent of this in NT though. Creating a shortcut doesn't seem to work. Copying files around seems primitive at best. Am I missing something? [OK, OK! I'll reform and use the environmental variable!] -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 2:01 PM Dave, It seems to me that you are having a problem reading the proper TNSNAMES.ORA for the different DBs. What I would do in your situation is to search for all TNSNAMES.ORA files in your PC, since you have products installed in more than one home and more than one version you should have multiple. Edit them and see which ones contain the entries that you need, in one or more of them some entries will be missing, what you can do is copy/paste the missing entries, once you have the file you want then copy it to all the different Homes and you should be able to connect to the different DB's. [... snip ...] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: multiple versions of SQLPlus.exe [now evolved to: multiple versions of tnsnames.ora in NT/W2K]
If under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE you have one or multiple folders, like: HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0 HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME1 then you have to create TNS_ADMIN string value (not key) in each of those folders pointing to your master tnsnames.ora file. Works for me. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 10:56 AM versions of tnsnames.ora in NT/W2K] On NT 4 with Developer 6i and Oracle 816/817 I have never been able to get Oracle db to work off of the tns_admin key. Only forms would work off of the tns_admin, and without that key forms would not connect to the dbs. Just thought I would mention that. Kev -Original Message- Sent: Wednesday, May 30, 2001 7:16 AM To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] You CAN actually set the TNS_ADMIN variable in the registry under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ - It may not be there at first, all you need to do is create a new key called TNS_ADMIN with a value of the path to your master tnsnames.ora file. HTH Mark -Original Message- Granaman Sent: Tuesday, May 29, 2001 09:45 To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] In Unix, one can create links to a master by $ ls -s some master tnsnames.ora some other location/file. (I know, I could, and probably should, use the TNS_ADMIN environmental variable instead.) There seems to be no equivalent of this in NT though. Creating a shortcut doesn't seem to work. Copying files around seems primitive at best. Am I missing something? [OK, OK! I'll reform and use the environmental variable!] -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 2:01 PM Dave, It seems to me that you are having a problem reading the proper TNSNAMES.ORA for the different DBs. What I would do in your situation is to search for all TNSNAMES.ORA files in your PC, since you have products installed in more than one home and more than one version you should have multiple. Edit them and see which ones contain the entries that you need, in one or more of them some entries will be missing, what you can do is copy/paste the missing entries, once you have the file you want then copy it to all the different Homes and you should be able to connect to the different DB's. [... snip ...] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send
RE: multiple versions of SQLPlus.exe [now evolved to: multiple versions of tnsnames.ora in NT/W2K]
It is a good point that it's a string, I actually knew that, but it still doesn't explain why i can't get it to work. Not that it's that big of a deal. I'll try again, no harm in that. Kev -Original Message- Sent: Wednesday, May 30, 2001 12:36 PM To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] If under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE you have one or multiple folders, like: HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0 HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME1 then you have to create TNS_ADMIN string value (not key) in each of those folders pointing to your master tnsnames.ora file. Works for me. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 10:56 AM versions of tnsnames.ora in NT/W2K] On NT 4 with Developer 6i and Oracle 816/817 I have never been able to get Oracle db to work off of the tns_admin key. Only forms would work off of the tns_admin, and without that key forms would not connect to the dbs. Just thought I would mention that. Kev -Original Message- Sent: Wednesday, May 30, 2001 7:16 AM To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] You CAN actually set the TNS_ADMIN variable in the registry under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ - It may not be there at first, all you need to do is create a new key called TNS_ADMIN with a value of the path to your master tnsnames.ora file. HTH Mark -Original Message- Granaman Sent: Tuesday, May 29, 2001 09:45 To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] In Unix, one can create links to a master by $ ls -s some master tnsnames.ora some other location/file. (I know, I could, and probably should, use the TNS_ADMIN environmental variable instead.) There seems to be no equivalent of this in NT though. Creating a shortcut doesn't seem to work. Copying files around seems primitive at best. Am I missing something? [OK, OK! I'll reform and use the environmental variable!] -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 2:01 PM Dave, It seems to me that you are having a problem reading the proper TNSNAMES.ORA for the different DBs. What I would do in your situation is to search for all TNSNAMES.ORA files in your PC, since you have products installed in more than one home and more than one version you should have multiple. Edit them and see which ones contain the entries that you need, in one or more of them some entries will be missing, what you can do is copy/paste the missing entries, once you have the file you want then copy it to all the different Homes and you should be able to connect to the different DB's. [... snip ...] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official
Re: multiple versions of SQLPlus.exe [now evolved to: multiple versions of tnsnames.ora in NT/W2K]
In Unix, one can create links to a master by $ ls -s some master tnsnames.ora some other location/file. (I know, I could, and probably should, use the TNS_ADMIN environmental variable instead.) There seems to be no equivalent of this in NT though. Creating a shortcut doesn't seem to work. Copying files around seems primitive at best. Am I missing something? [OK, OK! I'll reform and use the environmental variable!] -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 2:01 PM Dave, It seems to me that you are having a problem reading the proper TNSNAMES.ORA for the different DBs. What I would do in your situation is to search for all TNSNAMES.ORA files in your PC, since you have products installed in more than one home and more than one version you should have multiple. Edit them and see which ones contain the entries that you need, in one or more of them some entries will be missing, what you can do is copy/paste the missing entries, once you have the file you want then copy it to all the different Homes and you should be able to connect to the different DB's. [... snip ...] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).