TNS Names Bollocks!
#1
Scooby Regular
Thread Starter
Join Date: Nov 2001
Location: Leeds - It was 562.4bhp@28psi on Optimax, How much closer to 600 with race fuel and a bigger turbo?
Posts: 15,239
Likes: 0
Received 1 Like
on
1 Post
![Default](https://www.scoobynet.com/images/icons/icon1.gif)
What are the alternatives for replacing this with, its an administrative nightmare with our fookin stupid dba's not being able to publish a central file and then wanting to change entries on certain pc's
I believe I can publish this information into ActiveDirectory?? What versions of oracle support this, as we still have some V7 clients, but mainly 8 & 9 now.
Also isnt there oracle names as well? this would involve them setting something up so is well out of the question..
David
I believe I can publish this information into ActiveDirectory?? What versions of oracle support this, as we still have some V7 clients, but mainly 8 & 9 now.
Also isnt there oracle names as well? this would involve them setting something up so is well out of the question..
David
#2
Scooby Regular
Join Date: Oct 2001
Location: Lovely Lancing in West Sussex
Posts: 3,449
Likes: 0
Received 0 Likes
on
0 Posts
![Default](https://www.scoobynet.com/images/icons/icon1.gif)
I can't help on the AD publishing but you can have a local TNSnames.ora file as well as a global version.
Its the same as Windows hosts files, it looks locally first and then looks at the global version. As an example, if the local copy has a different IP address for a site it uses that local version.
Darren
Its the same as Windows hosts files, it looks locally first and then looks at the global version. As an example, if the local copy has a different IP address for a site it uses that local version.
Darren
#4
Scooby Regular
Join Date: Oct 2001
Location: Lovely Lancing in West Sussex
Posts: 3,449
Likes: 0
Received 0 Likes
on
0 Posts
![Default](https://www.scoobynet.com/images/icons/icon1.gif)
Our PC's have Oracle 6i installed and the NamersTNS.ora can be found at
C:\ orant\NET80\ADMIN\TNSNAMES.ora
We use it for pointing a few of the TEST PC's to different sites all the time.
Darren
C:\ orant\NET80\ADMIN\TNSNAMES.ora
We use it for pointing a few of the TEST PC's to different sites all the time.
Darren
#5
Scooby Regular
Thread Starter
Join Date: Nov 2001
Location: Leeds - It was 562.4bhp@28psi on Optimax, How much closer to 600 with race fuel and a bigger turbo?
Posts: 15,239
Likes: 0
Received 1 Like
on
1 Post
![Default](https://www.scoobynet.com/images/icons/icon1.gif)
Yeah.. im not explaining this right well..
We do a copy down of tnsnames to that folder.. however some pc's want odd changes and need exlusions.. trying to think of a different way to do it, and as for the oracle instant client![Roll Eyes (Sarcastic)](https://www.scoobynet.com/images/smilies/rolleyes.gif)
if you want a copy of it
David
We do a copy down of tnsnames to that folder.. however some pc's want odd changes and need exlusions.. trying to think of a different way to do it, and as for the oracle instant client
![Roll Eyes (Sarcastic)](https://www.scoobynet.com/images/smilies/rolleyes.gif)
if you want a copy of it
![Wink](https://www.scoobynet.com/images/smilies/wink.gif)
Code:
; Update Oracle TNS Names & BDE32 files, Unless the user is in the VCS-SPC-NoOraIdapi Group. If InGroup("VCS-SPC-NoOraIdapi") = 0 If Exist ($strIDAPI32) = 1 ? "Updating BDE File" Copy $strDCNAME+"\NETLOGON\Updates\IDAPI32.CFG" $strIDAPI32 EndIf $strOracleHomePath = ReadValue ("HKEY_LOCAL_Machine\Software\Oracle", "Oracle_Home") If Len($strOracleHomePath) > 0 If Instr($strOracleHomePath,"NET80") $strOracleHomePath = $strOracleHomePath + "\Admin" Else $strOracleHomePath = $strOracleHomePath + "\Network\Admin\" If Instr($strOracleHomePath,"ORA81") ? "Oracle 8.1 Installation Detected, Downloading SQLNET.ORA" Copy $strDCNAME+"\NETLOGON\Updates\sqlnet.ora" $strOracleHomePath EndIf EndIf ? "Updating TNSNAMES.ORA located in " + UCASE($strOracleHomePath) Copy $strDCNAME+"\NETLOGON\Updates\TNSNAMES.ORA" $strOracleHomePath Else ? "Unable to Find Oracle Installation, TNSNAMES.ORA not downloaded." EndIf ; Reset BDE Parameters ? "Resetting BDE Parameters" If Exist ("C:\Oracle\ora92\bin\oran9.dll") = 1 $Hideoutput = WriteValue("HKEY_LOCAL_MACHINE\SOFTWARE\BORLAND\DATABASE ENGINE\SETTINGS\DRIVERS\ORACLE\INIT","VENDOR INIT","OCI.DLL","REG_SZ") Else $Hideoutput = WriteValue("HKEY_LOCAL_MACHINE\SOFTWARE\BORLAND\DATABASE ENGINE\SETTINGS\DRIVERS\ORACLE\INIT","VENDOR INIT","ORA73.DLL","REG_SZ") EndIf $Hideoutput = WriteValue("HKEY_LOCAL_MACHINE\SOFTWARE\BORLAND\DATABASE ENGINE\SETTINGS\DRIVERS\ORACLE\INIT","DRIVER FLAGS","1","REG_SZ") EndIf
#6
![Default](https://www.scoobynet.com/images/icons/icon1.gif)
David, not quite sure what you want.
Would having the tnsnames.ora file held on the network in a central location solve it?
Something like that reg entry will point the client to use a tnsnames.ora file on the network. You could create other files in a different location for you awkward users.
Or am I smoking the wrong pipe
Would having the tnsnames.ora file held on the network in a central location solve it?
Code:
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE] "TNS_ADMIN"="x:\\tnsnames"
Or am I smoking the wrong pipe
![Big Grin](https://www.scoobynet.com/images/smilies/biggrin.gif)
#7
Scooby Regular
Join Date: Oct 2001
Location: Lovely Lancing in West Sussex
Posts: 3,449
Likes: 0
Received 0 Likes
on
0 Posts
![Default](https://www.scoobynet.com/images/icons/icon1.gif)
HHxx,
Thats what we do as well, most have registry key pointing to the x: drive and then the PC's that need it have local amended copy.
Darren
Thats what we do as well, most have registry key pointing to the x: drive and then the PC's that need it have local amended copy.
Darren
Trending Topics
#8
Scooby Regular
Join Date: Sep 2001
Location: Kingston ( Surrey, not Jamaica )
Posts: 4,670
Likes: 0
Received 0 Likes
on
0 Posts
![Default](https://www.scoobynet.com/images/icons/icon1.gif)
Wouldn't LDAP be a better solution David ?
Here's the howto...
http://www.idevelopment.info/data/Or...0/LDAP_8.shtml
steve
Here's the howto...
http://www.idevelopment.info/data/Or...0/LDAP_8.shtml
steve
#9
![Default](https://www.scoobynet.com/images/icons/icon1.gif)
We have a central repository of a few TNSnames.ora files, although the majority of people will all use the same one.
We just use SMS to distribute the files to the necessary clients, but if you don't use sms that's not any use!
We just use SMS to distribute the files to the necessary clients, but if you don't use sms that's not any use!
#10
Scooby Regular
Thread Starter
Join Date: Nov 2001
Location: Leeds - It was 562.4bhp@28psi on Optimax, How much closer to 600 with race fuel and a bigger turbo?
Posts: 15,239
Likes: 0
Received 1 Like
on
1 Post
![Default](https://www.scoobynet.com/images/icons/icon1.gif)
We use sms, but you cant rely on sms!! its package deployment is pretty random when it wants to be. Also the majority of our apps use oracle.. and if the apps dont work the users dont.
LDAP would be the ideal solution, its not so much the copying down of the file, its the fact that we have to do it.. IMHO why cant it just resolve the DB names via DNS??.. but cheers steve Ill have a look... Have you ever done it this way?
Its fookin bollox is oracle.. gimme SQL anyday![Big Grin](https://www.scoobynet.com/images/smilies/biggrin.gif)
David
LDAP would be the ideal solution, its not so much the copying down of the file, its the fact that we have to do it.. IMHO why cant it just resolve the DB names via DNS??.. but cheers steve Ill have a look... Have you ever done it this way?
Its fookin bollox is oracle.. gimme SQL anyday
![Big Grin](https://www.scoobynet.com/images/smilies/biggrin.gif)
David
Thread
Thread Starter
Forum
Replies
Last Post