Hi, all!
Good day to you!
This content is a method to deal with the problem that database error message on BMU webpage.
Problem description
Customer reported that he got the below error message whenever he press any of the left tabs on the BMU web page.
Solution Description
1. We confirmed the version of the BMU with the customer and he said it is V300R001C00SPC200.
2. We confrmed the network topology and he send us the below snapshot.
Customer confirmed all of the UC servers are active and standby and this is centralized UC and distributed IPT
Databse servers are Oracle 11g based / linux
3. We confirmed if he can ping from the BMU SSH to databse servers and vica versa like ping from databse servers to BMU and these was wokring fine , no issue on ping so no network issue.
4. We confirmed the BMU status as below command as below results state that the BMU is running fine with no issue.
5. We confirmed which mode is the cluster working with as per below command and the results states that it is RAC mode.
NOTE : in oorder to make the below command , you need to login with oracle user first with then to sql by the below 2 commands
su - oracle
sqlplus / as sysdb
6. We confirmed the status of the databse servers as below command and it states that both databse servers are running fine.
7. We have to check the resources of the database by the below command also with the grid user
crsctl stat res -t
The results is good except the highlighted part which states that there are stucked archived logs on the oracle server
8. As a result of the above command we have to check the space capacity with the below command.
asmcmd lsdg
NOTE : you have to log with the oracle user first them make this command
The below results indicated that the archived log partition is occupied which is the first row and the second row by the way is the back up partition.
Solution
As a result we need to delete the audit and archived logs on the oracle server with the below steps
1. Use SFTP as the root user to upload the cleanDBLog.sh script in binary mode to the /opt/oracle directory on the database server.
2. Log in to the database server as the root user.
3. Grant the execute permission on the cleanDBLog.sh file.
cd /opt/oracle
chmod +x cleanDBLog.sh
4. Add a crontab scheduled task, save the task, and exit.
crontab -e
00 00 * * * /opt/oracle/cleanDBLog.sh >/opt/DBDeleteLog 2>&1
The preceding command indicates that the /opt/oracle/cleanDBLog.sh script is run at 00:00:00 every day and the script execution logs are saved to the /opt/DBDeleteLog directory.
5. Use SFTP as the root user to upload the cleanArchivelog.sh script in binary mode to the /opt/oracle directory on the database server.
6. Log in to the database server as the root user.
7. Grant the execute permission on the cleanArchivelog.sh file.
cd /opt/oracle
chmod +x cleanArchivelog.sh
8. Add a crontab scheduled task, save the task, and exit.
crontab -e
00 00 * * * /opt/oracle/cleanArchivelog.sh >/opt/DBDeleteArchiveLog 2>&1
The preceding command indicates that the /opt/oracle/cleanArchivelog.sh script is run at 00:00:00 every day and the script execution logs are saved to the /opt/DBDeleteArchiveLog directory.
Finally after making the above steps we have tried to login the BMU web page again and we can access all of the services succesfully
NOTE: please find attached the files for cleaning the audit and archive logs on oracle databse servers
Thanks for reading!
