[Sqg-program] CHAZSQG: Upcoming Oracle Database Upgrade - ORAPROD details

[Perrigan, Glen]

Hi All

 

For those that use CHAZSQG and SQG Reports there will be a major upgrade to
Oracle Forms this weekend. See messages below for details. This may impact
both CHAZSQG and SQG Reports. If you see some crazy stuff please let me know.
Be as specific as possible on how you describe the problem. Do a screen
capture ("Alt" key + "Print Screen" key on your keyboard) if an error message
pops up on your application. Thanks.

 

Glen Perrigan
Florida Department of Environmental Protection
Hazardous Waste Management Section
2600 Blair Stone Road  MS-4555
Tallahassee, Florida 32399-2400
850-245-8749 Fax:  850-412-0528
E-mail: glen.perrigan at dep.state.fl.us
Website:   www.dep.state.fl.us/waste <http://www.dep.state.fl.us/waste> 

  _____  

From: Ray, Steve 
Sent: Wednesday, August 01, 2007 5:10 PM
To: Subject: FW: Upcoming Oracle Database Upgrade - ORAPROD details

 

Good afternoon everyone,

Please read the announcements below about major upgrades to Oracle production
applications this weekend.  All production Oracle reports on the Internet and
DEPNET as well as all Oracle applications will be impacted and will be down
for the time frame specified below.  So, for this weekend, all Oracle work is
off.

 

When you come back to work on Monday morning, please check out your
applications that use Oracle to see that they are working properly, beginning
with public service type reports on the Internet, so that we can identify and
correct any problems.  This would include things like MapDirect, Solid Waste
facility Locator and associated reports, Hazardous Waste Handlers and
Transporter reports, Used Oil and Mercury handler reports, and associated
management reports, etc.  Also, on Monday morning, please check out your
regular internal Oracle application access, including WACS, CHAZ, FIESTA, PA,
Oculus, COMET, LCT and anything else you can think of.

 

If you aren't an Oracle user, then this will not impact you.

 

Please let me know Monday, first thing, if you do find any problems with your
database applications so we can report them and/or fix.

 

Thanks,

Steve

 

  _____  

From: Wanner, Farrah 
Sent: Wednesday, August 01, 2007 9:33 AM
To: techreps
Cc: Canter, Jon
Subject: Scheduled System Maintenance 8/3/07-8/5/07

 

Scheduled Systems Maintenance:  

Please notify all users that production database services will be down for
all applications this Friday night (8/3) from 6:00pm through 8:00pm Sunday
evening (8/5).

This impacts the following services and applications: 

*         CA/MapDirect

*         ArcIMS Mapping sites: Self-cert, Webpoints, WebShapeLite

*         All Doppler activity including adhoc queries

*         All reports running on APPPROD.DEP.STATE.FL.US accessing Doppler

*         Oracle Forms Data Entry (ORAPROD)

*         Java Application Data Entry (ORAPROD)

*         Transactional ASP applications on APPPROD

  _____  

From: Gorton, Donna 
Sent: Wednesday, August 01, 2007 9:39 AM
To: O'Donnell, Danny; Carney, Christopher; Zimmerman, Jeffrey; Judd, Chris;
Carter, Angel; BIS Developers; 'jhs-mail at lists.dep.state.fl.us'; Watts, John;
Cristofari, Marco; Erimez, Esra; Stanton, John; Robertson, Tom; McCord,
Scott; Sears, Shelley; Harte, Tammy; Byrd, Katherine R.
Cc: HelpDesk; DBA; Strauss, Lisa; Doker, Joe; Woodburn, John; Alsop, Penny;
Study, Kenna; Lamkin, Gayle; Strivelli, Shandi; Walker, Elizabeth (AIR);
Kennedy, Barbara; DalBon, Suzanne; Oblin, Carolyn; Castellina, Nancy; Tyahur,
Christi; Bantanur, Vijay
Subject: Upcoming Oracle Database Upgrade - ORAPROD details
Importance: High

 

All,

 

The DBA section will be upgrading the ORAPROD database instance this weekend;
production database services will be down for all applications this Friday
night (8/3) from 6:00pm through 8:00pm Sunday evening (8/5).

 

A confirmation email will be sent out when the upgrade is complete.  Please
do not access ORAPROD, CA/MapDirect, WebShape Lite, or DOPPLER until the
upgrade has been confirmed.  On Monday morning you will need to modify your
TNSNAMES.ORA file to update the port on the ORAPROD entry to 1527.

 

*****Important Instructions for Java Developers******

*            Java Applications with an embedded connect string to ORAPROD
will need to be adjusted for the port (1527) and scheduled for deployment by
the DBAs on Friday night.

*            JhsSso and SSO-Client will be modified for the new ORAPROD port
and scheduled for deployed on Friday night.

 

Application Leads: Please schedule staff to check on your applications after
the upgrade is complete either late Sunday afternoon or early Monday morning!

 

*         The DBAs will complete the following this weekend:

*         Modification of the ORAPROD port to 1527 on the epic229
data-sources.xml.

*         Modification of the DSN entry for ORAPROD on APPPROD and
WWW.DEP.STATE.FL.US <http://www.dep.state.fl.us/> .

*         Modification of the TNSNAMES.ORA entry for ORAPROD on all relevant
servers.

*         Refresh the snapshots on DOPPLER after the upgrade is complete on
Sunday.  

 

Donna Gorton, PMP

Florida Department of Environmental Protection

Office of Technology and Information Services

Data Processing Manager

Phone:  850.245.8258

Donna.Gorton at dep.state.fl.us <mailto:Donna.Gorton at dep.state.fl.us> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.dep.state.fl.us/pipermail/sqg-program/attachments/20070802/bbbf172f/attachment-0001.html