How to check Oracle odbc connectivity in solaris ?


 
Thread Tools Search this Thread
Operating Systems Solaris How to check Oracle odbc connectivity in solaris ?
# 1  
Old 05-18-2006
How to check Oracle odbc connectivity in solaris ?

Hi,

I have my application and database servers running on solaris. I need to check Db connectivity for a datasource in my Db server.
Please guide me how to do it in solaris env.

Aru
# 2  
Old 06-02-2006
use the command tnsping to check the db server is up or not

tnsping <database name>

Regards,
Thobias Vakayil
# 3  
Old 06-12-2006
Quote:
Originally Posted by aarora_98
Hi,

I have my application and database servers running on solaris. I need to check Db connectivity for a datasource in my Db server.
Please guide me how to do it in solaris env.

Aru
you need to buy Unix ODBC driver (lil expensive!) to be installed either in db server or application server. This is not free like windows odbc.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Solaris

External Network Connectivity w/Oracle VM Server for SPARC & Solaris 11

Hello all, thanks for reading my question: So I've been a Unix/Linux SysAdmin for a couple years, and I'm a bit over my head running solo, trying to set up LDoms using Oracle VM Server 3.1 for SPARC. I've been very careful, and things have gone well up until the point I try to access the new... (9 Replies)
Discussion started by: Lyxix
9 Replies

2. Red Hat

DB2 ODBC connectivity problem in RHEL5 32 bit

Hi, I installed Db2 9.7 on RHEL5 32bit . Instance Name is db2inst1 amd in that i created database as mydb. I exported env variables for classpath ,db2dir,db2instance LD_LIBRARY_PATH ,PATH ,ODBC, ODBCHOME ,ODBCINI My application needs ODBC connectivity and so I modified odbc.ini file . ... (0 Replies)
Discussion started by: roopalidalvi231
0 Replies

3. IP Networking

Connectivity check.

How to check connectivity with an external server if I know the IP. Please note traceroute is not working for me, as it is saying command not found. (6 Replies)
Discussion started by: nixhead
6 Replies

4. AIX

ODBC Connectivity between Oracle10g on AIX and Mainframe

Hi, I have a task of setting up connectivity between Oracle 10g (AIX) and Mainframe (1 library). Went through couple of documents, forums, blogs etc. MY understanding is ODBC Generic Connectivity is free from Oracle side. Question: (may be dumb to you) 1. Has anybody done this and would... (3 Replies)
Discussion started by: jvmani_1
3 Replies

5. Shell Programming and Scripting

Connecting to Oracle by using ODBC on UNIX

Hi All, I have a requirement where I need to connect to Oracle database which is installed on WINDOWS machine. I dont have Oracle client installed on my AIX so i can't use SQLPLUS command. But ODBC to connect to Oracle is configured on my UNIX server. Can any one help me with the steps of... (1 Reply)
Discussion started by: Raamc
1 Replies

6. Shell Programming and Scripting

Script to check connectivity

I want to write a script to check if a unix box say abc.tdc.cin.net can be connected or not on certain port say 22. right know i have to telnet them manually from DOS prompt and if it is successful then isay it is connected. Also to check Database connectivity I am using tnsping From DOS prompt.... (3 Replies)
Discussion started by: kukretiabhi13
3 Replies

7. Shell Programming and Scripting

DBD::ODBC::st fetchrow_hashref failed: [unixODBC][Oracle][ODBC]Numeric value out of r

Here is part of my program code: #Collect the output of test database and count the no #of rows too while(my @array = $tstDbStatementHandle->fetchrow_array) { push @tstDbOutputArray,; $tstDbOutputRows++; } ... (3 Replies)
Discussion started by: sameerstephen
3 Replies

8. Windows & DOS: Issues & Discussions

Oracle 9i ODBC connection

I am attempting to access an Oracle 9i database located on a Solaris server from an XP client. The server is running Oracle 9i9.2.0.1.0 and the XP is Oracle client 9i 9.2.0.1.0. When I start a listener on the server, the listener starts but I receive a message “The listener supports no services”. I... (3 Replies)
Discussion started by: jkuchar747
3 Replies

9. UNIX for Advanced & Expert Users

Oracle Odbc

Hello all, i like to install an application program that will interact with the oracle database. oracle has been installed in /export/home/oracle does the new application has to be in the same directory and if not which one do you recommend? There is a drive like the ODBC in oracle to... (2 Replies)
Discussion started by: rsh
2 Replies
Login or Register to Ask a Question

Featured Tech Videos