LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
Search this Thread
Old 09-25-2013, 03:01 AM   #1
aashish88k
LQ Newbie
 
Registered: Sep 2013
Posts: 1

Rep: Reputation: Disabled
user created is unable to access oracle database


I have created a user 'uca' with the below command,
useradd -m -d /home/uca -s /bin/bash uca

Now the problem is this user 'uca' is not able to access database. is ther any special group of users which can access the database.?
please help
 
Old 09-25-2013, 09:26 AM   #2
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 14,566

Rep: Reputation: 2557Reputation: 2557Reputation: 2557Reputation: 2557Reputation: 2557Reputation: 2557Reputation: 2557Reputation: 2557Reputation: 2557Reputation: 2557Reputation: 2557
Quote:
Originally Posted by aashish88k View Post
I have created a user 'uca' with the below command,
useradd -m -d /home/uca -s /bin/bash uca

Now the problem is this user 'uca' is not able to access database. is ther any special group of users which can access the database.?
please help
Since you don't tell us what version/distro of Linux, version of Oracle, or tell us how you're trying to access the database, or even what message(s) you're getting, there's not much we can tell you. Have you contacted your DBA's at your company to ask them, or checked the Oracle website? Contacted Oracle support??

Without details, we can't help.
 
Old 09-25-2013, 01:08 PM   #3
SAbhi
Member
 
Registered: Aug 2009
Location: Bangaluru, India
Distribution: CentOS 6.5, SuSE SLED/ SLES 10.2 SP2 /11.2, Fedora 11/16
Posts: 516

Rep: Reputation: 58
Are you trying to access it from oracle console ?
i dont know much about oracle but when it has its own admin user and privilages for them, you may need to make another oracle user and "GRANT [permissiosn] on *.* to user@domain " (something like that i remember to use while doing mysql configuration along back) to grant it necessary privilages in order to have it able to access the database for you.

There can be other ways too, but as said in the above post we shld have some more info on what distro/version you are using... and what you are seeing when you try accessing the adatabse along with how you are trying to do it..

Last edited by SAbhi; 09-25-2013 at 01:10 PM.
 
Old 09-25-2013, 04:22 PM   #4
carlosinfl
Senior Member
 
Registered: May 2004
Location: Orlando, FL
Distribution: Debian
Posts: 2,896

Rep: Reputation: 73
Just because you have a Linux user doesn't mean that user can just drop into the Oracle database and start editing data. You also have to create him in the database software as well. Either using OEM or SQL*Plus.

http://docs.oracle.com/cd/B28359_01/...ments_8003.htm
Post the logs from Oracle ... should be /u01/oracle/apps/oracle/$version/...

Did you grant the user a password after you created him? You show your useradd statement however you never enable a password for him. Please explain what version of Linux, release version, kernel, Oracle 11.2.x???

Give us something to help you please...

Each Oracle user must have specific roles granted to him! Each Oracle user MUST HAVE 'connect' ROLE and the 'CREATE SESSION' priv to use their table space assigned to them. You can use OEM (Oracle Ent. Manager) if you can't do it in SQL*Plus.

Last edited by carlosinfl; 09-25-2013 at 04:29 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access database (oracle) from an ldap Felipe Linux - Server 1 08-03-2012 06:54 AM
DBI Connect Failed:Access denied for user ''@'localhost' to database <database> error kaplan71 Linux - Software 3 06-05-2009 12:39 PM
unable to stop oracle database services selvkaumarmvs Linux - Newbie 1 05-23-2009 03:25 AM
Windows Oracle database access from Linux edsalvador Linux - Networking 1 03-16-2008 11:54 AM
How to access database created with MS Access on Windows using PHP on Linux Server anjani.78 Linux - Software 1 12-21-2005 06:07 PM


All times are GMT -5. The time now is 04:38 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration