login details for SYSTEM account in oracle 11g

[lalit khera]

hi friends , i am attaching here two files one is login screen for oracle 11g , the next one is already login file with SYS account.
First of all i am using DIP as user account, is it fine to use it??
second one , i do not want to use SYS account, i want to use SYSTEM account. what is the credentials for SYSTEM account.

Third what privileges i should assign to a user for creating the table in the schema.(find attached file).
thanks

[chris webster]

Here's what you need to do:

Stop panicking and relax.

Uninstall Oracle 11g right now, as you are way out of your depth with it and it is preventing you from learning the basics.

Download and install Oracle Express Edition (XE) 11g.

Find a basic tutorial on getting started with Oracle, and work through it properly.

Use all resources to help you figure out what you are doing - tutorials, Oracle documentation, Google, your own brain, online forums etc.

And in case you need it, the forums on Oracle's Technology Network are probably the best place to find advice on problems with Oracle.

[lalit khera]

chris webster wrote:Here's what you need to do:

Stop panicking and relax.

Uninstall Oracle 11g right now, as you are way out of your depth with it and it is preventing you from learning the basics.

Download and install Oracle Express Edition (XE) 11g.

Find a basic tutorial on getting started with Oracle, and work through it properly.

Use all resources to help you figure out what you are doing - tutorials, Oracle documentation, Google, your own brain, online forums etc.

And in case you need it, the forums on Oracle's Technology Network are probably the best place to find advice on problems with Oracle.

yes, i also think so.
but i am using windows 7 64 bit os.
and XE edition is for 32 bit.
will it work on my machine???

[chris webster]

Ouch! Sorry - my fault: I'm not using XE on my 64-bit machine so I hadn't noticed this problem.

You're right, there is (still!) only a 32-bit installer for Oracle XE on Windows. I've just tried to install it on W7 64-it and you get errors about missing registry entries, so this may be a problem.

Plan B:

Stick with your current Oracle installation, but pretend it's Oracle XE i.e. don't touch all the "Oracle" stuff in your Windows menu (like the Oracle Enterprise Manager browser tools), but just use SQL Developer or SQL*Plus to do everything - creating users, connecting to schemas, creating tables etc. This should be all you need in order to follow the tutorials.

Incidentally, the SYSTEM password should be whatever you said it should be when you created the database. Maybe try using the same password as for SYS? Alternatively, if you can log in as SYS (in SQL Developer), go to the "Other Users" entry in the left-hand panel, then select SYSTEM and you should be able to change the SYSTEM users' password.

Sorry for misleading you over XE: it's a great tool for learning Oracle, and it's strange that Oracle still haven't released a 64-bit Windows version!

[lalit khera]

chris webster wrote:Ouch! Sorry - my fault: I'm not using XE on my 64-bit machine so I hadn't noticed this problem.

You're right, there is (still!) only a 32-bit installer for Oracle XE on Windows. I've just tried to install it on W7 64-it and you get errors about missing registry entries, so this may be a problem.

Plan B:

Stick with your current Oracle installation, but pretend it's Oracle XE i.e. don't touch all the "Oracle" stuff in your Windows menu (like the Oracle Enterprise Manager browser tools), but just use SQL Developer or SQL*Plus to do everything - creating users, connecting to schemas, creating tables etc. This should be all you need in order to follow the tutorials.

Incidentally, the SYSTEM password should be whatever you said it should be when you created the database. Maybe try using the same password as for SYS? Alternatively, if you can log in as SYS (in SQL Developer), go to the "Other Users" entry in the left-hand panel, then select SYSTEM and you should be able to change the SYSTEM users' password.

Sorry for misleading you over XE: it's a great tool for learning Oracle, and it's strange that Oracle still haven't released a 64-bit Windows version!

no chris you have not misguided me, but you tried to give an alternative.
I think its a good place to put our requirements here first and then moved accordingly.
I am putting my head in oracle problems from last 3 days, then i got an idea to put my doubts here.
Well now some of the things are cleared and some are on the way.

As you said creating users and tables , schemas should be the main goal.
happy to say that even my target is same but i have tried to create new users, modify the existing users from manager part.
in the manager menu it says done successfully but when i try those users in sqlplus it says logon denied.
One more strange after few logins for a particular user on sqlplus, its login details change automatically in the database and when i modify them as i was using. same thing happens---
manager says ok but when i try it says logon denied.

then i need to use other user.

one more thing, i have given all priveliges to DIP user but still when i create even a new table then it insufficient privileges.

A lot more still to write, but initially i want to solve them on my own.
well thanks buddy,

[chris webster]

Forget about using Oracle Enterprise Manager - it's too complicated and it may be pointing at the wrong database anyway e.g. if you have created a new database in addition to the default database.

Just use SQL Developer instead and watch this video on how to set up your user via SQL Developer with the right permissions.

[lalit khera]

chris webster wrote:Forget about using Oracle Enterprise Manager - it's too complicated and it may be pointing at the wrong database anyway e.g. if you have created a new database in addition to the default database.

Just use SQL Developer instead and watch this video on how to set up your user via SQL Developer with the right permissions.

yeah thanks chris

now i got to know about oracle.
As soon as i am working on it, may be i put some doubts related to connecting my oracle database with eclipse IDE in the near future.
Well actually i have my friend project with me but he uses access in that, but want to upgrade it to oracle.
Thats why i lot of effort on these oracle issues.
well thanks, i believe you would reply to my queries while i would be connecting my database with IDE.
byee