SMD database monitoring for Java system

[Former Member]

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

[Former Member]

Solved. Earlier I made tnsnames.ora entry in ORACLE_HOME/network/admin, I found that we need to make an entry in tns_admin/tnsnames.ora as well. In my case it was /usr/sap/SID/SYS/profile/oracle/tnsnames.ora

[Former Member]

No solution yet, starting new thread

[former_member227283]

Hi,

Did you add the entry in tnsname.ora of java system in solution manager ??.

Thanks

Anil

[Former Member]

Hi,

Entry of managed system is present in solman tnsnames.ora and I could tnsping managed system from solman.

Regards

KVR

[Former Member]

Any solutions?

[Former Member]

HI,

1. Set ORACLE_HOME environment variable

2. Add ORACLE_HOME\lib to System PATH

3 Set CLASSPATH environment variable to use Oracle JDBC driver from ORACLE_HOME\jdbc\lib

Is the jdbc driver from ORACLE_HOME/jdbc/lib ?

- If you are using a classes12.jar taken from an other location other than this, then your answer will be no. Hence you will have to use the jdbc driver from ORACLE_HOME/jdbc/lib.

Please follow the checkist, something to do with the path.

Regards,

CHETAN.

[Former Member]

I am configuring Solution manager diagnostics Database monitoring.

For which user I should set the env?

[Former Member]

Hi,

I think this is the Oracle Database

Check the tnslistener.ora file for the TNS Entry for the SMD Database

Try connecting to the database from Oracle Client

That would give you some idea