hunter@HP:/home/hunter #exp userid=system/yxyup owner=hunter file='/ehirearch/hunter/
exp_test/hunter.dmp' log='/ehirearch/hunter/exp_test/hunter.log' direct=y
Export: Release 10.2.0.3.0 - Production on Mon Oct 22 16:04:23 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
EXP-00056: ORACLE error 1034 encountered
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
HPUX-ia64 Error: 22: Invalid argument
Additional information: 1
Additional information: 884748
EXP-00005: all allowable logon attempts failed
EXP-00000: Export terminated unsuccessfully
hunter@HP:/home/hunter #ps -ef | grep ora_
oracle 19161 1 0 09:50:17 ? 0:00 ora_d000_yxyup
oracle 19169 1 0 09:50:22 ? 0:07 ora_arc1_yxyup
oracle 19133 1 0 09:50:16 ? 0:03 ora_pmon_yxyup
oracle 19135 1 0 09:50:16 ? 0:00 ora_psp0_yxyup
oracle 19149 1 0 09:50:17 ? 0:08 ora_ckpt_yxyup
oracle 19173 1 0 09:50:23 ? 0:00 ora_qmnc_yxyup
hunter 27128 26727 0 16:05:31 pts/1 0:00 grep ora_
oracle 19159 1 0 09:50:17 ? 0:10 ora_mmnl_yxyup
oracle 19157 1 0 09:50:17 ? 0:01 ora_mmon_yxyup
oracle 19185 1 0 09:50:33 ? 0:00 ora_q001_yxyup
oracle 19183 1 0 09:50:33 ? 0:00 ora_q000_yxyup
oracle 19167 1 0 09:50:22 ? 0:07 ora_arc0_yxyup
oracle 19139 1 0 09:50:16 ? 0:01 ora_dbw0_yxyup
oracle 19137 1 0 09:50:16 ? 0:07 ora_mman_yxyup
oracle 19145 1 0 09:50:16 ? 0:00 ora_dbw3_yxyup
oracle 19155 1 0 09:50:17 ? 0:11 ora_cjq0_yxyup
oracle 19143 1 0 09:50:16 ? 0:40 ora_dbw2_yxyup
oracle 19153 1 0 09:50:17 ? 0:00 ora_reco_yxyup
oracle 19141 1 0 09:50:16 ? 0:00 ora_dbw1_yxyup
oracle 19163 1 0 09:50:17 ? 0:00 ora_s000_yxyup
oracle 19151 1 0 09:50:17 ? 0:01 ora_smon_yxyup
oracle 19147 1 0 09:50:17 ? 0:26 ora_lgwr_yxyup
hunter@HP:/home/hunter #sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on Mon Oct 22 16:44:38 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> conn system/hperh
ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
HPUX-ia64 Error: 22: Invalid argument
Additional information: 1
Additional information: 884748
oracle@HP:/home/oracle #sqlplus system/yxyup
SQL*Plus: Release 10.2.0.3.0 - Production on Mon Oct 22 17:01:43 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning and Data Mining options
SQL>
检查ORACLE_SID,ORACLE_HOME,LD_LIBRARY_PATH等环境变量都是正确的。都和oracle用户一样。
为什么只有oracle用户可以,其他用户不能登录
解决方法
oracle@HP:/u01/oracle/admin/yxyup/bdump #cd /u01/oracle/product/10.2.0.3/bin
oracle@HP:/u01/oracle/product/10.2.0.3/bin #chmod +s oracle
oracle@HP:/u01/oracle/product/10.2.0.3/bin #ls -l oracle
-rwsr-s--- 1 oracle dba 262570632 Oct 15 12: