l***s
发帖数: 28 | 1 I recently start learning the Oracle 9i. I installed the Oracle
in Linux under user Oracle. So when I login as Oracle, I type
sqlplus
Then it asks me user and password. I am confused about this. Since
I have not been able to open the Oracle database yet, how can I
have a user and password for the database? I must be able to login
in as an administrator and for the first time I should have a
default password. Is this right? I learnt that I can prompt to
sqlplus without login. But can I do any adm |
p*********e
发帖数: 204 | 2 Try scott/tiger. That's a typical set of username/password. There should be a
few users already created in your Oracle database. system/manager should work
too.
【在 l***s 的大作中提到】
: I recently start learning the Oracle 9i. I installed the Oracle
: in Linux under user Oracle. So when I login as Oracle, I type
: sqlplus
: Then it asks me user and password. I am confused about this. Since
: I have not been able to open the Oracle database yet, how can I
: have a user and password for the database? I must be able to login
: in as an administrator and for the first time I should have a
: default password. Is this right? I learnt that I can prompt to
: sqlplus without login. But can I do any adm
|
l***s
发帖数: 28 | 3 great! scott/tiger works! ^_^ thanks so much. btw, if a select result is
too long, how to slow it down and shown in multi-pages? like the |more
does for UNIX commands?
thank you
【在 p*********e 的大作中提到】
: Try scott/tiger. That's a typical set of username/password. There should be a
: few users already created in your Oracle database. system/manager should work
: too.
|
p*********e
发帖数: 204 | 4 With SQL*Plus, I don't know if there is a way to make it stop at the end of
each page, like the |more does. You might have to try a different querying
tool. SQL*Plus is about the least user-friendly tool I've used.
be a
work
【在 l***s 的大作中提到】
: great! scott/tiger works! ^_^ thanks so much. btw, if a select result is
: too long, how to slow it down and shown in multi-pages? like the |more
: does for UNIX commands?
: thank you
|
m******t
发帖数: 2416 | 5
When you are in sqlplus,
spool results.txt
select * from your table
spool off
would write all the rows selected to results.txt.
【在 l***s 的大作中提到】
: great! scott/tiger works! ^_^ thanks so much. btw, if a select result is
: too long, how to slow it down and shown in multi-pages? like the |more
: does for UNIX commands?
: thank you
|
l***s
发帖数: 28 | 6 I see. so there aren't commands to do the |more thing in sqlplus...
thanks..
【在 p*********e 的大作中提到】
: With SQL*Plus, I don't know if there is a way to make it stop at the end of
: each page, like the |more does. You might have to try a different querying
: tool. SQL*Plus is about the least user-friendly tool I've used.
:
: be a
: work
|
l***s
发帖数: 28 | 7 great, this way worked for me..thanks alot. ^_^
【在 m******t 的大作中提到】
:
: When you are in sqlplus,
: spool results.txt
: select * from your table
: spool off
: would write all the rows selected to results.txt.
|
l***s
发帖数: 28 | 8 oh, I just found something. I would like to share with your guys...^_^
we can use
set pause on;
to activate the paging feature, so that the ouput will pause at the end of
each screen...^_^
thanks
【在 l***s 的大作中提到】
: I see. so there aren't commands to do the |more thing in sqlplus...
: thanks..
|
p*********e
发帖数: 204 | 9 Nice to know. Thanks :)
of
querying
【在 l***s 的大作中提到】
: oh, I just found something. I would like to share with your guys...^_^
: we can use
: set pause on;
: to activate the paging feature, so that the ouput will pause at the end of
: each screen...^_^
: thanks
|
l***s
发帖数: 28 | 10 hi, you know what? this scott/tiger pair worked for almost two days
and not it stops working...:( is it designed to be like that? let you
work with it for only the beginning? or what? now i have no user and
passwork to use le...555
【在 p*********e 的大作中提到】
: Try scott/tiger. That's a typical set of username/password. There should be a
: few users already created in your Oracle database. system/manager should work
: too.
|
|
|
m******t
发帖数: 2416 | 11
use SYS/change_on_install, or SYSTEM/manager to log in as SYSDBA, then create
new users.
BTW, do take a hint from the default password and change it after the first
time you log in. 8-)
【在 l***s 的大作中提到】
: hi, you know what? this scott/tiger pair worked for almost two days
: and not it stops working...:( is it designed to be like that? let you
: work with it for only the beginning? or what? now i have no user and
: passwork to use le...555
|
l***s
发帖数: 28 | 12 both the SYS/change_on_install and the SYSTEM/manager are said to be :
ORA-01017: invalid username/password; logon denied
:(
【在 m******t 的大作中提到】
:
: use SYS/change_on_install, or SYSTEM/manager to log in as SYSDBA, then create
: new users.
: BTW, do take a hint from the default password and change it after the first
: time you log in. 8-)
|
m******t
发帖数: 2416 | 13
Nobody else uses that oracle instance, right? Try those passwords again with
all upper-cases - I don't remember which cases they are...
【在 l***s 的大作中提到】
: both the SYS/change_on_install and the SYSTEM/manager are said to be :
: ORA-01017: invalid username/password; logon denied
: :(
|
s*******e
发帖数: 151 | 14 after you log in to the oralce,
you can try this:
sqlplus /nolog
and you can connect as sysdba. |
s*******e
发帖数: 151 | 15 by the way, did you create your database? maybe you need to create your
database first. you can use "dbca" command and create your database. |
s***m
发帖数: 28 | 16
You may want to create a database first before you create any user. Login as
dba create database, then create user with proper privilege in your database.
On Orace machine
sqlplus /nolog;
connect system as sysdba;
######Then create your user#############3
create user yourusername identified by 'password';
grant connect to yourusername;
grant resource to yourusername;
You need to setup appropriate tablespace for your user so user will not put
junk into system tablespace.
【在 s*******e 的大作中提到】
: by the way, did you create your database? maybe you need to create your
: database first. you can use "dbca" command and create your database.
|
l***s
发帖数: 28 | 17 this is very helpful...many thanks...^_^
【在 s***m 的大作中提到】
:
: You may want to create a database first before you create any user. Login as
: dba create database, then create user with proper privilege in your database.
: On Orace machine
: sqlplus /nolog;
: connect system as sysdba;
: ######Then create your user#############3
: create user yourusername identified by 'password';
: grant connect to yourusername;
: grant resource to yourusername;
|
