Thank you very much Werner and Martin, the key was in $ORACLE_HOME/bin/oracle permissions, I left it with "-rwsr-s--x" and it worked perfectly. I never changed this before in other oracle installations with SLES9 and x86 architecture, maybe the installation process for x86_64 is different... or the patchset...
Well anyways, thanks a lot!
Jorge
Quoting Werner Flamme <werner.flamme@(protected)>:
> -- --BEGIN PGP SIGNED MESSAGE-- -- > Hash: SHA1 > > Jorge, > > at SAP I find: > > - ---snip--- > Check to see whether the "oracle" file exists on $ORACLE_HOME/bin, has a > size other than 0 and has the "-rwsr-s--x" authorizations.The owner must be > ora<sid>. The group is dba. > > If the file is empty, you can create it again by relinking the software > [...]. > > You can assign authorizations as well as the owner/group as follows: > > chmod 6751 oracle > > chown ora<sid> oracle > > chgrp dba oracle > > You should also check the authorization of the $ORACLE_HOME/bin directory. > This should be at "drwxr-xr-x". > > Continue to ensure that the file system containing $ORACLE_HOME/bin > supports s-bit. The system must not be set to NOSUID. > > Restart the system after the Oracle adjustments.If an error such as > ORA-27121 (See ORA-27121.ora-code.com) continues to occur after you set the s-bit, it may be caused by > hanging shared memories or semaphores that are assigned to the user under > whose name the Oracle database was mistakenly started until now.You can > correct this situation using tools such as ipcs/ipcrm or by rebooting. > - ---pins--- > > Replace ora<sid> with the name of the system user under whose account > oracle was installed, and check the files. ;-) > > HTH > Werner > > jorgecab@(protected) schrieb am 14.03.2006 17:39: > > 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. > > > > > > > - -- > Werner Flamme, Abt. WKDV > UFZ Umweltforschungszentrum Leipzig-Halle GmbH, > Permoserstr. 15 - 04318 Leipzig > Tel.: (0341) 235-3921 - Fax (0341) 235-453921 > http://www.ufz.de - eMail: werner.flamme@(protected) > > > > > -- --BEGIN PGP SIGNATURE-- -- > Version: GnuPG v1.4.2 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQFEFvQFk33Krq8b42MRAqG6AJ93BsP0MDicCPc59R5prEaIqnZeQwCfYRcM > /wPmzqd/q+hEJcsmx3GiAF0= > =qM8f > -- --END PGP SIGNATURE-- -- > > -- > To unsubscribe, email: suse-oracle-unsubscribe@(protected) > For additional commands, email: suse-oracle-help@(protected) > Please see http://www.suse.com/oracle/ before posting > >
-- 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
