Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes BEA/Weblogic and the fly likes WebLogic6.1/Oracle8.1.6 config problem (obvious to someone?) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "WebLogic6.1/Oracle8.1.6 config problem (obvious to someone?)" Watch "WebLogic6.1/Oracle8.1.6 config problem (obvious to someone?)" New topic

WebLogic6.1/Oracle8.1.6 config problem (obvious to someone?)

Larry LeFever

Joined: Jun 13, 2000
Posts: 18
dbping logs in with "scott/tiger". so does SQL*Plus, but WebLogic (eval. edition) cannot, in case of use of pooling and a DataSource in the configuration. Errors like "Connection Refused" and "Invalid Login" (even though using same login as with dbping and SQL*Plus, which both succeed).
- WebLogic 6.1 SP2(eval. edition)
- Oracle 8i (8.1.6)
- Windows 2000
(just for working locally, as dev-box)
Attempted config with WL OCI driver and also (later) with Oracle "thin" driver.
I got, from this site, advice about dbping. I used that to solve one license-related problem, which enabled dbping to finally succeed.
Perhaps an error in edited tsnnames.ora file? Perhaps errors in entries in the console, in the the pooling and/or DataSource config areas? In the CLASSPATH?
I've un-installed WL. Plan to re-install it tomorrow (Wed.). Might need to re-initialize (re-install) Oracle, too -- to get a fresh start (no great loss there -- just getting started).
Much on-line help seems miscellaneous and ad hoc to me -- a newbie to WebLogic.
I'm looking for a careful methodical installation and troubleshooting checklist, or the like.
Anybody got any such thing?
(I must be missing something that's obvious to many others -- especially in this discussion-group.
Any assistance would be much appreciated.
Thank you in advance.

Sun-Certified Java Programmer
Alex Ioannou

Joined: Nov 14, 2001
Posts: 25
Use the tnsping command in dos to ping your oracle database, this will eliminate the tnsnames.ora problem. You'll have to add your oracle bin to the path for this to work.
Ex:- tnsping <entry in tnsnames.ora>
Write a console program using the thin driver that sets up a connection, closes it then quits.
If you can get all that to work so far so good.
Now the big step, use the weblogic console to set up a connection pool AND a datasource for your database.
You need to add the weblogic drivers to PATH, NOT CLASSPATH.
Once it is set up use this method to get a connection:-

Hope this helps
Adam Adams
Ranch Hand

Joined: Nov 28, 2001
Posts: 60
i think you need oracle 8.1.7 instead of oracle 8.1.6 .. try to modify your path and classpath:
set PATH=c:\bea\wlserver6.1\bin\oci817_8;c:\"oracle_Home"\ora81\bin;%PATH%
set CLASSPATH=%JAVA_HOME%\lib\tools.jar;%WL_HOME%\lib\weblogic_sp.jar;%WL_HOME%\lib\weblogic.jar;.\samples\eval\cloudscape\lib\cloudscape.jar; C:\"Oracle_Home"\ora81\jdbc\lib\;C:\"Oracle_Home"\ora81\jdbc\lib\;.\config\examples\serverclasses;%CLASSPATH%

put those in your startup script ...
I agree. Here's the link:
subject: WebLogic6.1/Oracle8.1.6 config problem (obvious to someone?)
It's not a secret anymore!