Skip to Content
0
Former Member
Jan 26, 2010 at 06:29 PM

SMD database monitoring for Java system

29 Views

Hi,

From SMD, while configuring Managed system(JAVA ONLY system)--> database monitoring I am getting following error

*ERROR*	
DB connection Id :%_SID_hostname
Connectivity test :
Database history :This connection could not be tested, thus the DB performance warehouse was not set up
Extractors activation :This connection could not be tested, thus the DB extractors were not set up
Connectivity test details :
Database connection %_SID_Hostname: SQL error 12154 ORA-12154: TNS:could not resolve the connect identifier specified
Database connection %_SID_Hostname could not be established

System Details

Solman - SAP EHP 1 for SAP Solution Manager 7.0

managed system - Netweaver 7.0 AS JAVA(New Installation)

Connection parameters

Database Name: SID

Database Host :hostname(FQN)

TNS Name:SID.WORLD

User Name:SAPSR3DB

Password:xxxxxxxxxxx

tnsping is working for managed system from solman.

I tried connecting with SAPR3DB directly on managed system and I could, no issues with the password.

Let me know if there are any pre-requisite steps for AS JAVA systems.

Regards

KVR