Table /AIF/PERS_XML is huge in our production system. We are working on clearing it out but it is not going to be easy.
The problem is amplified by system copies to our training, pre-prod, performance, QA and sandpit systems.
Question 1:
Is it ...
The AIF XML Persistence LOB table in Oracle can grow very fast.
We plan to clean out the dirty messages (whatever they are - what causes them?) then archive the remainder appropriately.
Tricky bit is working out what "Appropriately" means.
Can ...
Objective:I am trying to get brconnect to run a check on a RAC system. I am logged in on the RAC as <sid>armProblem:"brconnect -u / -c -f check" fails with a confusing miasma of errors, but basically "connect to instance PRD1 failed""brconnect -u /@...
I have been asked to install a test solution manager on SLES 11. I have downloaded the evaluation copy and installed it. The download page promised a 60 day evaluation license that apparently provides access to OS updates and the SAPCONF package.Th...
And another thing: uid=1027(prdadm) gid=1004(sapsys) groups=1004(sapsys),1005(oinstall),1006(oradba),1107(dba),1008(oper),1009(sapinst),1010(asmoper),1012(asmdba)So <sid>adm belongs to dba, oper, asmoper, asmdba.The system in question is an OEL Linux...
I also accidentally discovered this:If brconnect is owned by <sid>adm:sapsys then"brconnect -u / -c -f check" connects and runsbut it cannot access the ASM disks and fails early on.
I did not mention that both tnsnames/sqlnet versions work exactly the same way:brconnect -u system/password@PRD worksbrconnect -u /@PRD cannot log onbrconnect -u system/password cannot connectbrconnect -u / cannot connect.
SS,Thank you for your reply.I have a license for the solution manager. What I need is the Evaluation Activation code for SLES11.This allegedly allows the operating system to be patched and configured with the SAPCONF rpm so it can be evaluated meani...
Solved it - Cleaned out the CMS and AUD databases.There is an option "Reset existing database" which I did not select.Once the database was reset, everything worked fine!So the procedure is:1691555 - How to completely remove / uninstall SAP BO BI 4.0...
