Thursday, October 22, 2015

Re: New Student Warehouse Servers

Good afternoon-

The process to move the databases to the new servers is complete and extracts that were already scheduled should proceed tonight/tomorrow as normal.  If you have any difficulties getting into the website or via your normal reporting mechanisms, please get in touch and I’ll try to get you squared away.

 

Thank you for your patience during the downtime.

 

John

 

From: Thunstrom, John
Sent: Monday, October 19, 2015 10:19 AM
To: 'MACRAO@LISTSERV.GFCMSU.EDU'
Subject: New Student Warehouse Servers

 

Good morning-

Just a reminder that I’ll be migrating the student warehouse to new servers on Thursday (10/22).  The warehouse will be unavailable most of the day, but should be back up in time to run extracts in the evening.  I’ll send out a notice when it is back up and running. 

 

The web clients will now be located at:

 

UM

http://ochesdwp.msu.montana.edu:7777/umsdwp/owa/twgkwbis.P_WWWLogin

 

MSU

http://ochesdwp.msu.montana.edu:7777/msusdwp/owa/twgkwbis.P_WWWLogin

 

 

For those of you who do reporting against the warehouse, the following changes will be required for your tnsnames entries if you do not have a centrally managed tnsnames file:

 

UM Test:

  HOST = ochesdwt.msu.montana.edu

  PORT = 1521

 SERVICE_NAME = UMSDWT 

 

UM Production:

  HOST = ochesdwp.msu.montana.edu

  PORT = 1521

  SERVICE_NAME = UMSDWP

 

MSU Test:

  HOST = ochesdwt.msu.montana.edu

  PORT = 1521

 SERVICE_NAME = MSUSDWT 

 

MSU Production:

  HOST = ochesdwp.msu.montana.edu

  PORT = 1521

 SERVICE_NAME = MSUSDWP 

 

If you need any assistance making these changes or have any questions regarding the switch, please don’t hesitate to shoot me an email or give me a call.

 

Thanks,
John

 

 

John Thunstrom

MUS IT Director

Office of the Commissioner of Higher Education

(406) 544-3822

jthunstrom@mso.umt.edu