Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.9K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 399 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 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.