Nospam wrote:
> "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?
Please find yourself someone that knows something about Oracle to act as
a mentor. We can help with questions but that should not be confused
with being a substitute for training.
Thyere is no relationship between SID and selecting from anything unless
the data you are selecting pertains to a specfific SID. There is nothing
in the emp table that relates to a SID.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sat Aug 14 2004 - 15:40:09 CDT
