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?

 

[manly]

If you created the sample database for a default install, then you can login with:

scott/tiger

I think you still need to start the database though, in which case you probably should add a real user account.

 

[Gonad the Barbarian]

My God dude, you rule. Why did that work? And how did you know?

 

[manly]

Oracle has very extensive documentation you can view at Oracle Technet with a free account.

You need all those documents since Oracle is such a beast.

 

[billandopus]

That's the default and the first thing they taught us when I did the Oracle DBA Cert. That was a little while ago and i've promptly forgotten pretty much everything. So much for certification studies without real world work experience. Reminds me i'd better get back to studying for the upgrade exam. There's a void somewhere in my head filled with Oracle info. Sad isn't it?

 

[Gonad the Barbarian]

I'm taking classes now to get a developer cert. I hate not knowing enough about Oracle itself to actually use it for anything other than typing code. I still can't log in to the school server from here for some reason. I ran the error I got through google everything that came up looked like Greek to me. Net8 assistant and the configuration assistant won't even load. I try to run them and absolutely nothing happens. But I'm just glad I was able to test my code here. But even that has decided to give me problems. It compiles fine but when I run it I get the dreaded 'PLS-00306: wrong number or types of arguments...' error. Here's my code, if anyone could tell me what's wrong I'd appreciate it.

create or replace procedure new_member(

v_fname in S_MEMBER.First_Name%TYPE,
v_lname in S_MEMBER.Last_Name%TYPE,
v_street in S_MEMBER.Street%TYPE,
v_city in S_MEMBER.City%TYPE,
v_phone in S_MEMBER.Phone%TYPE)

as

v_date S_MEMBER.Valid_Date%TYPE:=sysdate;

begin

insert into S_MEMBER(Member_ID, First_Name, Last_Name, Street, City, Phone, Valid_Date) values(
s_member_id.NEXTVAL, v_fname, v_lname, v_street, v_city, v_phone, v_date);

end new_member;

/