"Hans Forbrich" <forbrich_at_yahoo.net> wrote in message
news:AgrTc.20338$fz2.1794_at_edtnps89...
> Nospam wrote:
>
> > I have installed oracle 10g on red hat linu 9. I am wondering what I
type
> > to access the sample dataase scott/tiger v$ession. what do I type after
> >
> > sysdba /nolog
> >
> > to access and manipulate the sample databases?
> >
> > thanks
>
> 1) Go to http://otn.oracle.com
>
> In the 'Select Training' box (bottom, right side), click on Oracle By
> Example.
>
> In 'Product Areas' section, click on 'Oracle Database, and follow the
> installation for 10g. It does give you some hints.
>
> 2) Go to http://docs.oracle.com and pick up the Concepts manual. Read
that
> several times. The manual is available for each version of the database.
>
> 3) Understand that the 'command line tool' is sqlplus. It exists in the
> $ORACLE_HOME/bin directory. If you can not get 'sqlplus' at the Linux
> command line to respond, you have not configured the system right - go
back
> to the install discussion.
>
> If sqlplus responds, enter the user name and password. If you have
> installed with all defaults the users (OE, SH, HR, and SCOTT) will be
> created but not unlocked so you would probably log onto SYSTEM something
> like
>
> ----------
> sqlplus
> system
> ******* (<< the password you set during installation)
> alter user OE identified by new_password account unlock;
> alter user SCOTT identified by new_password account unlock;
> exit
>
> sqlplus
> scott
> ****** (<< the password you set above)
> SELECT *
> FROM EMP;
> -------------
>
>one quick question I am to take it that sample databases are provided for
scott/tiger that i can select * from emp; ? I do not have to use the SID I
supplied in the tnsnames.ora and listener.ora files?
Received on Sat Aug 14 2004 - 15:04:35 CDT
