DBAcockpit connection <SID> cannot be established

[former_member808490]

Hi,

We are facing below issue while performing "Enter System Parameters" step of the managed system configuration for the satellite system.

The DBACockpit connection cannot be establised

An error occurred during connection setup.

Exception CX_DB6_SYS in class CL_DB6_SYS method line 0 / RC=System not found

Error creating connection object '%_<SID>_<hostname>_'

We have already implemented the correction instructions as per the sap note 1850913 and 1741919 in solution manager. Also, the tnsnames.ora details of the satellite system is copied to solution manager tnsnames.ora.

We are using solution manager 7.1 SP08 and DB is oracle.

Any suggestion please.

Regards,

Neha

[Former Member]

HI Neha,

The error you have pasted came once  database information maintained correctly as per tnsnames.ora.

Check the user you are using in dbacockpit configuration.

Try to connect the oracle with the user/password if it is correct.

or

I believe you have used sapsr3db or sapsr3, change the user to system & test the connection.

Regards,

Ankit

[Former Member]

Neha,

Is your issue resolved?

Thanks and regards,

Rayapa Reddy

[Former Member]

Hi Neha,

Is the satellite system in cluster ? Have you entered correct parameters specially hostname of Database ?

Please check below and then try to execute step again :

• Correct database details like hostname and version are updated in SLD and LMDB
• Is Solution Manager Central SLD which is receiving data from satellite system via data supplier or there is seperate Central SLD ? 
• Check SLD Model and CR content is up-to-date for both SLD's as per SAP Note 669669 - Updating the SAP Component Repository in the SLD

Hope this helps.

Thanks & Regards,

Nisha

[former_member808490]

Hi Nisha,

The DB details are maintained correctly the SOLMAN SLD. Also, SLD model and CR content is up-to-date for solution manager.

Regards,

Neha

[Former Member]

Hi Neha,

Please try copying tnsnames.ora details of the satellite system to Solution manager system at both the locations mentioned below:

1. /usr/sap/<SID>/sys/profile

2. /oracle/<SID>/112_64/network/admin.

Sunny

[Former Member]

Hello Neha,

Try this note 1783711 - DBA: Database setup has an error

BR,

K.

[former_member808490]

Hi Kamil,

I have already implemented the correction instruction of the sap note  1783711.

Regards,

Neha

[Former Member]

Hi Neha,

Tried the below note ?

1456402 - DB6: DBA Cockpit Corrections for SAP Basis 7.02/7.30/7.31

Rg,

Karthik

[former_member808490]

Hi Karthik,

Thank you. Note 1456402 is applicable for DB6 and we are using oracle.

Regards,

Neha

[Former Member]

Hi Neha

For connecting to the remote Oracle DB , please check if your TNSNAMES.ORA file is containing the information for the remote DB ..

In your central system , login to Operating System and give :

TNSPING  <SID>    ( SID of the remote system ) -

is the above working fine ?

Thanks

Rishi

[former_member808490]

Hi Rishi/Sunny,

The tnsnames.ora details of satellite system is already copied to solution manager on both the locations. Also tnsping is successful.

Regards,

Neha

[former_member45419]

Hi Neha,

pls refer below notes & link,

SCN : All Content - SAP Solution Manager

1314750 DB6: DBA Cockpit Correction Collection SAP Basis 7.00 / 7.10

1241693 - DB6: Exception CX_DBA_ADBC in compression check

1009350 DB6: db2fmp problems

Regards

Nayeem

[former_member808490]

Hi Nayeem,

DB used is ORACLE.

Regards,

Neha

[Former Member]

HI Neha,

Check the below note

1850913 - Solman 7.10 SP08 connection to database returns "An error occurred during

connection setup - Exception CX_DB6_SYS in class CL_DB6_SYS method line 0 / RC=System not found"

Rg,

Karthik

[former_member808490]

Hi Karthik,

I have already implemented the correction instruction provided in the sap note.

Regards,

Neha