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

[Larry LeFever]

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.

[Alex Ioannou]

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:-

public static Connection connect() throws SQLException, NamingException 
{  Context ctx = null;
   Hashtable ht = new Hashtable();
   ht.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");
   ht.put (Context.PROVIDER_URL,"t3://localhost:7001");
  ctx = new InitialContext(ht);
  javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup("<name of datasource>");
  java.sql.Connection conn = ds.getConnection();

  return conn;
   }

Hope this helps
Al

[Adam Adams]

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 ...