Thanks! These are all great suggestions and answers!
--
...
"Hans Forbrich" <forbrich_at_telusplanet.net> wrote in message
news:3F3468A2.C7C2BD45_at_telusplanet.net...
> atl- wrote:
>
> > I just installed Oracle 9i for Windows XP-Pro.
> > I chose to install the "Standard Edition".
> > I have a few newbie questions:
> >
> > 1) What is a hoststring (when I try to start SQL-Plus) ?
> > I left "hoststring" blank, and signed in as user=Scott pw=Tiger.
> > 2) Does starting SQL-Plus also start a database ?
> > 3) Did I need to create a regular user when I did the installation, or
can I
> > do that any time as
> > SYS or SYSTEM ?
> > 4) Do I need to re-install as something higher than "Standard Edition"
in
> > order to install JDeveloper ?
> >
> > Thanks for any help. (I took a couple of Oracle classes over 2 years
ago,
> > but never really put anything into practice, so I appreciate any
patience in
> > answering these questions.)
>
> Please go to http://otn.oracle.com, click on 'Sample Code' in the left
hand menu
> and then click on 'Oracle By Example' for some helpful tutorials. Most of
these
> questions are answered in detail in the step-by-step examples provided..
>
> Quick answers:
>
> 1) host string identifies the computer and the specific oracle
environment.
> This generally ties to the TNSNAMES.ora file
>
> 2) no. SQL Plus is simply a command line database interaction tool.
However
> you can use it to run the STARTUP and SHUTDOWN commands. Other than
that,the
> database is normally running in the background waiting to respond to
database
> requests that are received by the istener.
>
> 3) create them any time using 'create user xyz identified by password'.
there
> are additional things to do - see the examples. In the mean time,
scott/tiger
> is a demo and learning playground.
>
> 4) JDeveloper is totally independant of the database & you can use it to
develop
> non-database Java code as well. However some of the Java you can develop
may
> require access to features that are not available in the Standard Edition
of the
> database. Check out OTN's "Oracle9i Database: A Family of Database
Products" on
> http://otn.oracle.com/products/oracle9i/content.html for an overview of
which
> features are in which edition.
>
> If you haven't done so, I also encourage you to go to the 'Documentation'
> section of OTN, look for the 'Concepts' manual and read the first 3
chapters to
> get an overview of the Oracle environment. This environment can be very
> confusing and overwhelming if you don't get the concepts in place first.
You
> might also want to do a web search on 'ORACLE FAQ'
>
> HAND!
>
Received on Fri Aug 08 2003 - 22:51:35 CDT
