Argh, can someone help me set up Oracle?

[Gonad the Barbarian]

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]

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]

dont you wish you were using MS Sql Server. (Sorry its my job here on the board to shamelessly plug MS products)

 

[777php]

...or use mySQL for those of us that cannot afford MS SQL server. 😀

 

[HamSupLo]

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]

Eh, I used to remember how to do this...

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

 

[Gonad the Barbarian]

Thanks guys, got it worked out more or less here:

http://forums.anandtech.com/messageview.cfm?catid=33&threadid=750115

Now take a look at my code and tell me why it's not working. 🙁