• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
  • Mikalai Zaikin

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

Posts: 18
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
Posts: 25
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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\classes111.zip;C:\"Oracle_Home"\ora81\jdbc\lib\classes12.zip;.\config\examples\serverclasses;%CLASSPATH%

put those in your startup script ...
    Bookmark Topic Watch Topic
  • New Topic