Импорт в Oracle таблиц из аналогичной базы : Oracle

BotMan · █ 04.05.2015 14:21

покажите listener и tnsnames

и еще

в cmd:

Lsnrctl
status;

CriticalDays · █ 04.05.2015 14:33

Лисенер

# listener.ora Network Configuration File: D:\Oracle\Server\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\Oracle\Server)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\Oracle\Server\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = YUTCO)
(ORACLE_HOME = D:\Oracle\Server)
(SID_NAME = YUTCO)
)
)

ТНС

# tnsnames.ora Network Configuration File: D:\Oracle\Server\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_YUTCO =
(ADDRESS = (PROTOCOL = TCP)(HOST = Server)(PORT = 1525))

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1525))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

YUTCO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Server)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = YUTCO)
)
)

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Server)(PORT = 1525))
)

ADR_BASE_LISTENER = D:\Oracle

и последнее

Microsoft Windows [Version 6.1.7601]
(c) Корпорация Майкрософт (Microsoft Corporation), 2009. Все права защищены.

C:\Users\admin>TNSPING 192.168.2.3

TNS Ping Utility for 64-bit Windows: Version 11.2.0.4.0 - Production on 04-╠└╔-2
015 14:46:59

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

╚ёяюы№чютрэ√ Їрщы√ ярЁрьхЄЁют:
D:\Oracle\Server\network\admin\sqlnet.ora

╚ёяюы№чютрэ рфряЄхЁ HOSTNAME фы ЁрчЁх°хэш яёхтфюэшьр
┬√яюыэхэр яюя√Єър ётчш ё (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(P
ROTOCOL=TCP)(HOST=192.168.2.3)(PORT=1521)))
TNS-12541: TNS:эхЄ яЁюёыє°штрЄхы

C:\Users\admin>set nls_lang=american_america.cl8mswin1251

C:\Users\admin>TNSPING 192.168.2.3

TNS Ping Utility for 64-bit Windows: Version 11.2.0.4.0 - Production on 04-MAY-2
015 14:47:33

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

Used parameter files:
D:\Oracle\Server\network\admin\sqlnet.ora

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTO
COL=TCP)(HOST=192.168.2.3)(PORT=1521)))
TNS-12541: TNS:no listener

C:\Users\admin>Lsnrctl

LSNRCTL for 64-bit Windows: Version 11.2.0.4.0 - Production on 04-MAY-2015 15:22
:45

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status;
NL-00853: undefined command "status;". Try "help"
LSNRCTL> Lsnrctl
NL-00853: undefined command "Lsnrctl". Try "help"
LSNRCTL> lsnrctl status;
NL-00853: undefined command "lsnrctl". Try "help"
LSNRCTL> exit;
NL-00853: undefined command "exit;". Try "help"
LSNRCTL> exit

C:\Users\admin>Lsnrctl status;

LSNRCTL for 64-bit Windows: Version 11.2.0.4.0 - Production on 04-MAY-2015 15:24
:04

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

NL-00853: undefined command "status;". Try "help"

C:\Users\admin>sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 4 15:28:07 2015

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

SQL> conn sys/qqq@yutco as sysdba
ERROR:
ORA-01017: эхтхЁэю шь яюы№чютрЄхы/ярЁюы№; тїюф т ёшёЄхьє чряЁх∙рхЄё

SQL> conn sys/QQQ@yutco as sysdba
Connected.
SQL> lsnrctl status
SP2-0734: unknown command beginning "lsnrctl st..." - rest of line ignored.
SQL> lsnrctl status;
SP2-0734: unknown command beginning "lsnrctl st..." - rest of line ignored.
SQL> exit;
Disconnected from Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

C:\Users\admin>set nls_lang=american_america.cl8mswin1251

C:\Users\admin>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.4.0 - Production on 04-MAY-2015 15:32
:34

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Server)(PORT=1525)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.4.0 - Produ
ction
Start Date 04-MAY-2015 13:45:10
Uptime 0 days 1 hr. 47 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\Oracle\Server\network\admin\listener.ora
Listener Log File D:\Oracle\diag\tnslsnr\Server\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Server)(PORT=1525)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "YUTCO" has 2 instance(s).
Instance "YUTCO", status UNKNOWN, has 1 handler(s) for this service...
Instance "yutco", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\Users\admin>

CriticalDays · █ 04.05.2015 14:33

прошу прощения за последнее, не глянул и не отредактировал (

BotMan · █ 04.05.2015 14:49

позвольте поинтересоваться чем не устраивает стандартный и рекомендованный порт 1521???

что касается остального, то я бы поступил след образом.

переименовал оба файла в Listener.ora.old и tnsnames.ora.old соответственно.

потом cmd:

Код:

netca

создал стандартный listener с портом по умолчанию 1521(дабы не придумывать велосипед)

правим TNSNAMEs - Это мой TNSNAMES

Код:

MYBASE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = пробуем вписывать IP 192.168.2.3 или Имя машины SERVER)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = MYBASE)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

далее

cmd:

Код:

lsnrctl 
stop
start
status