Differences

This shows you the differences between two versions of the page.

--- knowledge-base:database-migration:setup-and-troubleshooting:oracle:tns-configuration [2018/08/01 14:09]
+++ knowledge-base:database-migration:setup-and-troubleshooting:oracle:tns-configuration [2023/12/15 09:19] (current)
volha.zhyrava
@@ Line 1: / Line 1: @@
+\\
+[[https://www.ispirer.com|Ispirer Website]]
+[[https://www.ispirer.com/products/oracle-migration|Ispirer Capabilities: Oracle Migration]]
+[[https://www.ispirer.com/download/download-demo|Free Trial]]
+====== TNS Service Name Configuration ======
+TNS Service name is the local name of the remote Oracle service.
+There are 2 ways to specify the TNS Service name:\\
+- using "Net Manager";\\
+- using "Oracle Net Configuration Assistant".
+Here we will create TNS Service Name via "Net Manager".
+Please open the "Oracle Net Manager" window.
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_tns_conf_1.jpg?nolink|}}
+Please, perform the following steps for the Net Service Name configuration:
+a. Сhoose "Local -> Service Naming" configuration item and click "+" button:
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_tns_conf_2.jpg?nolink|}}
+b. Set up the "Net Service Name" and click "Next" button.
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_tns_conf_3.jpg?nolink|}}
+c. Choose the network protocol. Normally it's TCP/IP. Click "Next" button.
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_tns_conf_4.jpg?nolink|}}
+d. Please, specify the "Host name" of the Oracle Server, the "Port Number" and click "Next" button.
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_tns_conf_5.jpg?nolink|}}
+e. Set up the "Oracle Service Name" and click "Next" button.
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_tns_conf_6.jpg?nolink|}}
+f. Now please "Test" the connection: click "Text" button and in opened "Connection Test" window click "Change Login" button, set up the credentials and click "OK":
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_tns_conf_7.jpg?nolink|}}
+g. Click "Test" button.
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_tns_conf_8.jpg?nolink|}}
+h. Complete the Net Service Name specification and close the Net Manager or select menu item "File -> Save Network Configuration".
+{{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_tns_conf_9.jpg?nolink|}}
+\\
+If you have any other questions, please contact us: [[[email protected]]]