1200字范文,内容丰富有趣,写作的好帮手!
1200字范文 > ORACLE数据库报错ORA-01034

ORACLE数据库报错ORA-01034

时间:2020-12-02 16:19:15

相关推荐

ORACLE数据库报错ORA-01034

在使用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_0425.dmp directory=exp_dir logfile=limit_0425.log

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

Copyright (c) 1982, , 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

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。