Argh, can someone help me set up Oracle?

Oct 16, 1999
10,490
4
0
I need to get Oracle set up on my machine for a project. I get everything installed, now WTF am I supposed to type in SQL Plus to log into my database? I never set a username/password/hostname in the install or when the database was created. Are there some defaults I'm supposed to use or am I missing where I set this info?
 

cyclistca

Platinum Member
Dec 5, 2000
2,885
11
81
Look for something called Net8 Assistant. Number might be different depending on which version of Oracle your using. Rest is pretty much menu driven from there.
 

Ameesh

Lifer
Apr 3, 2001
23,686
1
0
dont you wish you were using MS Sql Server. (Sorry its my job here on the board to shamelessly plug MS products)
 

HamSupLo

Diamond Member
Aug 18, 2001
4,021
0
0
there's several built in accounts you need to log in with before creating a personal accout. You can try:

username: password:
System manager
Sys change_on_install

then type CREATE USER gonad. GRANT DBA to gonad.

You need the name of the database to login to. Use the Oracle Database Configuration Assistant to setup one if you haven't already.

 

isasir

Diamond Member
Aug 8, 2000
8,609
0
0
Eh, I used to remember how to do this...

Default username and password should be system/manager or just 'internal' as username