Sitescope 10 - error Oracle Ora-31008 (4429 Views)
Reply
Frequent Advisor
Posts: 74
Registered: ‎01-30-2009
Message 1 of 29 (4,429 Views)

Sitescope 10 - error Oracle Ora-31008

Hi everybody.

I've installed Sitescope 10 and I've configured the Oracle template. When the monitors tried to connect to the database the following message appears: "Error Code: 31008. Error Description: Error getting counters : Error from database driver: Io exception: Socket is not connected".

I've tried to connect to another database in other server and the template works fine. Anybody can help me?

Regars.
Occasional Visitor
Posts: 4
Registered: ‎05-26-2009
Message 2 of 29 (4,429 Views)

Re: Sitescope 10 - error Oracle Ora-31008

I am also facing the same issue. If you have come across any solutionm. do post the same in the forum

Thanks
Vijayababu R
Frequent Advisor
Posts: 74
Registered: ‎01-30-2009
Message 3 of 29 (4,429 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Hi Vijayababu.

Check the database information (port, IP, db instance, user, password, driver, etc), my problem was the Oracle Port, the DBA give me the wrong information.

I hope this help you.

Regards.
Occasional Visitor
Posts: 1
Registered: ‎11-30-2009
Message 4 of 29 (4,427 Views)

Re: Sitescope 10 - error Oracle Ora-31008

The same error is occured when i tried to add SAP R3 templates,it means there is an API with Getcounters () method which is throwing an exception, need to log a helpdesk call and let them know that there are exceptions, i did it yet to get response.
Advisor
Posts: 16
Registered: ‎04-23-2008
Message 5 of 29 (4,427 Views)

Re: Sitescope 10 - error Oracle Ora-31008

We are looking purchasing /use of the SiteScopes Oracle solution templates?

Any comments good or bad ?

My understanding is that it looks at the overall health of the database by grouping a number of oracle monitors with preconfigured thresholds.

We have used sitescope monitors since 2004, recently upgraded to 9.53 on windows.

We have used existing oracle data base monitors to check current logons per instance and perform a number of application database query monitors that look for specific info.

Thanks Vince

Also does anyone have a copy of SiteScope_Oracle_Database_Best_Practices.pdf
Frequent Advisor
Posts: 70
Registered: ‎04-25-2011
Message 6 of 29 (4,412 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Im having the same Issue, how did you resolve?

 

my data:

 

DATA BASE CONNECTION url:
jdbc:mercury:oracle://192.168.49.102:15545;PRESIEB

 

Database Driver

driver:com.mercury.jdbc.oracle.OracleDriver

 

When I Click in Verify and Safe this error shows: The following properties had verification errors:
No counters selected.

 

and if i select Get counters button: Error Code: 31008.  Error Description: Error getting counters : unable to retrieve the counters

 

thank you in advance.

 

Advisor
Posts: 28
Registered: ‎09-05-2011
Message 7 of 29 (4,391 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Hello All,

 

Below may help you

CONNECTION URL: jdbc:oracle:thin:@server name:port number:instance

DATABASE DRIVER NAME: oracle.jdbc.driver.OracleDriver

 


Also if it still doesnt work then you have to check with the account with the DB Team that you are using from sitescope to connect with that database, whether that user has access to fetch data from tables.

PLEASE NOTE: USE THE "TOOLS" OPTION TO SEE IF THAT USER IS ABLE TO CONNECT

Regards'Arjun
Frequent Advisor
Posts: 34
Registered: ‎02-22-2011
Message 8 of 29 (4,369 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Hello Angel,

 

Use Database Connection Tools to verify if you are able to connect to the database.

 

Check the parameters.

 

Database connection URL

jdbc:oracle:thin:@<server name or IP address>:<database server port>;sid=<sid>.

in your case
jdbc:oracle:thin:@192.168.49.102:15545;PRESIEB

 

Database driver

oracle.jdbc.driver.OracleDriver

 

Credentials

Credentials assigned to connect to DB Server

 

Query

select * from dual

 

Click on Run Tool.

 

If you get a succesfully result from the query, you will be able to get counters from the oracle database.

 

Note: You need to check some Prerequisites before to monitor ORACLE DB, you should check for the pdf file HP SIteScope-Monitor Reference.

 

I hope it helps you with this issue.

 

Regards

Diego

 

Advisor
Posts: 26
Registered: ‎03-04-2008
Message 9 of 29 (4,234 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Did this get resolved?

I'm running into the same issue.

I had to make sure the SID was in the tnsnames.ora file for Oracle, but that was not the problem.

I've tried all of the example types you show here.

 

Now my DB is on a Unix server, does that play into this at all?

I did not think it mattered using the Oracle DB monitor...

Frequent Advisor
Posts: 34
Registered: ‎02-22-2011
Message 10 of 29 (4,226 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Try using a telnet command to verify connectivity

 

telnet <server name or IP address> <database server port>

 

If so, try again with the database tool, if the problem persists, check for the error.log file and upload it.

 

Regards

 

Diego

Advisor
Posts: 26
Registered: ‎03-04-2008
Message 11 of 29 (4,224 Views)

Re: Sitescope 10 - error Oracle Ora-31008


Diego Caicedo Lescano wrote: Try using a telnet command to verify connectivity

 telnet <server name or IP address> <database server port>

 If so, try again with the database tool, if the problem persists, check for the error.log file and upload it.

 Regards Diego


Ok., so the unix server the DB is on is setup to only support ssh, no telnet allowed, so that is how it is the remote server definition is defined. I can use putty to connect without any problem, and when I test the connection in SiteScope that works OK.

I tried the telnet anyway, using the IP and prot #, but it was rejeccted, 'Could not connection to the host, on port .... "

Is there a way to try that using putty?

 

Valued Contributor
Posts: 350
Registered: ‎10-09-2012
Message 12 of 29 (2,205 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Hi, did this ever get resolved?

I am having a similar issue.

I tried using the Database Tool to test the connection and it seems to be connecting.

Please see the attachment DBResult.jpg.

 

However, when I try to "Get Counters, I get the message 

 

Error 31008
Error getting counters : unable to retrieve the counters

 


Can someone please tell me what I may be doing wrong?

 

Any advice on this is very much appreciated.

Thanks,

 

HP Expert
Posts: 309
Registered: ‎05-22-2012
Message 13 of 29 (2,197 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Hi,

 

Would you please tell me which monitor are you using?

 

If tool is working fine then the DB query  and Oracle database monitors have to work as expected.

 

If you are using the Oracle 10g Application Server Monitor, then please verify you are using the correct port, try with port 1158 instead 7201. 

 

Best Regards,

Gunnar López
HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Valued Contributor
Posts: 350
Registered: ‎10-09-2012
Message 14 of 29 (2,193 Views)

Re: Sitescope 10 - error Oracle Ora-31008

We are using the Oracle monitor with port:1521
Valued Contributor
Posts: 350
Registered: ‎10-09-2012
Message 15 of 29 (2,191 Views)

Re: Sitescope 10 - error Oracle Ora-31008

I tried running some queries using the Database Connection Tool and it ran successfully. However, when I try to "Get Counters", SiteScope says unable to retrieve counters.
Can someone please tell me what am I doing wrong?
HP Expert
Posts: 2,210
Registered: ‎04-28-2011
Message 16 of 29 (2,183 Views)

Re: Sitescope 10 - error Oracle Ora-31008

SiS runs specific queries for Oracle counters. Refer to http://support.openview.hp.com/selfsolve/document/KM189298 and test the queries.
Kenneth Gonzalez
HP Support

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.

If you haven’t tried it yet, come and join us in our entitled forums at Support Customer Forums
Valued Contributor
Posts: 350
Registered: ‎10-09-2012
Message 17 of 29 (2,181 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Thanks Kenneth.
The queries work but when I try "Get Counters", SiteScope is unable to retrieve counters.
HP Expert
Posts: 865
Registered: ‎03-06-2008
Message 18 of 29 (2,163 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Are the performance statistics ENABLED for the Oracle Database ??

Supported DB versions are 8i, 9i, 10g, 11i, and 11g R2 (11.2.0.1)
HP Expert
Posts: 309
Registered: ‎05-22-2012
Message 19 of 29 (2,159 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Woud you please go to: SiteScope\conf\core\Tools\log4j\PlainJava

 

Create a copy of  log4j.properties file

 

Append this to the original file and save it:

 

##################################################################################
# DB monitors
##################################################################################

log4j.category.com.mercury.sitescope.monitors.db=DEBUG, db.appender
log4j.additivity.com.mercury.sitescope.monitors.db=false
log4j.category.com.mercury.sitescope.infra.sql.pool=DEBUG, db.appender
log4j.additivity.com.mercury.sitescope.infra.sql.pool=false

log4j.appender.db.appender=org.apache.log4j.RollingFileAppender
log4j.appender.db.appender.File=../${log.file.path}/db_monitors.log
log4j.appender.db.appender.MaxFileSize=${def.file.max.size}
log4j.appender.db.appender.MaxBackupIndex=${def.files.backup.count}
log4j.appender.db.appender.layout=org.apache.log4j.PatternLayout
log4j.appender.db.appender.layout.ConversionPattern=%d [%t] (%F:%L) %-5p - %m%n
log4j.appender.db.appender.encoding=${general.encoding}

 

Try to create the monitor again, go to SiteScope\logs and attach in this post db_monitors.log file.

 

After that, rollback changes made on original log4j.properties file.

 

Best Regards,

Gunnar López
HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Valued Contributor
Posts: 350
Registered: ‎10-09-2012
Message 20 of 29 (2,152 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Thanks for the response.

Please see the attached db_monitors.log file

 

HP Expert
Posts: 309
Registered: ‎05-22-2012
Message 21 of 29 (2,140 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Hi,

 

Cheking the logs seems you are not using correct driver information, you have to use oracle.jdbc.driver.OracleDriver and not oracle.jdbc.driver.T4CConnection, also there are some ORA errors like this one: ORA-00942: table or view does not exist that could be related to permissions.

 

Would you please verify you are using the correct driver information and a user with permissions over all tables needed?

 

Best Regards,

Gunnar López
HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Valued Contributor
Posts: 350
Registered: ‎10-09-2012
Message 22 of 29 (2,136 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Thanks for the reply.

I am using the correct driver info "oracle.jdbc.driver.OracleDriver"

 

Attached is the most updated db_monitors.log file.

 

I think we have given all the prvileges that it needs.

From my previous post, we found out that the SiteScope user did not have access to those tables.

Now after giving access, we executed that query just fine and now SiteScope is unable to execute another query.

 

Please see the attached db_monitors.log file which has been updated.

Can someone please tell me how to resolve this so that SiteScope can execute the query?

Thanks,

HP Expert
Posts: 309
Registered: ‎05-22-2012
Message 23 of 29 (2,134 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Hi,

 

Since the error code is ORA-00942 the error is send from the DB itself, according to the logs the user you are using has not permissions to execute the following queries:

 

SELECT sid,username,terminal,program FROM V$SESSION WHERE (osuser <> 'SYSTEM') AND (username IS NOT NULL) AND (type <> 'BACKGROUND') and (paddr in (select addr from v$process))

 

 

 

select total.tablespace_name tsname, round((1-nvl(sum(free.bytes),0)/total.bytes)*100)  pctusd from (select tablespace_name,    sum(bytes) bytes from    dba_data_files  group by tablespace_name)  total,  dba_free_space  free where  total.tablespace_name = free.tablespace_name(+) and total.tablespace_name = 'USERS'group by total.tablespace_name,  total.bytes order by   (1-nvl(sum(free.bytes),0)/total.bytes)*100  asc

 

Best Regards,

Gunnar López
HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Valued Contributor
Posts: 350
Registered: ‎10-09-2012
Message 24 of 29 (2,104 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Thanks for the response.

Currently SiteScope can execute the query

 

SELECT sid,username,terminal,program FROM V$SESSION WHERE (osuser <> 'SYSTEM') AND (username IS NOT NULL) AND (type <> 'BACKGROUND') and (paddr in (select addr from v$process))

 

however, SiteScope is unable to execute the query 

 

select total.tablespace_name tsname, round((1-nvl(sum(free.bytes),0)/total.bytes)*100)  pctusd from (select tablespace_name,    sum(bytes) bytes from    dba_data_files  group by tablespace_name)  total,  dba_free_space  free where  total.tablespace_name = free.tablespace_name(+) and total.tablespace_name = 'USERS'group by total.tablespace_name,  total.bytes order by   (1-nvl(sum(free.bytes),0)/total.bytes)*100  asc

 

 

Can someone please help me as the first query is obvious that it needed access to "V$SESSION", but the 2nd query, I am not sure what permissions are needed in order to execute the 2nd query?

 

Any help on this is very much appreciated.

Thanks,

HP Expert
Posts: 309
Registered: ‎05-22-2012
Message 25 of 29 (2,097 Views)

Re: Sitescope 10 - error Oracle Ora-31008

Hi,

 

For second query you need permissions over:

 

dba_data_files 

 

and

 

dba_free_space 

 

Best Regards,

Gunnar López
HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.