cancel
Showing results for 
Search instead for 
Did you mean: 

SMD database monitoring for Java MSCS cluster system

former_member298251
Participant
0 Kudos

Dear All,

We have install SAP netweaver 7.0 EHP1 java stack on oracle 10.2.0.5 with windows 2008 R2 MSCS cluster enviornmant.

now we are configuring SMD

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

DB connection Id :%_SID_virtualhost_SAPSR3DB

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_virtualhost_SAPSR3DB : SQL error 12505 ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

Database connection :%_SID_virtualhost_SAPSR3DB could not be established

System Details

Solman - SAP EHP 1 for SAP Solution Manager 7.0

managed system - Netweaver 7.0 ehp1AS JAVA(New Installation)

Connection parameters

Database Name: SID

Database Host :virtual host

TNS Name:SID.WORLD

User Name:SAPSR3DB

Password:xxxxxxxxxxx

Tns ping command is also not working when we give host name as virtual host of JAVA system

but when we change it to phyiscal IP address of the cluster server it is working fine.

Could you please let me know any setting need to be done

Sincerely

Paresh

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member298251
Participant
0 Kudos

issue resolved

Former Member
0 Kudos

Paresh,

How did you resolve this one>

Former Member
0 Kudos

Hi Paresh,

>> Tns ping command is also not working when we give host name as virtual host of JAVA system

but when we change it to phyiscal IP address of the cluster server it is working fine.

>> SQL error 12505 ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

Virtual hostname must be resolved on both hosts while configuring SMD. Otherwise you'll not able to access Oracle Listener.

Best regards,

Orkun Gedik

former_member298251
Participant
0 Kudos

Dear Orkun,

Thanks for your replay,

I have follow the sap installation guide and intstall java system in MSCS enviornment.

but in guide no where it mention using physical ip for oracle group.

how we can resolve the Virtual hostname on both hosts.

can you please help me in this.

Sincerely

Paresh

Former Member
0 Kudos

Hi Paresh,

Let's clarify the issue. You have a J2EE server and want to monitor it over SOLMAN. Because of this you installed a SMD on J2EE server and you are performing the SMD configuration steps on SOLMAN. Isn't is correct?

Best regards,

Orkun Gedik

former_member298251
Participant
0 Kudos

Hello Orkun,

what you have mention is correct and also the j2ee server is running on MSCS.

Sincerely

Paresh

Former Member
0 Kudos

Ok, I see.

Are you able to ping J2EE server on SOLMAN system, by using oracle group hostname?

former_member298251
Participant
0 Kudos

Hello Orkun,

We are unable to ping oracle group from solman system.

Sincerely

Paresh

Former Member
0 Kudos

Hello Orkun,

>

>

> We are unable to ping oracle group from solman system.

>

> Sincerely

> Paresh

Hi Paresh,

Did you tried to add oracle group host into "hosts" file on SOLMAN or DNS?

Best regards,

Orkun Gedik

former_member298251
Participant
0 Kudos

Hello Orkan,

thanks for your reply,now we are able to ping the oracle group from solman system.

but now weare getting bellow warning,

Database History: Not Supported for this DB platform

Extractor Activation:The DB Performance warehouse is not available,thus the DB extractor were not activated.

Please let me know how to proceed

Sincerely

Paresh