Oracle Databases - Very Beginner question

Author

Very Beginner question

Elmo Watson

2005-10-29, 8:24 pm

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

bdj

2005-11-08, 4:16 pm

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_I
NSTANCE_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_nam
e.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@no.spam.yahoo.com> skrev i en meddelelse
news:d6-dnRYjd6X3Zv7eRVn-vw@comcast.com...
> 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
>

Sponsored Links