CA UDPM error on HP-UX

[di55]

configure a knowledge agent on a HP-UX server

DESCRIPTION OF PROBLEM/QUERY
customer installed the Insight software on a HP-UX and tries to set up
monitoring for the local Oracle 9i server. The configuration of the agent
always fails with the error message :
------------------------------
Initializing self-describing agent
------------------------------
Failed to initialize self-describing agent....

ENVIRONMENT DETAILS
OPERATING SYSTEM & SERVICE PACK, PATCHES
HP-UX 11.11 64-bit, Oracle9i
CA SOFTWARE VERSION & BUILD, PATCHES APPLIED
Insight DPO 11.3., UDCC installed with MDB on Oracle (another remote
instance on another server)

PROBLEM FREQUENCY always

the
mitjasag and agent configuration logs showed error when connection to the
Oracle instance:


================= JAS_AGENT 11.3.0.0 =================
Thu Jan 21 09:53:20 2010: JAS Agent started: Thu Jan 21 09:53:20 2010
Thu Jan 21 09:53:20 2010: PtLESSendAlarmEvent- Error: (2) ENOENT

Connecting to project on RTserver.
Using tcp protocol.
Message from RTserver: Connection established.
Start subscribing to subject .
Thu Jan 21 09:53:20 2010: Ready to receive PEC message on datagroup
(ptles_10.1.32.2)
Thu Jan 21 09:53:20 2010: Connecting to repository...
Thu Jan 21 09:53:20 2010: {error} STATE=HY000, CODE=2013209684,
MSG=[DataDirect][ODBC Oracle Wire Protocol driver]Cannot open TNS Names
file.


and

ODBC environment handle allocated successfully...
Required license attributes for ODBC Connection Handle set successfully...
ERROR (iddCfg-2051):
Unable to connect to the database.
CAUSE:
Odbc error [DataDirect][ODBC Oracle Wire Protocol driver]TNS-12154:
TNS:could not resolve the connect identifier specified.
ACTION:
Please check if the target database is up and running.
In addition, please ensure the validity of the single sign-on
account for the database which you provided in the portal's
Server Management tool prior to the configuration.

[di55]

Hello Forum
PLease if someone can help me in this issue
Regards

[Matti_Kurkela]

I have no experience with Insight, but this message suggests the agent wants to read the tnsnames.ora file but cannot:

> MSG=[DataDirect][ODBC Oracle Wire Protocol driver]Cannot open TNS Names
file.

Either the file permissions are preventing the agent from reading the file, or the agent is run without the proper ORACLE_HOME environment variable, so the agent cannot locate the file.

The tnsnames.ora file should normally be found at:
$ORACLE_HOME/network/admin/tnsnames.ora

The second error:
>ERROR (iddCfg-2051):
Unable to connect to the database.
>CAUSE: [...] TNS:could not resolve the connect identifier specified.

If the tnsnames.ora file cannot be located, resolving the database connection identifiers is obviously impossible. So the second error is a consequence of the first one. Fix the first error, and the second might go away too.

MK

[di55]

Hello
thank you for the reply
i will check about that ,and will keep you posted
Regards

[di55]

Hello
please find the solution below:

the set output you have send me seems to be for the user root, can you
please confirm this with the customer?

Can he also please do the following:
1. "ls -al $ORACLE_HOME/lib32"
2. "ls -al $ORACLE_HOME/lib"

This should be run under the user oraut. we would need rx permissions to
those files ( chmod go+rx ) .


Also, please connect to the instance UAT with the SSO user (udp) and
execute the following commands:
1. check whether the view 'SYS.UDPM$KTFBUE' exists

2. check whether SSO user has select privileges on the view
SYS.UDPM$KTFBUE by running "select * from SYS.UDPM$KTFBUE"

3. check whether SSO user has select privileges on the view
SYS.TS$ by running a command "select * from SYS.TS$"

4. Run the following queries and return the result

SELECT (COUNT(V.VIEW_NAME) + COUNT(P.GRANTEE)) FROM SYS.DBA_VIEWS V,
SYS.DBA_TAB_PRIVS P WHERE V.VIEW_NAME='UDPM$KTFBUE' AND V.OWNER='SYS'
AND P.TABLE_NAME='TS$' AND P.GRANTEE='udcc' AND P.PRIVILEGE='SELECT' AND
P.OWNER = V.OWNER;



SELECT (COUNT(V.VIEW_NAME) + COUNT(P.GRANTEE)) FROM SYS.DBA_VIEWS V,
SYS.DBA_TAB_PRIVS P WHERE V.VIEW_NAME='UDPM$KTFBUE' AND V.OWNER='SYS'
AND P.TABLE_NAME='TS$' AND P.GRANTEE='UDCC' AND P.PRIVILEGE='SELECT' AND
P.OWNER = V.OWNER;


In addition please do the following:
Connect to the agent box as 'udcc' user



1. Change SHLIB_PATH to have '/uat/oracle/uatdb/9.2.0/lib32'
first followed by '/uat/oracle/uatdb/9.2.0/lib'

After setting it please check the SHLIB_PATH again and remove any
duplicate entries if you have but make sure you have $ORACLE_HOME/lib32
before $ORACLE_HOME/lib. change your .profile also accordingly.

2. cd to $UDCC_HOME/bin and run . ./udminit.sh

3. Stop JAS - run ./mitjasstp

4. start JAS - run ./mitjasag

I will call you shortly regarding the remote session, but if you could do
this first that would be great.

Kind Regards,

[di55]

the set output you have send me seems to be for the user root, can you
please confirm this with the customer?

Can he also please do the following:
1. "ls -al $ORACLE_HOME/lib32"
2. "ls -al $ORACLE_HOME/lib"

This should be run under the user oraut. we would need rx permissions to
those files ( chmod go+rx ) .


Also, please connect to the instance UAT with the SSO user (udp) and
execute the following commands:
1. check whether the view 'SYS.UDPM$KTFBUE' exists

2. check whether SSO user has select privileges on the view
SYS.UDPM$KTFBUE by running "select * from SYS.UDPM$KTFBUE"

3. check whether SSO user has select privileges on the view
SYS.TS$ by running a command "select * from SYS.TS$"

4. Run the following queries and return the result

SELECT (COUNT(V.VIEW_NAME) + COUNT(P.GRANTEE)) FROM SYS.DBA_VIEWS V,
SYS.DBA_TAB_PRIVS P WHERE V.VIEW_NAME='UDPM$KTFBUE' AND V.OWNER='SYS'
AND P.TABLE_NAME='TS$' AND P.GRANTEE='udcc' AND P.PRIVILEGE='SELECT' AND
P.OWNER = V.OWNER;



SELECT (COUNT(V.VIEW_NAME) + COUNT(P.GRANTEE)) FROM SYS.DBA_VIEWS V,
SYS.DBA_TAB_PRIVS P WHERE V.VIEW_NAME='UDPM$KTFBUE' AND V.OWNER='SYS'
AND P.TABLE_NAME='TS$' AND P.GRANTEE='UDCC' AND P.PRIVILEGE='SELECT' AND
P.OWNER = V.OWNER;


In addition please do the following:
Connect to the agent box as 'udcc' user



1. Change SHLIB_PATH to have '/uat/oracle/uatdb/9.2.0/lib32'
first followed by '/uat/oracle/uatdb/9.2.0/lib'

After setting it please check the SHLIB_PATH again and remove any
duplicate entries if you have but make sure you have $ORACLE_HOME/lib32
before $ORACLE_HOME/lib. change your .profile also accordingly.

2. cd to $UDCC_HOME/bin and run . ./udminit.sh

3. Stop JAS - run ./mitjasstp

4. start JAS - run ./mitjasag

I will call you shortly regarding the remote session, but if you could do
this first that would be great.

Kind Regards,