Доброго времени суток всем!
Накатываю себе тестовую базу (машинка хилая, поэтому 2003R2 32 бита, Oracle 10g2). Все установилось, создал БД, сконфигурировал LISTENER. В итоге:
tnsping и на самом серваке, и с удаленной машины - Ок.
А вот
conn sys/qqq@alkom1 as sysdba - эта самая ошибка. В хвосте алертлога
Цитата: Wed Jan 20 15:35:08 2016
ALTER DATABASE OPEN
Wed Jan 20 15:35:08 2016
Thread 1 opened at log sequence 30
Current log# 3 seq# 30 mem# 0: D:\ORADATA\ALKOM1\REDO03.LOG
Successful open of redo thread 1
Wed Jan 20 15:35:08 2016
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Jan 20 15:35:08 2016
SMON: enabling cache recovery
Wed Jan 20 15:35:09 2016
Successfully onlined Undo Tablespace 1.
Wed Jan 20 15:35:09 2016
SMON: enabling tx recovery
Wed Jan 20 15:35:09 2016
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=15, OS id=536
Wed Jan 20 15:35:13 2016
Completed: ALTER DATABASE OPEN
Как я понимаю, база стартовала.
В итоге
lnsrctl status
Цитата: Instance PLSExtProc status UNKNOWN
Всю голову сломал... В нете ничего толкового не нашел... Подскажите, плз, куда копать...
Listener.ora
Код:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = servtest)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
) Tnsnames.ora
Код:
ALKOM1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVTEST)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ALKOM1)
(SERVER = DEDICATED)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)