Re: Oracle9i/Win newbie questions

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:29:48 CDT