NEW REMOTE SERVER LINK

[teknikalbody]

we have recently installed a new remote server named "TWOCOOL", can some one please help me set up all that is requred to link up to this server for use for my PC bearing in mind I already use "ONECOOL" and want to continue using this server aswell as the new one.

 

[AOLEURO]

Hi

Not sure what you mean.

If you want to connect to TWOCOOL by your PC with ex. SQLPLUS – you have to make changes with “Net8 configuration assistance” – and I think you use local net service name configuration (TNSNAMES.ORA). You can change the file directly with an editor like notepad – hide a copy of the file before changing.

Ex.

TWOCOOL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 168.192.42.12)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)

Host = IP number of TWOCOOL server or use server name and DNS must exist. Change Service_Name to correct name (SID).


Or you want to make a remote database link connection insight the database – when you use the command CREATE DATABASE LINK.


Regards
Allan

 

[teknikalbody]

Allan hi,

Im really sorry for asking silly questions but I am a complete novice to this, can you help with the following questions :

1) what / where is the local net service name configuration (TNSNAMES.ORA).

2) how do I hide a copy of the file before changing.

3) If have the IP address ex. 555.555.55.55 wat exactly do I write in the file you gave example of.

4) how do find the server name and check the DNS exists.

Regards,
feeling stupid oracle beginner

 

[AOLEURO]

Hi

We all started at the beginning.

I assume that you have an Oracle Client installation on your PC (because you can access ONECOOL server).

We old Oracle people often change parameter and configuration files directly without use of Oracle tools. It was because Oracle did not have GUI tools when we began. But now it is different because with Windows platform Oracle has created lots of GUI tools.

Ad 1:
------
I assume that you are using Windows on your PC.
Before we can start – you got to know some few details.

1. You got to know the IP number or Name of the server where TWOCOOL are placed. You can get the number directly on the server – make a PROMPT and write PING ServerName where ServerName is the name of the server. The server responds by giving you lines and you can then se the IP number (XXX.XXX.XXX.XXX). Then make a DOS prompt on your PC and write PING XXX.XXX.XXX.XXX for IP number or PING ServerName.
Ex. PING 168.212.54.32
Ex. PING ServerName

If PING ServerName works – then use ServerName instead of IP number.

2. Later we must create a connection to TWOCOOL – and we need a Service Name (SID) name. You have to know this ID from the server – or from the DBA creating the database. If standard installation – then the name is ORCL. It is possible to see the information on the server in the file LISTENER.ORA.

Ok let’s rock:

1. On your PC - you got a menu item “Oracle xxxx”. And you got a submenu “Network Administration” and you got an item “Net8 Configuration Assistant”.

2. Then started you get a menu with items like “Listener configuration” – and you also got Local Net Service Name configuration.

3. Then marked and press next, you got again a menu with “Add, Reconfigure, Delete, Rename and Test”. You want to ADD.

4. Then marked and press next you have to make a decision where your connection is for an 8i and later database or 8.0. You press next if 8i database is used.

5. Now you got to give the name found earlier and press next.

6. Select TCP as your network protocol and press next.

7. You ether insert an IP number or give the name of the machine in the HOST field found earlier.

8. You can change the default port where Oracle is trying to “hear” your attempts to connect. Just press next.

9. You can now test if the information giving is correct. Mark yes and press next.

10. Oracle now try to make a connection with SCOTT/TIGER – if this demo user are not installed or password is wrong, Oracle return a error message and can’t make a connection. You then press Change login and change username and password.

You have to have a successfully connection – or you will not be able to connect in SQLplus or other applications. Use BACK to go to early steps and change information.

11. Then connection is ok and press next you now have to give the connection a name. This name is used then you want to connect to TWOCOOLS and it is the connection string (ex. if you connect to ONECOOL in SQLPLUS (Username=System, password=xxxxx, hoststring = ONECOOL) when write TWOCOOL). And press next.

12. You can now make a new connection or stop. Press next some times and press Finish.

You have now created a connection to your TWOCOOL database. Now test the connection with SQLPLUS.

The entire above are saved to the file TNSNAMES.ORA.

You can find the file ether by looking at your Register information or make a DOS prompt and write DIR C:\TNSNAMES.ORA /S - try all drive letters you have access to (C, D, ..) until you find a file.

You do not need a copy of the file then doing the above – otherwise I recommend that you made a copy of the file to a save place.


Regards
Allan
Icq: 346225948

 

[teknikalbody]

Allan,

U have been most helpful ...Thank you... it has been much appreciated.

Kind regards,

A happy new beginner