I'm starting to learn Oracle on my own (WinXP box) - so I just installed
it - I see that the server was the same name as the computer....however,
during installation, all I was asked for was a password - nowhere did it ask
me for a user name - -

I come from a SQL Server world, so please excuse my extreme newbiness - -
1. What is the default username for Oracle?
2. Is the Oracle Admin Assistant akin to the Enterprise manager in SQL
Server?
3. I try to connect in OAA - and it asks me for a Net Service Name - - where
do I find that?

thanks

Hi!
I assume you use 10g?
During installation you was asked for
user/schema 'sys' and 'system' - i think it's correspond to 'dbo' in SQL
Server (can you have more than one user/schmema in SQL Server who owns
tables, indexes etc...?)

One of the most importants concepts are that you normally only have one
Oracle-database-server instans on one machine.
Different projects will/should be in their own schema (user that owns
objects).

If you have forgotten the username for sys or system you can log on, if you
are the right os-user:
from dosprompt:
set ORACLE_SID=YOUR_DB_INSTANCE_NAME
sqlplus "/ as sysdba"

Then you would be able to change pw for the users.

1.) One of the standard schema is scott (pw=tiger)
2.) Yes, 10g have an web-based one; before this you have OEM (Oracle
Enterprise Manager)
3.) could be your_db_instance_name.world

If you want to do serious work: tahiti.oracle.com there is all you need for
the beginning... ;^)
Greetings
Bjørn


"Elmo Watson" <Elmo (AT) no (DOT) spam.yahoo.com> skrev i en meddelelse
news:d6-dnRYjd6X3Zv7eRVn-vw (AT) comcast (DOT) com...