CDS email message - CDS/10/09/24/a

Sent 24 Sep 2010

Change now needed to run CDS Accord Database Explorer


As a result of the recent Oracle server software upgrade, you
need to make a small modification to the Accord Database 
Explorer client setup.

This involves making a small change to the Oracle client file, 
located on the Windows PC, in order for it to operate again.

The file that needs changing is the Oracle file "tnsnames.ora" to be found
in the \network\admin folder e.g. c:\oracle\network\admin\tnsnames.ora
but it may be located elsewhere on your system.

The ACCORD3.DL.AC.UK PORT number needs to be changed from 1521 to 1522

i.e. the existing entry :

ACCORD3.DL.AC.UK =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = cds10.dl.ac.uk)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ACCORD3.dl.ac.uk)
    )
  )

becomes :

ACCORD3.DL.AC.UK =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = cds10.dl.ac.uk)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ACCORD3.dl.ac.uk)
    )
  )

If you do not have write access to the tnsnames.ora file, then you will 
have to arrange with your local system administrator to do it for you.

Please email us at the usual address if you have trouble making the change.

We apologise for the inconvenience that this will cause.


You can follow the details of our plan of action via the News Page:

http://cds.dl.ac.uk/cgi-bin/news/disp?service_changes

	  
We will also provide links to this information on the CDS homepage:

http://cds.dl.ac.uk/

	  
For the most up to date information follow our Twitter or RSS feed. You can
access this information via the link:

http://twitter.com/cds_daresbury

	  
You do not need to register for the Twitter service to access this
link. 
Return to message archive