Hello,
as i said all the variables where set correct, that wasnt the problem,
but thanks to all who pointed in that direction.
The reason for the error was a setuid bit on an oracle binary (Thanks to
Udo de Boer and David J. DeWolf).
I include a find for those binary on a server which is working:
# find . -perm -6000 -exec ls -l {} \;
-rwsr-s--x 1 oracle dba 28049408 Jun 25 1999
./app/oracle/product/8.0.5/bin/oracle
-rwsr-s--x 1 oracle dba 27860992 Jun 25 1999
./app/oracle/product/8.0.5/bin/oracleO
-rwsr-s--x 1 root dba 6488064 Jun 25 1999
./app/oracle/product/8.0.5/bin/dbsnmp
#
These binary should have setuid. I changed that on the server and the
problem was
solved,
Thanks
Samier.
---------------------- Weitergeleitet von Samier Kesou/Extern/11/BfA-Berlin
am 14.11.2001 09:26 ---------------------------
Samier.Kesou_at_bfa-berlin.de_at_ornl.gov on 13.11.2001 15:36:50
Gesendet von: tru64-unix-managers-owner_at_ornl.gov
An: tru64-unix-managers_at_ornl.gov
Kopie:
Thema: UPDATE:sqlplus login
Hello,
sorry for not mentioning:
All the Oracle variables have been set and checked.
Thanks.
---------------------- Weitergeleitet von Samier Kesou/Extern/11/BfA-Berlin
am 13.11.2001 15:34 ---------------------------
Samier.Kesou_at_bfa-berlin.de_at_ornl.gov on 13.11.2001 14:41:31
Gesendet von: tru64-unix-managers-owner_at_ornl.gov
An: tru64-unix-managers_at_ornl.gov
Kopie:
Thema: sqlplus login
Hello,
this is surly off topic but i'll try it anyway.
Im having problems login into a Oracle server. For that im using sqlplus.
When i start with uid oracle everything works fine.
#sqlplus uid/passwd
SQL*Plus: Release 8.0.5.0.0 - Production on Di Nov 13 14:33:21 2001
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Connected to:
Oracle8 Enterprise Edition Release 8.0.5.1.0 - Production
PL/SQL Release 8.0.5.1.0 - Production
SQL>
But even as root when i try to do the same i get
#sqlplus uid/passwd
SQL*Plus: Release 8.0.5.0.0 - Production on Di Nov 13 14:32:48 2001
(c) Copyright 1998 Oracle Corporation. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
First i thought some changes to the system disk brought about this error.
I copied the system disk from a working server but still the same error
occures.
i even did a truss on the process and compared it with a output from a
working server
but i couldnt find any hints to what the problem is.
OS DUV40E PK1
SERVER: Alpha 1200
ORADB: 8.0.5
Has anyone experinced similar problems?
Thanks in advance
Received on Wed Nov 14 2001 - 08:34:52 NZDT