Aside from the (probably) typo:
drivers=oracle.jdbc.driver.OracleDriver
you need to make sure the oracle listener is running
on the machine (192.168.10.20) at port 1527 (in your
case). The ORACLE_SID/Sid should be 'mtgr'
On the 192.168.10.20 machine, if NT go to Oracle->Net
8 Configuration Assistant, and check for a configured
TCP/IP listener on that port, with that sid name.
If UNIX, go to $ORACLE_HOME/network/admin and view
the listener.ora - you should see something like:
# LISTENER.ORA Network Configuration File:
D:\software\orant\Ora816\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER_MYDB =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST
=192.168.10.20)(PORT = 1527))
)
)
)
SID_LIST_LISTENER_MYDB =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = mtgr)
(ORACLE_HOME = D:\software\orant\Ora816)
(SID_NAME = mtgr)
)
)
This file also resides on NT, under the same
directory structure, but Oracle prefers you use
the wizard to configure/edit.
Hope that helps.
-Joel Thompson
RHINO Systems Inc.
www.rhinosystemsinc.com
Srinivasa Murthy wrote:
> Guys,I am doing the following to test run t3dbping (with ORACLE THIN DRIVER, for
>jdbc) successfully in weblogic5.1. But, it ain't working. I did the following :I have
>set the absolute classpath and
> WEBLOGIC_CLASSPATH to the classes12.zip in the startweblogic.cmd file. This is how I
>have appended in that particular file.set
>
>WEBLOGIC_CLASSPATH=.\license;.\classes;.\lib\weblogicaux.jar;.\myserver\serverclasses;d:\classes12.zip
>
> When I run t3dbping [Srinivasa Murthy] using the following command, I get the
>error as under : java utils.t3dbping t3://localhost:7001 otiger otiger ""
>orcle.jdbc.driver.OracleDriver
> jdbc:oracle:thin:@192.168.10.20:1527:mtgr
> ERROR:
> Connecting to WebLogic with the WebLogic JDBC Driver
> Can't connect with the WebLogic JDBC driver:
> Io exception: The Network Adapter could not establish the connection
> Server StackTrace:
> [
> <not available>]Whereas, a simple java application file with jdbc connectivity
>is working perfectly fine for me. I dunno whats wrong, I might be wrong in setting
>the weblogic classpath
> somewhere. Can someone plssss help me here. I even appended it to the
>POST_CLASSPATH of startweblogic.cmd file. Still it is reluctant.Though it takes the
>weblogic classpath when I run
> "startweblogic" it does not work. Kindly help me here. Thnx in advance. Pls do
>give me a solution. Its urgent.Srinivas.
>
>
>
--
--------------------------------------
RHINO Systems Inc.
RDBMS and Internet development
Java/EJB/Oracle systems
http://www.rhinosystemsinc.com
Phone: 530-888-6248 x205
--------------------------------------
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
