oracle@prd:/home/oracle/impdir$sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 21 00:14:52 2022

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

SQL> conn myuser/abc123456   

ERROR:

ORA-00942: table or view does not exist

Error accessing PRODUCT_USER_PROFILE

Warning: Product user profile information not loaded!

You may need to run PUPBLD.SQL as SYSTEM

//提示错误,这种提示有的话，你导入，导出也会发生错误。 impdp myuser/abc123456 ......... 

解决方法： 需要使用system用户登陆,并执行pupbld.sql脚本，不能用sysdba。
每个人安装目录不同，可能pupbld.sql位置不确定，你可以locate pupbld.sql 查找一下他的位置。

[oracle@prd:/home/oracle/impdir$sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 21 00:14:52 2022

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

SQL> conn system/abc123456
Connected.

SQL>@/u01/oracle/product/11.2.0/sqlplus/admin/pupbld.sql
.....
.....
//执行过程省略，执行完之后你再重新登录

oracle@prd:/home/oracle/impdir$sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 21 00:14:52 2022

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

SQL> conn myuser/abc123456   
Connected. //就会ok

oracle@prd:/home/oracle/impdir$sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 21 00:14:52 2022

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

SQL> conn sh3/ab123@fp

Connected.
//这里fp是servicename 

SQL> conn sh3/abc123@fp3  //我故意把fp写错，注意fp就是在tnsnames.ora里面设置的
  ERROR:
  ORA-12154: TNS:could not resolve the connect identifier specified

Warning: You are no longer connected to ORACLE.

oracle@prd:/home/oracle/impdir$sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 21 00:14:52 2022

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

SQL> conn shfpfpmai/Shfpbi12@fpmai

Connected.

SQL> conn sh3/abc123@fpmai2

ERROR:

ORA-12154: TNS:could not resolve the connect identifier specified

Warning: You are no longer connected to ORACLE.

 expdp sh3/abc123  dumpfile=SH3.dmp directory=EXPDIR logfile=sh3export.log

 impdp sh3/abc123  dumpfile=SH3.dmp directory=IMPDIR logfile=sh3import.log