[Oracle 10gR2] Проблемы после установки
От: IntDex Беларусь  
Дата: 27.05.10 13:37
Оценка:
ОС: Fedora 13
Создал БД, утилитой: dbca
Поправил /etc/oratab c N на Y — olo:/opt/oracle/10gR2:Y
Импортирую БД: imp userid=olo/olo@olo fromuser=olo touser=olo log=logolo.txt file=dbolo.dmp
Получаю:
Import: Release 10.2.0.1.0 — Production on Thu May 27 15:58:10 2010

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


IMP-00058: ORACLE error 12514 encountered
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
IMP-00000: Import terminated unsuccessfully
****
Конфиги:
[root@ooil incoming]# vi /opt/oracle/10gR2/network/admin/listener.ora
# listener.ora Network Configuration File: /opt/oracle/10gR2/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/10gR2)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = ooil.local)(PORT = 1521))
)
)
[root@ooil incoming]# vi /opt/oracle/10gR2/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /opt/oracle/10gR2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

OLO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ooil.local)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = olo)
)
)

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

OOIL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ooil.local)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ooil)
)
)
***
Помогите решить проблему.
... << RSDN@Home 1.2.0 alpha 4 rev. 1325>>
 
Подождите ...
Wait...
Пока на собственное сообщение не было ответов, его можно удалить.