Re: Password insanity :

Ah - don't!

Maybe it is worth saving a few bucks by getting a technet account? check http://technet.oracle.com - it's free, and there's a wealth of knowledge!
As is here, and in othe NG's.

Like Kenneth: welcome aboard!

--
Frank
Art Heyman <us004258_at_mindspring.com> schreef in berichtnieuws
8osl04$4u$1_at_nntp9.atl.mindspring.net...


> That was very  kind of you - and given what I've heard  of Oracle I

> understand it - I'll try not to run away screaming. Off to the bookstore

> tomorrow.

>

> Kenneth C Stahl <kcstahl_at_atl.mediaone.net> wrote in message

> news:39B1D1B4.21D40ED5_at_atl.mediaone.net...

> > Art Heyman wrote:

> > >

> > > Password insanity :

> > >

> > >   A newbie , just installed working demos (so many books and disks for

 $15 -


> > > thought I was lucky ) of Oracle 8 on my NT box - NOTHING FUNCTIONS

 (I've


> > > been programming and running my own consulting firm for 12 years -I

 think I


> > > know how to work with software ) I set up what I thought was a

 database - it


> > > 's sometimes called a Manegemet Server - and was told of the various

 so


> > > silly ) passwords to go along with it - when I try to run anything I'm

 asked


> > > for passwords with prompts that have NOTHING to do with the password

> > > descriptions given me - for SQL Plus , for example - what the hell is

 "
 Host


> > > String " ????

> > > I'm happy to kill off what I've done and start over, if I knew how to

> > > associate PW's I'm given with what I'm later asked for -

> > > Many thanks

> >

> > Welcome to the world of Oracle. Unlike most install and use software,

> > the Oracle RDBMS is virtually worthless out of the box because there is

> > a lot of setup that must be done to create a database. Then on top of

> > that you must also configure Net8 for client-side operations and a

> > listener for the server side.

> >

> > For instance, the "host string" is a service name that is created in the

> > tnsname.ora file. If you are running sqlplus on the same machine where a

> > database is located you can just leave that field blank because you'll

> > be using the Bequeth protocol which doesn't need a service name.

> > However, you will have to have the correct ORACLE_SID specified in your

> > environment if you have more than one database instance.

> >

> > When the software was installed, was a sample database created? If so

> > look in the Services control panel and find a service that will having

> > ORCL as a part of its name. If you start this service it will create the

> > instance and mount the sample database. After that you can start sqlplus

> > and enter SYSTEM as the userid and MANAGER as the password. Be careful

> > though, that login has DBA privileges and if you start experimenting

> > around too much with DML statements you could render your database

> > inoperable.

> >

> > For those of us who have been around Oracle for a while, all of this

> > stuff comes naturally - but it really isn't the same as just running an

> > install program and then clicking an icon and being able to work with

> > the database.  Which is, of course, why we DBAs tend to make a good

> > chunk of pocket change.

>

>