dbTalk Databases Forums  

oracle 10g installation - access not permitted?

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss oracle 10g installation - access not permitted? in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Charles T. Smith
 
Posts: n/a

Default oracle 10g installation - access not permitted? - 05-31-2007 , 11:12 AM






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?

Reply With Quote
  #2  
Old   
Brian Peasland
 
Posts: n/a

Default Re: oracle 10g installation - access not permitted? - 05-31-2007 , 11:46 AM






Charles T. Smith wrote:
Quote:
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?
Was your umask set to 022 when you installed the software? This is
described in the installation documentation.

HTH,
Brian



--
================================================== =================

Brian Peasland
dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com



Reply With Quote
  #3  
Old   
Sidhu
 
Posts: n/a

Default Re: oracle 10g installation - access not permitted? - 05-31-2007 , 11:48 AM



On May 31, 9:12 pm, "Charles T. Smith" <cts.priv... (AT) yahoo (DOT) com> wrote:
Quote:
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?
are you logged in using the same user with which you installed
oracle ? when you try to run sqlplus what does it say ? just give
execute permission and then try

Sidhu



Reply With Quote
  #4  
Old   
DA Morgan
 
Posts: n/a

Default Re: oracle 10g installation - access not permitted? - 05-31-2007 , 12:18 PM



Charles T. Smith wrote:
Quote:
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
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
  #5  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: oracle 10g installation - access not permitted? - 05-31-2007 , 12:18 PM



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Charles T. Smith wrote:
Quote:
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?
Make the user(s) member of the secondary install group; on
default installs, that is the same as the primary group for the
installation user. Defaults are oracle for installation user, oinstall
as single group, osoper and osdba when using two groups.
In the latter case, your users should be member of osoper group

check it, using the id command

- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGXwNxLw8L4IAs830RAgdrAJ40sWrBLDUueDoXBwbD1d L9kNwFbwCfX6Ao
FjEJ/B5f4OhK4j4nGbI4Te0=
=c4Ky
-----END PGP SIGNATURE-----


Reply With Quote
  #6  
Old   
Charles T. Smith
 
Posts: n/a

Default Re: oracle 10g installation - access not permitted? - 05-31-2007 , 12:35 PM



On Thu, 31 May 2007 10:18:33 -0700, DA Morgan wrote:

Quote:
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.




Reply With Quote
  #7  
Old   
Charles T. Smith
 
Posts: n/a

Default Re: oracle 10g installation - access not permitted? - 05-31-2007 , 12:37 PM



On Thu, 31 May 2007 09:48:48 -0700, Sidhu wrote:

! drwxrwx---

Reply With Quote
  #8  
Old   
Charles T. Smith
 
Posts: n/a

Default Re: oracle 10g installation - access not permitted? - 05-31-2007 , 12:39 PM



On Thu, 31 May 2007 19:18:41 +0200, Frank van Bortel wrote:

Quote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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?

Make the user(s) member of the secondary install group; on default
installs, that is the same as the primary group for the installation user.
Defaults are oracle for installation user, oinstall as single group,
osoper and osdba when using two groups. In the latter case, your users
should be member of osoper group

Right, I could put everybody in oinstall. But somehow that doesn't seem
right to me.



Reply With Quote
  #9  
Old   
Charles T. Smith
 
Posts: n/a

Default Re: oracle 10g installation - access not permitted? - 05-31-2007 , 12:40 PM



On Thu, 31 May 2007 11:46:35 -0500, Brian Peasland wrote:

Quote:
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?

Was your umask set to 022 when you installed the software? This is
described in the installation documentation.

yes.


Reply With Quote
  #10  
Old   
Charles T. Smith
 
Posts: n/a

Default Re: oracle 10g installation - access not permitted? - 05-31-2007 , 12:48 PM



On Thu, 31 May 2007 19:35:10 +0200, Charles T. Smith wrote:

Quote:
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 ...



Reply With Quote
Reply




Thread Tools
Display Modes

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

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



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.