|
ORA-12154: TNS:could not resolve the connect identifier specified
|
|||
---|---|---|---|
#18+
поставил новый сервер. пытаюсь импортировать базу Windows Oracle Database 18c Express Edition imp 'system/manager@xyz' file=C:\SHARE\CPSDBBACKUP_08152019.DMP full=yes log=C:\SHARE\implog.txt Import: Release 18.0.0.0.0 - Production on Wed Aug 21 14:55:32 2019 Version 18.4.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. IMP-00058: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve the connect identifier specified IMP-00000: Import terminated unsuccessfully ----------------------------------- tnsping xe TNS Ping Utility for 64-bit Windows: Version 18.0.0.0.0 - Production on 21-AUG-2019 14:58:26 Copyright (c) 1997, 2018, Oracle. All rights reserved. Used parameter files: E:\Oracle\dbhomeXE\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.197.46)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE))) OK (0 msec) откуда копать? ... |
|||
:
Нравится:
Не нравится:
|
|||
21.08.2019, 22:17 |
|
ORA-12154: TNS:could not resolve the connect identifier specified
|
|||
---|---|---|---|
#18+
"lsnrctl status" посмотри на сервере ... |
|||
:
Нравится:
Не нравится:
|
|||
22.08.2019, 03:53 |
|
ORA-12154: TNS:could not resolve the connect identifier specified
|
|||
---|---|---|---|
#18+
dburtsev1imp 'system/manager@ xyz ' file=C:\SHARE\CPSDBBACKUP_08152019.DMP full=yes log=C:\SHARE\implog.txt tnsping xe TNS Ping Utility for 64-bit Windows: Version 18.0.0.0.0 - Production on 21-AUG-2019 14:58:26 Copyright (c) 1997, 2018, Oracle. All rights reserved. Used parameter files: E:\Oracle\dbhomeXE\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.197.46)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE ))) OK (0 msec) откуда копать? Посмотри на выделенное, ты, похоже, пытаешься импортировать в одну базу а пингуешь другую. ... |
|||
:
Нравится:
Не нравится:
|
|||
22.08.2019, 06:57 |
|
|
start [/forum/topic.php?fid=52&fpage=69&tid=1882166]: |
0ms |
get settings: |
9ms |
get forum list: |
13ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
30ms |
get topic data: |
12ms |
get forum data: |
3ms |
get page messages: |
46ms |
get tp. blocked users: |
2ms |
others: | 13ms |
total: | 136ms |
0 / 0 |