Re: Doubt regarding granting OPS$ user ids.......

nakkala_at_cs.tamu.edu (Venkatesh Nakkala) writes:

> Howdy,
>

>	I have been using ORACLE using only one account (the oracle
>	account used for installing) till now.Now when trying to
>	assign users using the ops$user_name, I am getting the
>	following error (on doing sqlplus from the ops user's account)..

> The database has been opened in shared mode and the shared
> memory segment has "rw" permissions only for oracle.
> Also I've set the env. variables ORACLE_HOME and ORACLE_SID and other
> variables
> appropriately.
 

> Thanks in advance,
 

> Venkatesh Nakkala
 

>--
>-----------------------------------------------------------------------------
>		     Venkatesh  Nakkala    nakkala_at_neuron.tamu.edu 


> Off : (409)845-5481                       Res : (409)268-7404


> Dept. Of Comp Sci.,Texas A & M Univ.      Fax : (409)847-8578 

Check to make sure the oracle binary is owned by 'oracle' and set uid (chmod 4751). Otherwise, no one but the owner, 'oracle', can access the database.

---
  /_ _   /		sequent computer system, inc.	+-----+
 / / /  /__/ __		15450 sw koll parkway		|   # |
/ / /  / \__(_/_/_/	beaverton, or  97006-6063	|     |
mary kay petersen/	mkay_at_sequent.com 		+-----+
(503)578-5817 __/