Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Need advise on SAM to monitor Oracle DB

Can anyone guide me on the configurations to monitor Oracle DB ?

What credentials do I need? The OS or Oracle itself?

After that what else?

I followed the http://www.solarwinds.com/documentation/apm/docs/Configuring_and_Integrating_Oracle.pdf guide but still I am receiving ORA-12537: TNS:connection closed error.

Please advise.

Thanks.

Find more posts tagged with

Accepted answers

All comments

micheal100

The Template reference for Oracle Database covers the credentials required.

Credentials: An Oracle user name and password with read access to the Oracle views: dba_free_space, v$sysstat, v$rowcache, v$librarycache, v$sgastat, and v$session.

aLTeReGo

is correct. You will need Oracle credentials to connect to the Oracle database server. You will also need to ensure that you've installed the Oracle client on the Orion server. You can download the Oracle Data Provider for .NET (ODP.Net) from Oracle's website, or use the Basic Lite Oracle Client that's available for download through your customer portal.

jerrywong

Hi Michael,

I installed the Basic Lite Oracle client on the Orion server. I am required to key in the service name into the components right?

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = mz051.asdf.com)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = PLSExtProc)

)

For instance the above tnsnames.ora file for the specific server.

I will have to choose

Port Number - 1521

Destination Point Type - SERVICE_NAME

Destination Point Name - PLSExtProc

But still I prompt with Oracle returned an error. ORA-12537: TNS:connection closed error.

Please advise

Thanks.

aLTeReGo

Have you tried changing the "Oracle Driver Type"? Also, have you verified that the credentials you're using have adequate permissions in Oracle? I would also suggest reviewing the following document.

Configuring and Integrating Oracle. (PDF)

Detroiter

I hate to rez an old topic, but are these grants still all that are needed for Oracle 12c?

I had our DBA Team provide them but I cannot get the Tablespace queries to work, says the table or view does not exist. According to them, this account needs "Grant select on sys.v_$tablespace" in addition to those listed.

Is that the case? If so, can the document be updated to reflect that? I need documentation in case an auditor wants to know why this account has these rights.