unable to attach to shared memory segment 2006-03-14 - By jorgecab@(protected)
Hi Martin, thanks for the advice, I am using SLES9 with kernel 2.6.5-7.244-smp I
know about the caps lock issue and tried the modification you sent me but still
getting the same error:
oracleuser@(protected):~> sqlplus
Enter user-name: oracle1
Enter password:
ERROR:
ORA-01034 (See ORA-01034.ora-code.com): ORACLE not available
ORA-27123 (See ORA-27123.ora-code.com): unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
oracleuser@(protected):~> env | grep ORACLE
ORACLE_SID=the_right_sid
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/product/9ir2
But still getting that error, any more ideas?
Thanks
Jorge
Quoting Martin Klier <martin.klier@(protected)>:
> Hi Jorge,
>
> do you use SLES9? Which kernel version do you use?
>
> Further try to set
>
> "vm.disable_cap_mlock = 1"
>
> in /etc/sysctl.conf and invoke the change with "sysctl -p".
>
> Am Dienstag 14 M?rz 2006 17:14 schrieb jorgecab@(protected):
> > Hi, I'm having a problem with my oracle installation in a x86_64
> > architecture. Whenever I try to log in with sqlplus with the system user
> > "oracle" and database admin "sys" I can do so perfectly but if I want to
> > use sqlplus with another system's user like for example "oracleuser" and a
> > user created in oracle I get:
> >
> > ORA-01034 (See ORA-01034.ora-code.com): ORACLE not available
> > ORA-27123 (See ORA-27123.ora-code.com): unable to attach to shared memory segment
> > Linux-x86_64 Error: 13: Permission denied
> >
> > I have in this user's environmental variables:
> > ORACLE_SID=name_of_my_database
> > ORACLE_HOME=/opt/oracle/product/9ir2
> > ORACLE_BASE=/opt/oracle
> >
> > Plus I have him associated to the "dba" group.
> >
> > Odd thing is that I can log in using enterprise manager console with this
> > user, I just can't log in using sqlplus. Can someone help me?
> >
> > Jorge
> >
> > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> > This message was sent using IMP, the Internet Messaging Program.
>
> --
> Mit freundlichen Gr??en
>
> i.A. Martin Klier
> Systemadministration / Datenbanken
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
> A.T.U Auto-Teile-Unger
> Handels GmbH & Co. KG
> Dr.-Kilian-Stra?e 4
> D-92637 Weiden i. d. OPf.
>
--
d-_-b \|/
0-0
---oOo-(_)-oOo---
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
This message was sent using IMP, the Internet Messaging Program.
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
