Re: Oracle Lite on 98 and TNS

Steff,

I'm not sure why it's hanging, but I don't think it's a memory issue. Unfortunately I don't have it installed on my test box and I've already got 8.0.6 installed in the default home so I can't install it due to the 8.0.5 files it needs.

Are you using the version of SQL*Plus that came with Olite?
  If you use a version of SQL*Plus installed in a different Oracle home I don't think it can find the Olite dll's.

Did you reboot after installing Olite?
  When in doubt, reboot ;)

Try using the 32-bit ODBC Test utility (it should be in the same program group as the Olite Navigator) to see if it can connect to Olite.

I don't know if it's changed with Olite 8i, but the older versions required the ODBC:POLITE to be in caps.

HTH,

• Anita
  • Steff Gonos <steff_gonos_at_yahoo.com> wrote:
    > Anita:
    >
    > When we tried that it hangs -
    > Any ideas ?
    > How much memory does it need ?
    >
    > Thanks.
    >
    > Steff Gonos
    >
    >
    > --- "A. Bardeen" <abardeen1_at_yahoo.com> wrote:
    > > Steff,
    > >
    > > Olite is a completely different beast from
    > Personal
    > > Oracle or Oracle Server. It does not have a
    > > listener
    > > and cannot receive incoming Net8 connections (it
    > can
    > > make outgoing Net8 connections). You connect to
    > the
    > > Olite db via ODBC (Olite 8i will also accept a
    > JDBC
    > > connection).
    > >
    > > For an ODBC connection from SQL*Plus:
    > > Username: SYSTEM
    > > Password: MANAGER (actually I think anything
    > will
    > > work as Olite, or at least the pre-8i versions,
    > > didn't
    > > check any security/privileges)
    > > Connect string: ODBC:<dsn>
    > > Where <dsn> is the ODBC Data Source Name. By
    > > default a DSN of POLITE is created upon
    > > installation.
    > >
    > > HTH,
    > >
    > > -- Anita
    > >
    > > --- Steff Gonos <steff_gonos_at_yahoo.com> wrote:
    > > > Happy Logical Monday folks -
    > > >
    > > > Been working Sun,and now I have a user that
    > > > wants to install Oracle 8i Lite. What's the
    > > > experience of using this on a 98 system ?
    > > >
    > > > How does the Laptop make the TNS connection ?
    > > >
    > > > When he tries to logon, he can't. What special
    > is
    > >
    > > > needed for a 98 system ?
    > > > Thanks.
    > > > Steff Gonos
    > > >
    > > > =====
    > > >
    > >
    >

    ---

    
    > > > If it's true that we are here to help others,
    > then
    > > > what
    > > > exactly are the OTHERS here for?
    > > >
    > >
    >

    ---

    
    > > > Steff Gonos
    > > > steff_gonos_at_yahoo.com
    > > >
    > > >
    > __________________________________________________
    > > > Do You Yahoo!?
    > > > Kick off your party with Yahoo! Invites.
    > > > http://invites.yahoo.com/
    > > > --
    > > > Author: Steff Gonos
    > > > INET: steff_gonos_at_yahoo.com
    > > >
    > > > Fat City Network Services -- (858) 538-5051
    > > FAX:
    > > > (858) 538-5051
    > > > San Diego, California -- Public Internet
    > > > access / Mailing Lists
    > > >
    > >
    >

    ---

    
    > > > To REMOVE yourself from this mailing list, send
    > an
    > > > E-Mail message
    > > > to: ListGuru_at_fatcity.com (note EXACT spelling of
    > > > 'ListGuru') and in
    > > > the message BODY, include a line containing:
    > UNSUB
    > > > ORACLE-L
    > > > (or the name of mailing list you want to be
    > > removed
    > > > from). You may
    > > > also send the HELP command for other information
    > > > (like subscribing).
    > >
    > > __________________________________________________
    > > Do You Yahoo!?
    > > Send instant messages & get email alerts with
    > Yahoo!
    > > Messenger.
    > > http://im.yahoo.com/
    > > --
    > > Author: A. Bardeen
    > > INET: abardeen1_at_yahoo.com
    > >
    > > Fat City Network Services -- (858) 538-5051
    > FAX:
    > > (858) 538-5051
    > > San Diego, California -- Public Internet
    > > access / Mailing Lists
    > >
    >

    ---

    
    > > To REMOVE yourself from this mailing list, send an
    > > E-Mail message
    > > to: ListGuru_at_fatcity.com (note EXACT spelling of
    > > 'ListGuru') and in
    > > the message BODY, include a line containing: UNSUB
    > > ORACLE-L
    > > (or the name of mailing list you want to be
    > removed
    > > from). You may
    > > also send the HELP command for other information
    > > (like subscribing).
    >
    >
    > =====
    >

    ---

    
    > If it's true that we are here to help others, then
    > what
    > exactly are the OTHERS here for?
    >

    ---

    
    > Steff Gonos
    > steff_gonos_at_yahoo.com
    >
    > __________________________________________________
    > Do You Yahoo!?
    > Send instant messages & get email alerts with Yahoo!
    > Messenger.
    > http://im.yahoo.com/
    > --
    > Author: Steff Gonos
    > INET: steff_gonos_at_yahoo.com
    >
    > Fat City Network Services -- (858) 538-5051 FAX:
    > (858) 538-5051
    > San Diego, California -- Public Internet
    > access / Mailing Lists
    >

    ---

    
    > To REMOVE yourself from this mailing list, send an
    > E-Mail message
    > to: ListGuru_at_fatcity.com (note EXACT spelling of
    > 'ListGuru') and in
    > the message BODY, include a line containing: UNSUB
    > ORACLE-L
    > (or the name of mailing list you want to be removed
    > from). You may
    > also send the HELP command for other information