Last Updated on Thursday, August 09, 2001 at 09:13:52. by Author: Bolek Wyslouch

Web and Database, Super Expert Information

(This is really for experts only, do not try to do it yourself without expert around or on the phone)

Contents

• Web server is hanging, what to do ?
• How to check if Oracle is alive?
• What to do if the database has crashed?
• How to contact author

Web server is hanging, what to do ?

How to check if Oracle is alive?

The indication: both web servers, online clients and reconstruction jobs cannot connect to database. On the web portal there is "Database not available" message or something similar. This is different from hanging web server where there is nothing displayed in *.asp scripts.

You are in Counting House:

First check if the database is there at all:

• Go to the electronics room, left side.
• Select the monitor to point to the BOTTOM (PHOBOSCH) server.
• Logon as an Administrator (or use the open window).
• Open DOS command window:
• SVRMGR30
• Logon to the database by typing:
  SVRMGR>connect webuser
  Password:xxxxx
  SVRMGR>select sysdate from dual;
• If you see today's date then things look promising,  the database is OK but there might be network problem in accessing the database. 
• Remember that for the network to work there must be a "Listener" service running on the database NT box. Check Windows services to see if it is running. Restart this service if not.

Check if all disks are there:

• Find Oracle Toolbar on top of Desktop. (If top of desktop is empty start Administrator Toolbar by clicking on Start ->Programs->Oracle Enterprise Manager->Administrator Toolbar). 
• Click on "Storage" icon to open Oracle Storage Manager.
• In the Storage Manager click once on "Tablespaces" You should see a list of tablespaces with colored bars next to each of them. There needs to be word ONLINE next to each tablespace. If you succeeded to see ONLINE words then everything is fine.

You are not in the Counting House

On a Linux box (e.g RCF) do:

[rcas4009]wyslouch>tnsping phdb
TNS Ping Utility for Linux: Version 8.0.5.0.0 - Production on 08-AUG-01 17:34:05
(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 (20 msec)

This means that the network is fine. Now check if the database is mounted.

Connect to database and execute simple command to get today's date:

[rcas4009]wyslouch>sqlplus webuser@phdb
SQL*Plus: Release 8.0.5.0.0 - Production on Wed Aug 8 17:35:44 2001
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Enter password: xxxxxx
Connected to:
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
SQL> select sysdate from dual;
SYSDATE
---------
08-AUG-01
SQL> 

If the database or the network don't seem to work then you need to go to the counting house and start from there.

What to do if the database has crashed.

Try to call Bolek, if you cannot reach him sit down and cry.

After you have recovered inform everyone to point their machines to the old database server that is standing by.

Follow the instructions on how to change Oracle IP address on client machines.

Remember that you need to modify TNSNAMES.ORA translation files on:

DAQ computers
All Windows computers in the counting house, including phobosdb and phobosch
All Linux boxes in the counting house
RCF machines

The instructions are given in a separate web page. There is no need to reboot machines after this change is done. 

There will be a temporary mess since lots of data will be missing from database. In particular the DAQ: run logbook etc will only work for runs taken after the database switch