| cant 'start' oracle [message #290553] |
Sat, 29 December 2007 21:20  |
Daanish
Messages: 5
Registered: November 2007
|
Junior Member |
|
|
This is a bit of a broad question, but is also time-sensitive so I hope people can help 
Here's the deal - I just took a course to become an Oracle Certified Associate in DBA 10g. Unfortunately this class wasn't taught at all well so I haven't learned that much. I now need to study for it at home, but I cant even start the database!
Because of this pending certification I have gotten an interview for an Oracle Developer (NOT Administrator, which is what I've been studying). This interview will be based on PL/SQL and Oracle Forms. I've never studied these so now first question is, what software do I need to learn them? Do I need anything at all, or can I just learn it by reading a few tutorials? Second, if I do need something, what should I get? Something on the Administration side, with which I can practice for my DBA exam as well, will that do? Or do I need something on the Development side? I just want to practice PL/SQL and Oracle Forms for now, I have no idea how to get access to them.
If I do get the DBA there's diff versions. There is Oracle Database 10g and Oracle Database 10g Express Edition.
By the way are the versions offered on the site free, and are they complete?
Would appreciate any help one can give!
Thanks
Dan
|
|
|
|
| cant 'start' oracle [message #290554 is a reply to message #290553] |
Sat, 29 December 2007 22:02  |
Daanish
Messages: 5
Registered: November 2007
|
Junior Member |
|
|
Hello
I've tried installing Oracle 10g DBA. I got the CD from another country, it appears its not an original  Regardless, it installed w/o any problems but now I dont know what to do. How do I 'start'? I searched the directory for exe files, came across a bunch such as sqlplus but the username and password isnt working.
For login/pw I've tried orcl/xxxxxx (the default login was given during the install, the xxxxxx was the pw i chose) it said invalid and denied. I also tried scott/tiger (which said locked) and even sys and sysdba but none are working.
I then went to http://localhost:5500/em which was given to me right after the install. This screen is divided into two sections, the Host Credentials and the Database Credentials, each asking for a username and pw. From the responses I've gotten to various combinations it appears I should be logging in via Host Credentials but again neither of the logins I mentioned above are working. Would host credentials maybe just be asking the name of my computer?
I also have Oracle 10g Developer Suite, same problems with that. I still cant login.
I need to learn PL/SQL and Oracle Forms, can that be done on DBA 10g or do I need something else? Its rather urgent, have an interview in a few days!
Best
Dan
|
|
|
|
|
|
| Re: cant 'start' oracle [message #290557 is a reply to message #290554] |
Sat, 29 December 2007 22:33 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>I've tried installing Oracle 10g DBA.
I've been doing Oracle for years & have never heard of "10g DBA".
>I got the CD from another country,
You can always download your own s/w from
http://otn.oracle.com
> Its rather urgent, have an interview in a few days!
I suggest you practice saying "Can I SuperSize this order for you".
Oracle is not MATH 101 where you can cram for a few hours before the final test.
If you are interviewed by anyone knowledgeable, you'll only make a fool of yourself.
IMO, you are a couple of years too late in studying PL/SQL & Forms.
[Updated on: Sat, 29 December 2007 22:33] by Moderator Report message to a moderator |
|
|
|
| Re: cant 'start' oracle [message #290618 is a reply to message #290554] |
Sun, 30 December 2007 16:45 |
 |
Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
Orcl is not a user; It is your default database name. So, you need to:
CONNECT system/xxxxxx@orcl
or:
CONNECT sys/xxxxxx@orcl AS SYSDBA
Then:
ALTER USER scott ACCOUNT UNLOCK;
Then you can:
CONNECT scott/tiger@orcl
If you are connecting to your local database, you can ommit the @orcl from all of the above.
However, you are a long ways from qualifying as a developer or DBA. I would cancel the interview.
[Updated on: Sun, 30 December 2007 16:52] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
