[rhn-users] Need help with access of DB problem

[Ray Stell]

On Fri, Apr 07, 2006 at 08:31:36AM -0600, Howard, Chris wrote:
>  
> I think hat's a problem with oracle environment variables.
> You need to have ORACLE_HOME and ORACLE_SID set
> in the environment of anyone who is going to use SQL*Plus.


Or TWO_TASK, teach a man to fish...

http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96580/connect.htm#430042

On most operating systems, you can define a default connect identifier. This way, a connect identifier does not need to be specified in the connect string. To define a default connect identifier, use the TWO_TASK environment variable on UNIX platforms or the LOCAL environment variable or registry entry on Windows NT.







> -----Original Message-----
> From: rhn-users-bounces at redhat.com [mailto:rhn-users-bounces at redhat.com]On Behalf Of James Oliver
> Sent: Friday, April 07, 2006 7:48 AM
> To: rhn-users at redhat.com
> Subject: [rhn-users] Need help with access of DB problem
> 
> 
> Not sure if we have an Oracle problem or an O/S problem but would appreciate any help that can be offered.
> We have installed Oracle 9.2.0.6 on a Red Hat Linux 3.2 32-bit O/S.
> We can only access DB with SQL*plus that is started by Oracle process owner.
> Once Oracle is started, the user that started the database can access the database using SQL*plus.
> Any other user with the same privileges cannot get in.
> We get:
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27123: unable to attach to shared memory segment
> Linux Error:  13:  Permission denied
> 
> We have beat ourselves up for two days and are no further along.
> All help is much appreciated.
> 

> _______________________________________________
> rhn-users mailing list
> rhn-users at redhat.com
> https://www.redhat.com/mailman/listinfo/rhn-users

--