Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

confused about oracle user

732470Nov 5 2009 — edited Nov 9 2009
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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 7 2009
Added on Nov 5 2009
#access, #database-installation, #oracle, #user
10 comments
804 views