ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-27123: unable to attach to shared memory segme

ORA-27123: unable to attach to shared memory segme

原创 Linux操作系统 作者:yxyup 时间:2008-04-20 11:53:28 0 删除 编辑
hunter@HP:/home/hunter #exp userid=system/yxyup wner=hunter file='/ehirearch/hunter/exp_test/hunter.dmp' log='/ehirearch/hunter/exp_test/hunter.log' direct=y  recordlength=65535 feedback=10000 statistics=none compress=N
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:39 oracle

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/7364032/viewspace-245928/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-06

  • 博文量
    163
  • 访问量
    1361027