New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


How to connect to an Oracle DB using SID?

Votes:

0

Your Vote:

Up

Down

Hi support team, if i#m using the default SIDfrom our tnsnames i receive the error: Could not connect to database: Database Server Error: NET: Invalid SID So i think the user credentials are correct but something's wrong with the SID-string in the properties of the sensor. I only use the SID 'TEST' as value for the database field. Is there something more to do? Thanks, Andreas

database oracle sid

Created on Mar 22, 2011 3:39:15 PM by  AGriese (0) 1



5 Replies

Accepted Answer

Votes:

0

Your Vote:

Up

Down

Hello,

which version of PRTG are you running? In v7 the Oracle Sensors worked differently then now in v8.

The Error message "Could not connect to database: Database Server Error: NET: Invalid SID " appears if the name of the database is wrong.

Just another tip, if you are confident that the database name is correct (exactly the same from the Oracle server) it might help to restart the Oracle Listener and Oracle Database Service.

Best Regards.

Created on Mar 23, 2011 1:30:17 PM by  Torsten Lindner [Paessler Support]

Last change on Apr 14, 2011 11:44:12 AM by  Torsten Lindner [Paessler Support]



Votes:

0

Your Vote:

Up

Down

Hi, it is the version 8 prtg. And, yeah, it seems to be, that the database name ist wrong. But using oracle tools (sql+) to connect to the DB everything ist fine. And even the values in the tnsnames are the same. i've installed the oracle tools on the prtg server, maybe there ist something neccessary to build up the connection. But's not working. Can i check the connection with a commandline or another tool? Monitoring oracle tablespaces is neccessary for my environment. thx for your help.

Andreas

Created on Mar 23, 2011 2:37:11 PM by  AGriese (0) 1



Votes:

0

Your Vote:

Up

Down

Hi, i'm using v8.3.1.2088 and i can connect with the values (sid, user credentials) to the database (sql+) - even from the server on which PRTG is installed. So are there some more prerequisites i have to fullfill? Or do i have to change the syntax of the database field (e.g. SID@databaseserver os something like that).

Best regards.

Created on Mar 24, 2011 11:43:22 AM by  AGriese (0) 1



Votes:

0

Your Vote:

Up

Down

Enter Service Name as defined in "tnsnames.ora" on the server.

Created on Apr 5, 2011 11:58:28 AM by  Torsten Lindner [Paessler Support]



Votes:

0

Your Vote:

Up

Down

Okay. After e few tries the default SID works. I've checked the Oracle DB tnsnames file and find out that there's a different one. However - it works. But now, using following statement "select sum(bytes)/1024/1024 from dba_free_space where tablespace_name = 'KHV'" (without ""), i receive no value. The sensor is okay ('green') but shows nothing. Wrong statement???

Created on Apr 29, 2011 2:25:25 PM by  AGriese (0) 1



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.