This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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
Author

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

Larry LeFever
Greenhorn

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).
Using:
- 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
Greenhorn

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.
c:\bea\wlserver6.1\bin\oci817_8;
Once it is set up use this method to get a connection:-

Hope this helps
Al
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\classes111.zip;C:\"Oracle_Home"\ora81\jdbc\lib\classes12.zip;.\config\examples\serverclasses;%CLASSPATH%

put those in your startup script ...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: WebLogic6.1/Oracle8.1.6 config problem (obvious to someone?)
 
Similar Threads
JNDI in EJB connecting to oracle
help refresh Connection Pool
SQL Exception Weblogic9.1 Oracle 10g
Help on DB2
Error Using JDrivers to Connect to Oracle