Re: TRYING TO CONNECT

So, back up 3 or 4 threads...
You were using the 8i version of SQL*Plus - that would use (at least!) [oracle_8i_home]\network\admin See if you can copy these network settings to your current environment, whatever version.

Arthur wrote:

> Hmmm, you got me there. I just installed 8iPE when I wanted to learn
> Pl/SQL and the run SQL*PLUS 8 and it connects right away to
> the database - I didn't have to do anything. The way I see it,
> when I installed 8i and it created the database, the SQL*PLUS is
> native to the database and thus just connect into it right away.
> With the development, cause it's a tool and need to access the
> database that was not created by itself but by 8I, it needs to have a
> listener running on the 8i's Database to let it connects into it.
>
> Ooo, hehe, remember - I was using the SQL*plus that came with
> the installation of 8i - NOT the SQL*plus that came with the
> installation of Development.
>
> On Fri, 29 Sep 2000 18:28:01 GMT, frank <fbortel_at_home.nl> wrote:
>
> >Arthur wrote:
> >
> >> Thank you so much.!!
> >> But no, I didn't need listerner when I was doing my PL/SQL
> >>
> >
> >How did you do that, then? PL/SQL is stored/executed in/on the
> >database, using sqlplus as front end. And that uses exactly the
> >same mechanism to connect as Developer. Same userid's and passwords
> >should do, too.
> >I'm puzzled
> >
> >Frank
> >
> >>
> >> On Wed, 27 Sep 2000 19:19:41 GMT, frank <fbortel_at_home.nl> wrote:
> >>
> >> >What version Developer exactly???
> >> >Dev/2000 is uses V7 RSF's (Required Support Files), and
> >> >therefor searches in oracle_home\network\admin.
> >> >Your 8i however uses oracle8i_home\network\admin.
> >> >Did you need a listener and/or a connect string when learning PL/SQL?
> >> >If so, copy tnsnames.ora from o8i to o_home (mind the syntax
> >> >differences!)
> >> >
> >> >As usual: state the versions, to the 5th decimal, and the exact error
> >> >codes.
> >> >
> >> >Arthur wrote:
> >> >
> >> >> Hi,
> >> >>
> >> >> I am hoping someone would be able to help me. I got an Oracle 8i PE
> >> >> and installed it and been using that to learn PL/SQL with no problem.
> >> >> Now I am trying to learn Reporting with Oracle and have installed
> >> >> the Development 2000 and also trying to install the Demo package
> >> >> with it but it keeps on asking me to log onto a database.
> >> >> I have got the PE database running but that doesn't seem to like it.
> >> >>
> >> >> Please, can someone tell me how to connect to the PE database
> >> >> with development 2000 so I can be on my way to my study again ?
> >> >>
> >> >> Please.
> >> >>
> >> >> Arthur
> >> >
> >
Received on Mon Oct 02 2000 - 14:05:13 CDT