on 03-25-2010 9:50 PM
Hello,
I installed EHP1 SPS20 in Solution Manager, but I have been trying to configure DBA Cockpit, but i don't understand how to do it, I have been looking for some documents but i didn't find anything. Please if you know how to do it please give me some help.
Thanks!!!!
Hi,
Have you referred the following useful documents ?
[Sap Solution Manager u2013 Dbacockpit Setup|http://s3.amazonaws.com/ppt-download/sapsolmaninstguidedbacockpitsetup-1225699325796243-8.pdf?Signature=r%2BpHgriq25S0r571woYvEBSNGbQ%3D&Expires=1269576741&AWSAccessKeyId=AKIAJLJT267DEGKZDHEQ]
[Database Administration Using the DBA Cockpit: Oracle|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f079d393-a806-2a10-84a4-d821d4ee092c?quicklink=index&overridelayout=true]
Regards,
Bhavik G. Shroff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thanks for your help, I've been reading the document "Database Administration Using the DBA Cockpit: Oracle", I'm trying to configure DB Connections but I don't understand the Connection Parameters table:
TNS Name: it is the name configured in TNS name, is it? but.... In wich system? all configuration needs to be done in Solution Manager? it is necesary to add all satellite systems in tnsnames.ora???
Character Set: I don't understand what it is
National Character Set: I don't understand what it is
If you know about this please help me
Thank you very much!!!!
P.D.: I don't know wich user do i need to use in DB Connections, i used my sap user, orasid...
Edited by: Jaime Yanez on Mar 26, 2010 9:17 PM
Hi,
You need to do all configuration in Solution Manager.
TNS Name: it is the name configured in TNS name, is it?
Yes, TNS name is the listner name of target system which is also configured in your solman's tnsnames.ora
"/sapmnt/<SID>/profile/oracle/tnsnames.ora". it is usually <SID> of your target system.
Character set : Not mandatory..
User: sapr3 or system /password
Regards.
Rajesh Narkhede
Hi,
Please see if both tnsnames.ora files are identical and make sure that there is no space before SID.
/sapmnt/<SID>/profile/oracle/tnsnames.ora
/oracle/<SID>102_64/network/admin/tnsnames.ora
Above files should be identical.
Also check if SAPSR3 or SYSTEM users password is correct for target system.
Regards.
Rajesh Narkhede
Thanks for your help...
Now I think it works, but I don't understand when I use solman_setup to configure the last part for activate DBA COCKPIT it shows:
DB connection Id :xxx
Connectivity test : (Green)
Database history : (Yellow) Not supported for this DB platform
Extractors activation :(Yellow) The DB performance warehouse is not available, thus the DB extractors were not activated
It is normal? what does it mean?
Thanks
Edited by: Jaime Yanez on Mar 31, 2010 9:55 PM
Dear Jaime,
You can refer the below helpful notes for your task.
[Note 1256322 - Establishing a remote database connection in DBACOCKPIT|https://service.sap.com/sap/support/notes/1256322]
[Note 1028624 - Overview of DBA Cockpit for Oracle|https://service.sap.com/sap/support/notes/1028624]
[Note 1261329 - DBA Cockpit: Oracle as a remote database|https://service.sap.com/sap/support/notes/1261329]
Regards.
Rajesh Narkhede
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.