on 08-10-2011 10:00 AM
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
issue resolved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.