Maurice’s Blog

From: Schumacher, Mike (HAL)
Sent: Tuesday, February 14, 2012 3:52 PM
To: Ruckman, Maurice (HAL); McConnell, Chris (HAL Contractor)
Cc: HAL DistList: IS UNIX; Augustine, Anila (HAL)
Subject: RE: ezAir application URL does not work anymore

Maurice,

Can you try the ezair test again. On the second link I’m getting an error.

Linux firewalls are NOT your friend!!! When Harold rebooted the server on Friday iptables started and was blocking all traffic.

Mike

From: Ruckman, Maurice (HAL)
Sent: Tuesday, February 14, 2012 8:57 AM
To: McConnell, Chris (HAL Contractor)
Cc: HAL DistList: IS UNIX; Augustine, Anila (HAL)
Subject: ezAir application URL does not work anymore
Importance: High

I can get to the admin console, but the link to the ezAir webapp no longer works:

Links that used to work on Friday:
http://haltstapp03/airadmin/login
https://ht.hq.halw.com/airadmin

I don’t know if this is related to the SSL problems we’ve been having, but any help would be much appreciated.

Other Stuff:

I had the Dave give permissions to the user in the database to hopefully fix the problem, no luck, we may need to delete some transaction files listed in the article instead:

http://www-01.ibm.com/support/docview.wss?uid=swg21196663

Excerpt:

To remove the transaction logs, do the following:
(1) Stop the server.
(2) Delete the 'transaction' folder and all subdirectories.
(3) Restart the server.
The above exceptions will no longer occur.

From: Risley, David (HAL)
Sent: Tuesday, February 14, 2012 8:39 AM
To: Risley, David (HAL); Ruckman, Maurice (HAL); HAL Service Request Center (HAL)
Cc: HAL DistList: IS DBA; Augustine, Anila (HAL); Harrington, Scott (HAL Contractor); Fernan, Diana (HAL Contractor); Tonks, Kristen (HAL); Konar, Tara (PCL)
Subject: RE: Please Open ticket for EZAIR Database on WebTst with DBA's

Grants made to user EZAIR in database TSTWEB

grant select on pending_trans$ to ezair;
grant select on dba_2pc_pending to ezair;
grant select on dba_pending_transactions to ezair;
grant execute on dbms_xa to ezair;

DaveR

"Peace" - is the message really so hard to understand?

From: Risley, David (HAL)
Sent: Tuesday, February 14, 2012 7:58 AM
To: Ruckman, Maurice (HAL); HAL Service Request Center (HAL)
Cc: HAL DistList: IS DBA; Augustine, Anila (HAL); Harrington, Scott (HAL Contractor); Fernan, Diana (HAL Contractor); Tonks, Kristen (HAL); Konar, Tara (PCL)
Subject: RE: Please Open ticket for EZAIR Database on WebTst with DBA's

Maurice,
We'll still need a security request that defines which database name and which user name to run the privileges for.

DaveR

"Peace" - is the message really so hard to understand?

From: Ruckman, Maurice (HAL)
Sent: Tuesday, February 14, 2012 7:53 AM
To: HAL Service Request Center (HAL)
Cc: HAL DistList: IS DBA; Augustine, Anila (HAL); Harrington, Scott (HAL Contractor); Fernan, Diana (HAL Contractor); Tonks, Kristen (HAL); Konar, Tara (PCL)
Subject: Please Open ticket for EZAIR Database on WebTst with DBA's
Importance: High

This is considered a work stoppage and should be resolved today.

The WebSphere application is throwing an error, that hopefully updates to database permissions will correct.  The user for the database defined in the application, is ezair.

Here’s are original article:
http://www-01.ibm.com/support/docview.wss?uid=swg21196663

Excerpt steps from article, it would probably be best to use the original article though.

The solution is to give the Oracle user permission to perform the recovery, specifically to access the internal Oracle tables used to manage recovery.
This problem can occur with all versions of Oracle: 8i, 9i, 10g, and 11g.

Run the following commands as user SYS:

Thanks,

Maurice Ruckman
Voice: (206) 626-7497 x67497
Cellular: (206) 650-7576