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]
Bhavik G. Shroff
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
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
Please see if both tnsnames.ora files are identical and make sure that there is no space before SID.
Above files should be identical.
Also check if SAPSR3 or SYSTEM users password is correct for target system.
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?
Edited by: Jaime Yanez on Mar 31, 2010 9:55 PM
Is your issue solved ?
I am also having the same issue ,Please let me know how to solve it ?
Database history : Not supported for this DB platform
Extractors activation :The DB performance warehouse is not available, thus the DB extractors were not activated
Thanks in advance.
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]