Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: TRYING TO CONNECT

Re: TRYING TO CONNECT

From: Arthur <mechhunter_at_rocketmail.com>
Date: Sat, 30 Sep 2000 05:28:14 GMT
Message-ID: <39d578ec.47012322@news.iinet.net.au>

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 Sat Sep 30 2000 - 00:28:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US