>Hi, Bin:

I think I have found the cause of the error message when running the ch2 
example of the book -- the Oracle on my PC is only an Oracle client. I 
need to install the server version. Is that right?

Thanks 

Phil Yan 

Thanks a lot for this and I will try it.
> 
> Phil 
> 
> I am not sure with Oracle for SID as well. When installing the Oracle, 
it 
> > will take two parameter, one is service, the other is SID.  You may 
ask 
> any 
> > Oracle DBA for the detail.
> > 
> > Bin
> > 
> > 
> > >From: "phil yan" <phil_yan@h...>
> > >Reply-To: "Java 2 Enterprise Edition" <j2ee@p...>
> > >To: "Java 2 Enterprise Edition" <j2ee@p...>
> > >Subject: [j2ee] Re: help
> > >Date: Tue, 22 Jan 2002 19:14:08
> > >
> > > >I am not sure about the SID -- it was installed on the PC before I 
> came.
> > >By the way, where could I find the SID information in the oracle 
> directory.
> > >
> > >Thanks a lot.
> > >
> > >Phil
> > >
> > >  I am not talking about the db global name, It should be the SID 
when 
> you
> > > > install the database. Please check that. I just installed Oracle 
and 
> the
> > > > sample from the book yesterday and it run fine.
> > > >
> > > > Bin
> > > >
> > > >
> > > > >From: "phil yan" <phil_yan@h...>
> > > > >Reply-To: "Java 2 Enterprise Edition" <j2ee@p...>
> > > > >To: "Java 2 Enterprise Edition" <j2ee@p...>
> > > > >Subject: [j2ee] Re: help
> > > > >Date: Tue, 22 Jan 2002 18:08:31
> > > > >
> > > > > >Yes. The DB name is zeppelin.
> > > > >
> > > > >Phil
> > > > >
> > > > >Is you Oracle database SID called zeppelin?
> > > > > >
> > > > > > Bin
> > > > > >
> > > > > >
> > > > > > >From: "phil yan" <phil_yan@h...>
> > > > > > >Reply-To: "Java 2 Enterprise Edition" <j2ee@p...>
> > > > > > >To: "Java 2 Enterprise Edition" <j2ee@p...>
> > > > > > >Subject: [j2ee] help
> > > > > > >Date: Tue, 22 Jan 2002 17:06:45
> > > > > > >
> > > > > > >Hi, there:
> > > > > > >
> > > > > > >I need help for running the examples in Professional Java 2
> > >Enterprise
> > > > > > >Edition with BEA Weblogic Server.
> > > > > > >
> > > > > > >When I was running the script:
> > > > > > >
> > > > > > >java utils.dbping oracle scott tiger zeppelin
> > > > > > >
> > > > > > >I got this error message:
> > > > > > >
> > > > > > >C:\wlsbook>setenv 2
> > > > > > >------------------------------------------------------------
> > > > > > >Setting environment for chapter 2
> > > > > > >------------------------------------------------------------
> > > > > > >Current settings:
> > > > > > >       Java Home = C:\jdk1.3
> > > > > > >   WebLogic Home = C:\weblogic
> > > > > > >    Project Home = C:\wlsbook
> > > > > > >       CLASSPATH 
> > > > > >
> > > > >
> > > 
> 
>C:\weblogic\lib\weblogic510sp9boot.jar;C:\weblogic\classes\boot;C:\weblogi
> > > > >c
> > > > > > >\lib\weblogic510sp9.jar
> > > > > >
> > > > >
> > > 
> 
>weblogic\license;C:\weblogic\classes;C:\weblogic\lib\weblogicaux.jar;c:\wl
> > > > >s
> > > > > > >book\srv\c02-srv\serverclasses
> > > > > > >
> > > > > > >            PATH = C:\wlsbook\bin;C:\jdk1.3
\bin;c:\Oracle\Ora81
> > > > > > >\bin;C:\ORACLE\ORA81\bin;C:\PROGRA~1\RATIONAL\RATION~1
> > > > > > 
> > > >CROOT\bin;C:\PROGRA~1\RATIONAL\RATION~1\NUTCROOT\bin\x11;C:\PROGRA~1
> > > > > > >\RATIONAL\RATION~1\NUTCROOT\mksnt;C:\Program Fil
> > > > > > >racle\jre\1.1.7\bin;C:\IBMDebug\bin;C:\IBM
> > > > > > >Connectors\Encina\bin;;C:\IBMCON~1
> > > > >\CICS\BIN;C:\WINNT\system32;C:\WINNT;C:
> > > > > > >NT\System32\Wbem;C:\IMNnq_NT;;C:\Program
> > > > >Files\Rational\common;C:\Program
> > > > > > >Files\Rational\Rational Test;C:\Program Fi
> > > > > > >Rational\Coverage;C:\Program
> > >Files\Rational\Coverage\cache;C:\PROGRA~1
> > > > > > >\DOCUME~1\DFCRE41\BIN;C:\PROGRA~1\DOCUME~1\SHA
> > > > > > >c:\jdk1.3.1\bin;;C:\Rational\ClearCase\bin;C:\Program
> > > > > > >Files\Rational\ClearCase\bin;C:\Program Files\Common Files\Web
> > > > > > >
> > > > > > >Shared;C:\VisualCafe\VCafe\Jdk13
> > > > >\Bin;C:\VisualCafe\Bin;C:\VisualCafe\Java2
> > > > > > >\Bin;C:\VisualCafeEE4.5\Bin;C:\VisualCafe
> > > > > > >5\Java2\Bin;C:\VisualCafe\VCafe\Bin;C:\forte4j\bin;C:\tomcat4
> > > > >\bin;C:\jdk1.3
> > > > > > >\bin;C:\jakarta-ant-1.4\bin;C:\weblogic\b
> > > > > > >:\weblogic\bin\oci815_8
> > > > > > >
> > > > > > >C:\wlsbook>
> > > > > > >C:\wlsbook>
> > > > > > >C:\wlsbook>java utils.dbping oracle scott tiger zeppelin
> > > > > > >
> > > > > > >
> > > > > > >----------  LOGIN ERROR CODE: 24327
> > > > > > >
> > > > > > >Error encountered:
> > > > > > >
> > > > > > >java.sql.SQLException: ORA-24327: need explicit attach before
> > > > > > >authenticating a user - (scott/********@zeppelin)
> > > > > > >         at weblogic.db.oci.OciConnection.getLDAException
> > > > > > >(OciConnection.java:143)
> > > > > > >         at weblogic.jdbcbase.oci.Driver.connect
> (Driver.java:157)
> > > > > > >         at
> > > > >java.sql.DriverManager.getConnection(DriverManager.java:517)
> > > > > > >         at
> > > > >java.sql.DriverManager.getConnection(DriverManager.java:146)
> > > > > > >         at utils.dbping.main(dbping.java:156)
> > > > > > >
> > > > > > >Note;
> > > > > > >
> > > > > > >I have set up the setenv.cmd and db.cmd already.
> > > > > > >
> > > > > > >Thanks
> > > > > > >
> > > > > > >Phil Yan
> > >$subst('Email.Unsub').
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > Bin Zhou
> > > > > >
> > > > > >
> > > > > >
> > > > > > 
_________________________________________________________________
> > > > > > Get your FREE download of MSN Explorer at
> > > > >http://explorer.msn.com/intl.asp.
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > Bin Zhou
> > > >
> > > >
> > > >
> > > > _________________________________________________________________
> > > > Get your FREE download of MSN Explorer at
> > >http://explorer.msn.com/intl.asp.
> > > >
> > >
> > 
> > 
> > _________________________________________________________________
> > Get your FREE download of MSN Explorer at 
> http://explorer.msn.com/intl.asp.
> >