Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Oracle 10g connection problems
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Unsupported Software
View previous topic :: View next topic  
Author Message
MikeDougherty
n00b
n00b


Joined: 19 Nov 2005
Posts: 22

PostPosted: Sat May 13, 2006 4:56 pm    Post subject: Oracle 10g connection problems Reply with quote

Using the Oracle HOWTO on the wiki I was able to get Oracle 10g up and running OK. However, when I try to connect through sqlplus as an OS user other than Oracle I get the following error:

Code:


SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 13 09:49:09 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux Error: 13: Permission denied


Enter user-name:


I checked the permissions on all the directories and files I thought could be causing the problem, but nothing seems to be working. Any ideas on how to get this fixed?

Thanks
Back to top
View user's profile Send private message
MikeDougherty
n00b
n00b


Joined: 19 Nov 2005
Posts: 22

PostPosted: Sat May 13, 2006 5:37 pm    Post subject: Reply with quote

Interesting. If I start the server manually instead of with the dbstart script everything seems to work fine.
Back to top
View user's profile Send private message
MikeDougherty
n00b
n00b


Joined: 19 Nov 2005
Posts: 22

PostPosted: Sat May 13, 2006 7:12 pm    Post subject: Reply with quote

Actually, that wasn't it. I was starting the database server as the same user which I was attempting to connect as.

But, I did find some info on the SuSE mailing list.

http://lists.suse.com/archive/suse-oracle/2006-Mar/0089.html

Quote:

Check to see whether the "oracle" file exists on $ORACLE_HOME/bin, has a
size other than 0 and has the "-rwsr-s--x" authorizations.The owner must be
ora<sid>. The group is dba.

If the file is empty, you can create it again by relinking the software [...].

You can assign authorizations as well as the owner/group as follows:

chmod 6751 oracle


Did the trick. Now I can start the server as oracle and connect (via sqlplus and Tora) as any other OS user.

Not sure if anyone else has run into this, but thought I was post just in case.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Unsupported Software All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum