DBA COCKPIT IS NOT CONNECTED IN MANAGED SYTEM

[Former Member]

hi

unable to connected the manged system dba cockpit from the solman7.1 sp10. i have attached the screen shot. please can any one guide me how to

  solve the issue. it was given error db connection not established.

regards

vreddy

[Former Member]

Hi Experts,

I am not able to turn the step 5 to green Dbacockpit connection.

Error message:

The DBACockpit connection can not be established

The DB extractors for collecting DB Performance data will not be activated.

Error during SQL script execution. Start DBACOCKPIT and re-run manually.

When i run the script manually from DBACOCKPIT. it throws the error attached in

Your help to resolve the below issue highly appreciated.

Regards

Ravi Pandey

[patelyogesh]

Hello

I had same issue and I was able to resolve this issue looking at document below

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/305e389d-cb28-2f10-d799-b69dd0525f84&override... 

Note: Username and password is case sensitive for this setup

For Repair:

For Remove:

Regards,

Yogesh

[Former Member]

Hi,

But you can get sapnote or config document for MSSQL server too, have you checked the sap note 1458291 - SolMan 7.1 Database Warehouse & Alerting for MSSQL , step IV.   Setting up the Database Connection

Thanks

Jansi

[Former Member]

Hi,

you can try manually instead of wizard, Please follow the guide Sap Solman Instguide Dba Cockpit Setup

For wizard also, you need to change the tnsnames.ora as described,

refer the notes 1744830 - How to reset DBACockpit settings in order to rerun the Solution Manager Wizard

1261329 - DBA Cockpit: Oracle as a remote database

Thanks

Jansi

[Former Member]

Hi

we are using mssql2008r2

regards

vreddy

[karthikeyan_natarajan4]

Hi Veera,

Have you tried to input your connection entries in DBCON.

regards

kartik

[former_member186895]

HI

Create a user in msssql with ROLE SYSADMIN and provide that username and password in db parameter.

Thanks

Ramesh yadav

[karthikeyan_natarajan4]

Hi Veer,

Goto SE38 and run ADBC_TEST_CONNECTION , select your managed system database connection name and paste the results.

regards

kartik

[Former Member]

HI

[karthikeyan_natarajan4]

Hi Veera,

Goto SE16, input DBCON in the table name field, and lookout for the entry AA1, if you dont have the entry please create a entry for AA1,

Database connection name, DBS (db type) and username, password. Last connection information.

make sure you have entered correct password for user AA1_SAPMonitor. After creating the connection, try again in managed system setup and ADBC_TEST_CONNECTION and share us the results.

regards

kartik

[Former Member]

hi

  there is DBCON entry in se16, so how can i create the dbcon entry

regards

vreddy

[Former Member]

Hi,

You can create new entry in Tr. DBCO and add all required fields and save.

Then test the connection in SE38 as mentioned by karthik.

Regards,

Kavitha

[karthikeyan_natarajan4]

Hi Veera,

In DBCON are you able to see your managed system database details ie,AA1.

regards

kartik

[Former Member]

hI

Unabale to see the managed system .

regards

vreddy

[karthikeyan_natarajan4]

Hi Veera,

In that case, SE16 --> DBCON and click on create button at the top and put the details of your managed system.

regards

kartik

[Former Member]

Hello Vreddy,

Can you provide the logs displayed in the configuration ?

Regards,

Archana

[Former Member]

hi

where can i find logs ?, can u clearely tell me the path for the logs location.

this is solution manger system 7.1 and doing solman_setup its on a manged system configuration.  i adding other system to configure product systems. db is mssql2008r2.

regards

vreddy

[Former Member]

Hello Vreddy,

If you scroll down in the same screen , you can see logs on errors and warnings.

Regards,

Archana

[Former Member]

Hi Vreddy,

You can find the logs in the same screen ..scroll down and click on show.

does your solution manager is also on same db mssql or different database like oracle or db2..etc.?

Regards,

Kavitha

[Former Member]

Hi Kavitha

thanks for the replay, DB is mssql2008 , attached the logs

[Former Member]

Hi Vreedy,

Please click on show and paste the logs here.

Regards,

Kavitha

[Former Member]

hi

thanks for the help attached screen shot for the loga

regards

vreddy

[Former Member]

Hi,

Error shows login failed for the user maintained in connection details.

Please check and maintain correct login details and also check that user is able to login to  target databse and has all required authorizations.

Regards,

Kavitha