小弟最近想在mac開一個oracle的 db環境來做專案的測試開發
由於對資料庫實在不熟...用chatGPT勉勉強強把DB裝起來了
但是對權限控管與主機服務器管理也是一知半解
我目前有一個SYSDBA角色,服務名為：ORCLCDB
然後我也創建了一個EIPUSER角色,服務名為：ORCLPDB1
我後來也才發現這兩者有些許不同..

後來要把資料用指令dump進來了

可以大概看一下我的指令
<choushaoyu@zhoushaoyudeMacBook-Air ~ % cd tmp
cd: no such file or directory: tmp
choushaoyu@zhoushaoyudeMacBook-Air ~ % cp /Users/choushaoyu/exp_file.dmp /tmp/dumpdir/
choushaoyu@zhoushaoyudeMacBook-Air ~ % sqlplus sys/x968025kuy@//localhost:1521/ORCLPDB1 as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jun 11 15:15:21 2024
Version 19.16.0.0.0

Copyright (c) 1982, 2020, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0

SQL> CREATE OR REPLACE DIRECTORY new_dump_dir AS '/tmp/dumpdir';

Directory created.

SQL> GRANT READ, WRITE ON DIRECTORY new_dump_dir TO EIPUSER;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
choushaoyu@zhoushaoyudeMacBook-Air ~ % sqlplus EIPUSER/EIPUSER@//localhost:1521/ORCLPDB1

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jun 11 15:15:40 2024
Version 19.16.0.0.0

Copyright (c) 1982, 2020, Oracle. All rights reserved.

Last Successful login time: Tue Jun 11 2024 15:12:11 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0

SQL> SELECT * FROM all_directories WHERE directory_name = 'NEW_DUMP_DIR';

OWNER

DIRECTORY_NAME

DIRECTORY_PATH

ORIGIN_CON_ID

SYS
NEW_DUMP_DIR
/tmp/dumpdir
3

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
choushaoyu@zhoushaoyudeMacBook-Air ~ % impdp EIPUSER/EIPUSER@//localhost:1521/ORCLPDB1 directory=new_dump_dir dumpfile=exp_file.dmp logfile=exp_file.log

Import: Release 19.0.0.0.0 - Production on Tue Jun 11 15:15:57 2024
Version 19.16.0.0.0

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

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation: nonexistent file or path [29434]

choushaoyu@zhoushaoyudeMacBook-Air ~ % />

我每次跑完
都一定會有
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation: nonexistent file or path [29434]

這三個錯誤...
GPT要我檢查的權限我也查了，但實在無法

請問有人遇到類似的問題嗎？