Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.4K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 546 SQLcl
- 4K SQL Developer Data Modeler
- 187.1K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 443 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
# Generated by Oracle configuration tools
896517
Member Posts: 1
Hello - I have recently been asked to synchronize an oracle file, (TNSNAMES.ORA) across multiple servers. The question I have is how is this file created/updated. Based on the comment in the header of the file, it says "# Generated by Oracle configuration tools".
Where do I find these "configuration tools" and is there a specific name for the tool or process that I need to run to create/update this file? The TNSNAMES.ORA file is located in the ..\ora92\network\admin folder.
Any help would be greatly appreciated.
Thanks in advance!
Dan
Where do I find these "configuration tools" and is there a specific name for the tool or process that I need to run to create/update this file? The TNSNAMES.ORA file is located in the ..\ora92\network\admin folder.
Any help would be greatly appreciated.
Thanks in advance!
Dan
Answers
-
Generally it's generated by the Net Configuration Assistant, which you can access from Start > Programs > OracleHome > Configuration tools
It's just a text file though, you can generate it by hand using notepad, copy/paste it from a different machine, etc. All that really matters is that you have the format of the entries correct.
You may also want to synchronize sqlnet.ora at the same time (in the same folder) as the two files generally go hand in hand, and some sqlnet.ora entries affect how tnsnames is used.
Greg
This discussion has been closed.