aspose file tools*
The moose likes Oracle/OAS and the fly likes login details for SYSTEM account in oracle 11g Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "login details for SYSTEM account in oracle 11g" Watch "login details for SYSTEM account in oracle 11g" New topic
Author

login details for SYSTEM account in oracle 11g

lalit khera
Ranch Hand

Joined: Jun 06, 2012
Posts: 36
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



[Thumbnail for loginscreen.PNG]


[Thumbnail for loginassys.PNG]


[Thumbnail for first.PNG]

chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1845
    
  16

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.


    No more Blub for me, thank you, Vicar.
    lalit khera
    Ranch Hand

    Joined: Jun 06, 2012
    Posts: 36
    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
    Bartender

    Joined: Mar 01, 2009
    Posts: 1845
        
      16

    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
    Ranch Hand

    Joined: Jun 06, 2012
    Posts: 36
    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
    Bartender

    Joined: Mar 01, 2009
    Posts: 1845
        
      16

    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
    Ranch Hand

    Joined: Jun 06, 2012
    Posts: 36
    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
     
    Don't get me started about those stupid light bulbs.
     
    subject: login details for SYSTEM account in oracle 11g