Re: oracle 10g installation - access not permitted?

From: Charles T. Smith <cts.private_at_yahoo.com>
Date: Thu, 31 May 2007 22:55:30 +0200
Message-ID: <pan.2007.05.31.20.55.29.911422_at_yahoo.com>


On Thu, 31 May 2007 22:41:29 +0200, Charles T. Smith wrote:

> On Thu, 31 May 2007 20:40:41 +0200, Charles T. Smith wrote:
>

>> On Thu, 31 May 2007 11:34:30 -0700, DA Morgan wrote:
>> 
>>> Charles T. Smith wrote:
>>>> On Thu, 31 May 2007 19:35:10 +0200, Charles T. Smith wrote:
>>>> 
>>>>> On Thu, 31 May 2007 10:18:33 -0700, DA Morgan wrote:
>>>>>
>>>>>> Charles T. Smith wrote:
>>>>>>> I have installed oracle 10g on solaris 10.  In order to get
>>>>>>> started, I want to run sqlplus.  That's in
>>>>>>> /export/home/oracle/product/10.2.0/Db_1/bin - but it turns out that
>>>>>>> all of product, 10.2.0, Db_1 have permissions disabled for users
>>>>>>> (e.g. drwxrwx---, with group oinstall).
>>>>>>>
>>>>>>> Did I not finish the installation properly?  Or am I supposed to
>>>>>>> enable the permissions manually?  Does anybody know how to use
>>>>>>> sqlplus?
>>>>>> No one knows ho to use sqlplus. <g>
>>>>>>
>>>>>> My guess is that you didn't read and follow the installation docs.
>>>>>> http://docs.oracle.com
>>>>>
>>>>> Hmmm.  I'm not sure what that serves.  There's no mention of sqlplus
>>>>> on that page.
>>>>>
>>>>> Presumably there's some other way to invoke the command line sqlplus
>>>>> than simply from one's path - that's what this posting seems to want
>>>>> to taunt with.  Or, maybe the poster didn't really read the OP and is
>>>>> just gushing forth.
>>>> 
>>>> 
>>>> Oh, but I'm not interested in using sqlplus via the browser, if that's
>>>> what you mean.  But then, I'm guessing.
>>>> 
>>>> 
>>>> I guess I'll start at A ...
>>> 
>>> Not what I meant.
>>> 
>>> Starting over and carefully following the docs is the recipe for
>>> success.
>> 
>> 
>> Thank you.  I'll bear that in mind.

>
>
> Here's one approach ...
>
> http://www.orablogs.com/sergio/archives/oracle_database_10g/index.html
>
>
> Change Groups and Permissions for Directories
>
> Change the groups and permissions for the directories you just created by
> executing these commands:
>
> # chown -R oracle:oinstall /Volumes/u01/app/oracle # chown -R
> oracle:oinstall /Volumes/u02/oradata
>
> then:
>
> # chmod -R 775 /Volumes/u01/app/oracle # chmod -R 775 /Volumes/u02/oradata
>
>
> Not exactly what I had in mind, though ...

Okay, I found it - it clearly applies to solaris as well:

http://www.dbspecialists.com/presentations/oracle10glinux.html

Some distributions of Oracle Database 10g release 2 install with file permissions that are excessively strict for most applications. Setting file permissions as restrictively as possible makes the system more secure, but this makes no sense if permissions are so limiting that the system cannot be used properly. A patch is available to loosen the permissions to a level that is still considered secure, yet allows users other than oracle to connect to the database directly without having to use Oracle's network listener. To determine if you need this patch, check the permissions on the $ORACLE_HOME directory (the directory you specified as the path on the Specify Home Details screen of the Oracle software installation). If the permissions are 755, then you do not need the patch. If the permissions are 750, then you will need the patch if you want Linux users logged into the database server to be able to access the database without having to connect through Oracle's network listener.

Which, in short, means that I need to manually fix it. Received on Thu May 31 2007 - 22:55:30 CEST

Original text of this message