This topic has been locked.
5 replies Latest Post - 2013-03-19T02:27:37Z by SystemAdmin
Pinned topic Step-by-Step Guide to monitor Oracle ASO
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Hi, I'm seeking for a details configuration guide, preferably with step-by-step instruction on how to configure inspection for Oracle ASO. My Oracle is 11g on AIX 5.3. The user guide is confusing and not precise so need some advise here.
Updated on 2013-03-19T02:27:37Z at 2013-03-19T02:27:37Z by SystemAdmin
JoyceTannous 270003E3EM3 PostsACCEPTED ANSWER
Re: Step-by-Step Guide to monitor Oracle ASO2012-02-16T20:37:17Z in response to SystemAdminHi,
In order to capture oracle ASO traffic for AIX 5.3 we need to install STAP and add an inspection engine for this oracle then we need to activate ATAP using guardctl utility. In order to activate ATAP:
- stop oracle database
- Full path to guardctl and give it the parameters: db-instance, db-home, db-type, db-user, db-version, ex:
- instrument the database ex:
- activate ATAP ex:
- restart oracle
Re: Step-by-Step Guide to monitor Oracle ASO2012-02-17T01:53:53Z in response to JoyceTannousHi Joyce,
May I know if the customer has multiple instances in the Oracle, should I run it multiple times:
/usr/local/guardium/guard_stap/guardctl db-instance=oracle_Instance1 db-home=oracle_Home db-type=oracle db-user=oracle_User db-version=Version_Of_Oracle store-conf
/usr/local/guardium/guard_stap/guardctl db-instance=oracle_Instance2 db-home=oracle_Home db-type=oracle db-user=oracle_User db-version=Version_Of_Oracle store-conf
/usr/local/guardium/guard_stap/guardctl db-instance=oracle_InstanceX db-home=oracle_Home db-type=oracle db-user=oracle_User db-version=Version_Of_Oracle store-conf
For Oracle_user, is which user do we referring to? And, what roles should the Oracle_user required?
The Version_Of_Oracle is just a symbolic only, right? For instance, I just enter as 10 or 11 only, right?
Re: Step-by-Step Guide to monitor Oracle ASO2013-03-08T12:07:28Z in response to JoyceTannousHi,
May I know do I need to perform the following task as stated in the IBM document - http://www-01.ibm.com/support/docview.wss?uid=swg21598026
- Running the guardctl command relinks two libraries to the oracle executable, for example:
/usr/local/guardium/lib/libguard-atap-oracle-any-32.a in /usr/lib
/usr/local/guardium/lib/libguard-atap-oracle-any-32.so in /usr/lib
- If the software is installed with GIM, make sure that environment variable GIM_ROOT_DIR is set to ATAP expects GIM_ROOT_DIR to the <guardium_base>/modules directory (absolute path). Guardium S-TAP must be restarted after setting this variable.
Re: Step-by-Step Guide to monitor Oracle ASO2013-03-14T15:42:07Z in response to SystemAdminGuys,
The guide provided by IBM in the link is not working and the command are wrong. I'm currently working with IBM support on this matter. Once, I have the proper set of command and tested working, I will post it here.
Re: Step-by-Step Guide to monitor Oracle ASO2013-03-19T02:27:37Z in response to SystemAdminA new update, do anyone here knowing what is this error message mean?
1. Oracle on AIX has to use instrumentation
2. ERROR: Database has not been instrumented yet - please run 'instrument'
IBM L3 gave me the new set of command to run and I got the above error message.
You know what, IBM support suggest me to setup the similar environment to do my own testing or engaged paid services from IBM to do the testing. What a silly suggestion when a principle can't even provide a proper guide to proof their product does support on what they claim to be.