오라클 유저로 접속시에 정상접속.
다른 유저로 접속시에 ORA-1034 발생.
오라클 환경변수 이상없음.
리모트로 접속시 정상접속(scott/tiger@tnsname)
$ORACLE_HOME/bin/oracle의 파일퍼미션 변경으로 해결.
ls -l oracle
-rwxr-x--x 1 oracle dba 20724480 2006년 7월 7일 oracle
chmod 6751 oracle
ls -l oracle
-rwsr-s--x 1 oracle dba 20724480 2006년 7월 7일 oracle
--The problem is when you try to connect to the oracle locally by using another user other than
--oracle (database owner) we get "ORA-01034" and "ORA-27123" errors. When you use "TWO_TASK"
--environment variable, it is OK, since it is going through network I mean over the listener.
--But locally we are not able to connect to the database whithout using "TWO_TASK".
--There may be others who have seen the same error, so I am writing the solution in my case here.
user1@host1:/data3/oracle/user1 > echo $TWO_TASK
user1@host1:/data3/oracle/user1 > sqlplus db_user1
SQL*Plus: Release 9.2.0.4.0 - Production on Wed Apr 18 23:37:00 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
IBM AIX RISC System/6000 Error: 13: Permission denied
Enter user-name: ^C
--ORACLE_SID and ORACLE_HOME are checked and they are what they should be for this database
--so what is the problem then ?
-------------------------
Solution :
--After searching for the solution for some time in Internet,
--I finally found the following a solution that solved my problem.
oracle@host1:/data3/oracle > cd $ORACLE_HOME/bin
oracle@host1:/data3/oracle/bin > ls -l oracle
-rwxr-xrwx 1 oracle dba 74053740 Sep 04 2003 oracle
--When we look at the file permissions of "oracle" executable it looks strange
--because it normally should be like "-rwsr-s--x", so we are going to make it so
다른 유저로 접속시에 ORA-1034 발생.
오라클 환경변수 이상없음.
리모트로 접속시 정상접속(scott/tiger@tnsname)
$ORACLE_HOME/bin/oracle의 파일퍼미션 변경으로 해결.
ls -l oracle
-rwxr-x--x 1 oracle dba 20724480 2006년 7월 7일 oracle
chmod 6751 oracle
ls -l oracle
-rwsr-s--x 1 oracle dba 20724480 2006년 7월 7일 oracle
--The problem is when you try to connect to the oracle locally by using another user other than
--oracle (database owner) we get "ORA-01034" and "ORA-27123" errors. When you use "TWO_TASK"
--environment variable, it is OK, since it is going through network I mean over the listener.
--But locally we are not able to connect to the database whithout using "TWO_TASK".
--There may be others who have seen the same error, so I am writing the solution in my case here.
user1@host1:/data3/oracle/user1 > echo $TWO_TASK
user1@host1:/data3/oracle/user1 > sqlplus db_user1
SQL*Plus: Release 9.2.0.4.0 - Production on Wed Apr 18 23:37:00 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
IBM AIX RISC System/6000 Error: 13: Permission denied
Enter user-name: ^C
--ORACLE_SID and ORACLE_HOME are checked and they are what they should be for this database
--so what is the problem then ?
-------------------------
Solution :
--After searching for the solution for some time in Internet,
--I finally found the following a solution that solved my problem.
oracle@host1:/data3/oracle > cd $ORACLE_HOME/bin
oracle@host1:/data3/oracle/bin > ls -l oracle
-rwxr-xrwx 1 oracle dba 74053740 Sep 04 2003 oracle
--When we look at the file permissions of "oracle" executable it looks strange
--because it normally should be like "-rwsr-s--x", so we are going to make it so