Dumpファイルを元にインポートをしたいのですが、
/u01/app/oracle/product/19c/dbhome_1/bin/impdp portal/oracle@ORCLCDB remap_schema=portal:test remap_tablespace=users:users directory=suzukidir dumpfile=USER_INFO.dmp logfile=USER_INFO.log table_exists_action=replace
このようなエラーになります
Import: Release 19.0.0.0.0 - Production on Tue Jun 9 15:33:04 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. UDI-12514: operation generated ORACLE error 12514 ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
tnsnames.ora
# tnsnames.ora Network Configuration File: /opt/oracle/product/19c/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ORCLCDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCLCDB) ) ) LISTENER_ORCLCDB = (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1522)) ORCLPDB1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCLPDB1) ) )
listener.ora
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1522)) ) ) DEDICATED_THROUGH_BROKER_LISTENER=ON DIAG_ADR_ENABLED = off
リスナーは立ち上がっています
lsnrctl start
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 09-JUN-2020 15:40:03
Copyright (c) 1991, 2019, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
回答2件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2020/06/10 07:54