To start using a new database All users using database will need to modify an ASCII configuration file on their computers that translates internal Oracle name to IP address.
All our systems accessing main Phobos database use internal Oracle name PHDB. The IP address assignment of this name will need to be changed on every single Phobos computer !
The file is called tnsnames.ora and it is usually found in:
UNIX (you must be root to modify this file)
$ORACLE_HOME/network/admin/tnsnames.ora
or Windows
c:\orant\net80\admin\tnsnames.ora
the green part can be different for different Windows installations. You can search for tnsnames.ora on all your disks. Remember to ignore sample file in \Samples\ directory.
Present tnsnames.ora should contain the following translation of Oracle address PHDB:
(Outside counting house)
PHDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = phdb.phobos.bnl.gov)
(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORC1)
)
)
or (inside counting house)
PHDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 130.199.65.6)
(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORC1)
)
)
The HOST and only HOST address should be changed to point to the new address:
130.199.177.22
The new lines should read:
PHDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 130.199.177.22)
(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORC1)
)
)
There is quite a bit of other parameters that may have been defined next to Host, port etc. Do not touch anything, leave it as is and change only HOST name. If it worked before it will work later.
1) Locate tnsnames.ora on your computer. Display it, see if you can recognize the IP address in the translation of PHDB.
2) Some installations of Oracle client have useful debugging tool, oracle equivalent of PING. Try to see if it is installed on your computer. $ORACLE_HOME/bin must be in your path or specify the full path. Some Windows installations use name TNSPING80.
tnsping phdb should give Oracle response. On RCF Solaris machine this will give:
[rcf]wyslouch>tnsping phdb
TNS Ping Utility for Solaris: Version 8.0.5.0.0 - Production on 30-APR-01 08:41:19
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=phdb.phobos.bnl.gov)(Port=1521))
OK (30 msec)
tnsping is not available on RCF Linux machines.
After having received an e-mail announcement
1) Modify tnsnames.ora file.
2) Try tnsping from your machine. You should see new IP address
[rcf]wyslouch>tnsping phdb
TNS Ping Utility for Solaris: Version 8.0.5.0.0 - Production on 4-MAY-01
16:00:00
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=phdb.phobos.bnl.gov)(Port=1521))
OK (30 msec)
3) Try to run phat and execute your favorite analysis program to see if it can access the database. If there is a problem phat will be hanging with no error message.
The switch of database will create major disruption. There will be data missing from the time of the last cold backup. The recovery of most recent data is possible but it will take some time, maybe a week or so. At the end of recovery the old and new data will be put together. depending on the severity of the crash an hour or two days of data may be lost.