confused about oracle user

732470

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

Srini Chavali-Oracle

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

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

611948

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

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

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

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

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

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

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

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