The other day I was helping out the network engineers install an Arc Serv Backup agent on one of our servers for them to manage backups and restores for that server. I installed the Arc Serv agent for the server on the Red Hat Linux server without any problems but when it came to installing the Oracle backup client, it overwrote all the oracle environmental variables. thus ending up in crashing the whole production database.
It initially didn’t give any problem. the problem became prominent only after a few minutes when our customers were having trouble. I and the team then worked on the troubleshooting of it. And in the end we figured it out and manually setup the Oracle_home variable to fix everything on the oracle production server.
Thank god we were able to figure out the source of the problem in a short time, it took only 1 hour to startup the oracle server back. I got a chance to explore Oracle setup to fix this issue.
“We learn from our mistakes, so we have to make some mistakes” 🙂