on 08-30-2015 12:28 AM
Hi experts,
I am trying to take a complete backup of one of my livecache database from DBA planning calender. It is failing with below error.
MEDIANAME 'Pre_index_rebuild'
*** SAVE/RESTORE request accepted:
OK
*** SAVE/RESTORE result:
ERR
-24988,ERR_SQL: SQL error
-903,Host file I/O error
3,Data backup failed
113,Open medium on /sapdb/LCA/sapdata/DISKD0006 for READ failed
1,Open file /sapdb/LCA/sapdata/DISKD0006 failed, open(READ,EXISTING) returned 'Too many open files' (24)
*** SAVE/RESTORE request:
SAVE DATA CANCEL
*** SAVE/RESTORE request accepted:
OK
*** SAVE/RESTORE result:
ERR
-24988,ERR_SQL: SQL error
-104,DBM command impossible at this time
*** DBA Action ends:
Timestamp: 20150829225656 State
I have tried by creating new media template but the result is same. I am not able to find much useful logs in livecache log files. Please suggest.
Thanks
Amar.
Backup started running normally after system restart.
Thanks
Amar.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Amar,
as you saw in the first your post:
"1,Open file /sapdb/LCA/sapdata/DISKD0006 failed, open(READ,EXISTING) returned 'Too many open files' (24)"
There were too many files opened by liveCache processes and the limit is reached, so after you restarted the liveCache the resources were released & you was able to create the backup.
- Need to check the xserver prt and dbmsrv prt of the liveCache
- Review the SAP note:628131 - SAP MaxDB/liveCache operating system parameters on UNIX
there is information/explain/recommendations on the parameters settings for "Maximum number of open files (maxfiles, nofiles)".
And SAP note, if liveCache is rinning on Solaris 10 and above:
724713 | Parameter Settings for Oracle Solaris 10 and above |
Regards, Natalia Khlopina
Hello,
- Review the hints in the SAP notes:
1879507 - MaxDB: shmat error, Too many open files
1659328 - Various problems with X server that is incorrectly started
- What is the version of the liveCache & OS platform of the liveCache server?
Best regards, Natalia Khlopina
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amar,
Could you check the file limit configuration under /etc/security/limits.conf
You are experiencing error as the max limit for open files is reached.
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amar,
Can you paste the dbm.ebp & dbm.ebl files here too see exact error you can find those in your /sapdb/<SID>/data/wrk or /sapdb/data/wrk directory directory.
Regards,
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.