使用exp 账号/密码@192.168.xx.xx:1521 file="/usr/local/db/xydb.sql" full = y;导出数据库时出现以下错误
EXP-00056: ORACLE error 12504 encountered
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
EXP-00000: Export terminated unsuccessfully
其实是因为没有添加数据库名字
:exp 账号/密码@192.168.xx.xx:1521/数据库名称 file="/usr/local/db/xydb.sql" full = y;
这样就可以成功导出了