SunQuest
           Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > Oracle Development
Reload this Page

TNSPING ERROR:with oracle database

Discuss TNSPING ERROR:with oracle database in the Oracle Development forum on Dev Shed.
TNSPING ERROR:with oracle database Oracle Development forum discussing administration, Oracle queries, and other Oracle-related topics. Oracle is known as one of the most robust multi-platform relational databases available.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today!
  #1  
Old July 14th, 2004, 02:41 PM
scooterp83 scooterp83 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Aug 2003
Posts: 202 scooterp83 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 11 h 39 m 40 sec
Reputation Power: 5
TNSPING ERROR:with oracle database
Hello i am trying to run a webapp in iplanet. I have all the source code in the right place but now when i go to run it. I cannot connect to the database. I get this error:
Quote:
java.sql.SQLException: Io exception: The Network Adapter could not establish the
connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleConnection.<init>
.
.
.
.(OracleConnection.java:212)

I have four databases called rod0,rwd0,ros0, and roi0. I need to connect to these databases and i dont know how to. I think something is screwed up in my oracle configuration. When i try to do a TNSPING rod0 i get this error:

Quote:
G:\>tnsping rod0

TNS Ping Utility for 32-bit Windows: Version 2.3.3.0.0 - Production on 14-JUL-04
15:40:56

Copyright (c) Oracle Corporation 1995. All rights reserved.

TNS-03505: Failed to resolve name

DOes anyone know of anything that i could do to solve this issue. Please help. Thanks
Reply With Quote
  #2  
Old July 14th, 2004, 03:09 PM
shafique shafique is offline
Senior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Sep 2003
Location: Canada
Posts: 305 shafique User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 45 m 20 sec
Reputation Power: 5
First try to connect your server using ping command,

ping <IP Address of your server>

If it does work then use tnsping to chect the connectivity of your network, You suppose to use the Global name of your database as a parameter (case restriction may be applied if you are running this command in UNIX).

tnsping rad0.com
Reply With Quote
  #3  
Old July 14th, 2004, 03:39 PM
jim mcnamara jim mcnamara is offline
......@.........
Dev Shed Beginner (1000 - 1499 posts)
  
Join Date: Jun 2004
Posts: 1,307 jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level)jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level)jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level)jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level)jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level)jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 1 Week 3 Days 4 h 28 m 57 sec
Reputation Power: 48
If tnsping fails and the database is up, check your tnsnames.ora file, unless it's a unix box then check sqlnet.ora
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > Oracle Development > TNSPING ERROR:with oracle database

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway.