confused about oracle user
732470Nov 5 2009 — edited Nov 9 2009Dear 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