ORACLE数据库报错ORA-01034

最新推荐文章于 2025-07-02 19:02:05 发布

原创最新推荐文章于 2025-07-02 19:02:05 发布 · 8.9k 阅读

1 ·

CC 4.0 BY-SA版权

本文记录了一次使用expdp导出Oracle数据库时遇到的UDE-28009和ORA-28009等错误，并分享了如何通过正确指定用户实例名sys/sys@p012bandassysdba来解决问题的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在使用expdp 导出数据表时报错：

sqlplus sys/sys as sysdba

create directory exp_dir as '/home/oracle/backup';
grant read,write on directory exp_dir to public;

[oracle@oracle-01 ~]$ expdp sys/sys@p012band tables=fnsonlp.facd file=limit_facitity_20180425.dmp directory=exp_dir logfile=limit_20180425.log

Export: Release 11.2.0.4.0 - Production on Wed Apr 25 20:42:14 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

UDE-28009: operation generated ORACLE error 28009
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

Username: sys/sys as sysdba

UDE-01034: operation generated ORACLE error 1034
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory

UDE-00003: all allowable logon attempts failed

问题找到了，输入用户时没有指定实例名

sys/sys@p012band as sysdba