Forum Stats

  • 3,874,667 Users
  • 2,266,763 Discussions
  • 7,911,935 Comments

Discussions

confused about oracle user

732470
732470 Member Posts: 4
edited Nov 9, 2009 1:32PM in Database Installation
Dear all,

I have a question about oracle 10g
I have installed oracle 10g for the first time on a fedora machine following instructions given in oracle site. So during the installation process i created some groups and a user named oracle as follows :
groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba oracle
passwd oracle


once the installation is complete, i ran sqlplus then i enter the oracle as username and its password.
however i failed to logon to database.

my questions now are why i had to create this user during installation and why it cannot access to the database !!!! i am confused about the utility of this user and the groups created during installation.

more importantly how can i access this oracle database (what is the username and password) : i want to have a normal access and an admin access. HOW TO GAIN THESE TWO ACCESSES ? if you could give me the commands for these accesses i will be grateful

I am looking forward for your valuable help and thanks very much i will be grateful for any help accessing this database as a normal and admin user

Edited by: user12092668 on Nov 5, 2009 3:03 PM
Tagged:

Answers

  • Srini Chavali-Oracle
    Srini Chavali-Oracle Member Posts: 29,596 Employee
    Welcome to the forums !

    >
    I have installed oracle 10g ...
    >

    Which 10g ? 10gR1 ? 10gR2 ? What is the full OS ?

    >
    however i failed to logon to database.
    >

    Pl post complete error messages

    HTH
    Srini
  • Zeeshan BaiG
    Zeeshan BaiG Member Posts: 2,094
    user oracle and groups are Operating system user and groups not the database user.......


    Use Sys or System or Scott with passwords your specified during installation

    Plz mark as helpful or correct

    Cheers,
    Baig
    Zeeshan BaiG
  • 611948
    611948 Member Posts: 123
    why don't you post the error messages? it might be issue with your environment settings, .bash_profile etc.
    do su - oracle once and trying logging into oracle.

    HTH,
    Thanks
  • 732470
    732470 Member Posts: 4
    shavali,

    i have installed 10201_database_linux32.zip so iguess its 10g2

    when i ran sqlplus oracle/[email protected]
    i got username/password incorrect logon denied

    wheni just ran sqlplus oracle/passwd
    i got something more severe like
    ORA-... : ORACLE not available
    and it says something about memory and shared realms

    the OS is fedora 7 i386
  • 732470
    732470 Member Posts: 4
    edited Nov 6, 2009 3:57AM
    Baig,

    thanks,

    in deed i can log in to my computer with the created user oracle but not to the database orcl
    then should delete this oracle user ? it can be useful only if i can consider it as a guest account that users can use to connect to database which is not the case here as you said.

    now if i just do sqlplus / as sysdba
    it succeded !

    So this is the user SYS you spoke about, isn't it ?

    how can i connect to as user SYSTEM ?

    it is bothering that these users have no passwords, this means anyone can connect to orcl using them. is it possible to change that and how ?

    knowing that i have to grant access to the database to some users, what is the best way to proceed ? should i create some oracle database account for them ? may these accounts be the same as the OS accounts. Any available SQL command for that is very welcome.

    Edited by: user12092668 on Nov 6, 2009 12:55 AM
  • 611948
    611948 Member Posts: 123
    when i ran sqlplus oracle/[email protected]
    i got username/password incorrect logon denied

    Do you have "oracle" user in your database?

    wheni just ran sqlplus oracle/passwd
    i got something more severe like
    ORA-... : ORACLE not available
    and it says something about memory and shared realms

    Is your oracle up and running?
  • 732470
    732470 Member Posts: 4
    gtcol,

    well it is sure that i can connect to my computer with oracle user but it is imposible to connect to database. it seems that this user is not really a database user. that's why i think i must delete it, it is useless. why bothering creating it during installation at the first time, strange.

    well i will search how to create a database user with sqlplus.


    oracle is runing since sqlplus / as sysdba succeeded
  • 611948
    611948 Member Posts: 123
    pleaseeeee don't drop this user 'oracle', oracle uses this user for all transactions in OS, seems like you're new to oracle, please go to through oracle documentation first .
  • Zeeshan BaiG
    Zeeshan BaiG Member Posts: 2,094
    1) Dont delete the oracle user this user is Owner of Oracle installation/inventory if u dont delete then Oracle will not work ........

    2) connect / as sysdba is working because Oracle Operating system authentication is enabled thats why u r able to connect with / as

    3) if u want to connect from system or any other user in SQLPLUS then try
    # sqlplus  system/passwod
    4) i dont understand your basic requirement i guess ur server is accessable to lot of people........ best way is create seperate users in Oracle database with
      create user ABC identified by password;
      grant connect, resource to abc;
    5) install SQL Developer or Oracle client installation on client side to access sqlplus or worksheet with Oracle accounts without worrying about 'oracle' operating system user.


    Regards,
    Baig


    Again mark it helpful if it is ;)
  • 733044
    733044 Member Posts: 1
    user12092668 ,

    once u are able to login thru /as sysdba. you can alter the password of by user 'system' by following query

    alter user system identified by password.

    Try to connect with system user with new password. you shuold be able to connect to it.


    Himanshu
This discussion has been closed.