[ТЕМА ЗАКРЫТА]
Опции темы
07.04.2014 15:03  
alicedr
Цитата:
Сообщение от OlegON
11.2.0.1 - плохо
описываем, как получается следующее выполняем все сразу и с одним пользователем, все работы на сервере с локальной консоли:
1. Останавливаем и запускаем сервер приложений (баночка зеленая)
2. Пытаемся подключиться к базе в базовом модуле, если получается ошибка - приводим алертлог за время с п.1 по последнюю строку. Если не получается текстом - можно вложением к сообщению. Внимательно смотрим, что ни в одном журнале Windows никаких красных сообщений с времени п.1 не произошло.

очень похоже, что клиент, т.е. Сервер приложений, отваливается, потому, что криво установили винду, Oracle или сервер с несколькими интерфейсами, часть из которых скачет.
c:\sm2000\data\SmerrorLog1404.txt
Код:
2014.04.07 (понедельник) 14:42:39 1.30.0.0 Sm.Main
----- Прерывание работы программы -----
сообщение: "ORA-20017: Клиентский процесс не зарегистрирован сервером
ORA-06512: at "SUPERMAG.CORE", line 301
ORA-06512: at "SUPERMAG.CORE", line 1503
ORA-06512: at line 1
"
исключение: System.Data.OracleClient.OracleException
источник: System.Data.OracleClient
метод: Void CheckError(System.Data.OracleClient.OciErrorHandle, Int32)
   at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
   at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
 
07.04.2014 15:05  
Mtirt
Олег просил alert.log, а не лог Супермага.
 
07.04.2014 15:06  
alicedr
alert.log
Код:
Mon Apr 07 14:42:03 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in client-side pfile C:\SM2000\ORASRV\DATABASE\INITNV1.ORA on machine KIDTSQL0
System parameters with non-default values:
  processes                = 150
  memory_target            = 1232M
  control_files            = "D:\DATA\SUPERMAG\NV1\NV1\CONTROL01.CTL"
  control_files            = "D:\DATA\SUPERMAG\NV1\NV1\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "d:\ora_archivelog\"
  db_recovery_file_dest_size= 45G
  undo_tablespace          = "UNDOTBS1"
  O7_DICTIONARY_ACCESSIBILITY= TRUE
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=NV1XDB)"
  audit_file_dest          = "D:\DATA\SUPERMAG\NV1\ADMIN\NV1\ADUMP"
  audit_trail              = "DB"
  audit_trail              = "EXTENDED"
  db_name                  = "NOVUSM1"
  open_cursors             = 300
  diagnostic_dest          = "D:\DATA\SUPERMAG\NV1"
Mon Apr 07 14:42:03 2014
PMON started with pid=2, OS id=2592 
Mon Apr 07 14:42:03 2014
VKTM started with pid=3, OS id=3152 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Apr 07 14:42:03 2014
GEN0 started with pid=4, OS id=1336 
Mon Apr 07 14:42:03 2014
DIAG started with pid=5, OS id=2140 
Mon Apr 07 14:42:03 2014
DBRM started with pid=6, OS id=3700 
Mon Apr 07 14:42:03 2014
PSP0 started with pid=7, OS id=3552 
Mon Apr 07 14:42:03 2014
DIA0 started with pid=8, OS id=964 
Mon Apr 07 14:42:03 2014
MMAN started with pid=9, OS id=1888 
Mon Apr 07 14:42:03 2014
DBW0 started with pid=10, OS id=1180 
Mon Apr 07 14:42:03 2014
LGWR started with pid=11, OS id=3816 
Mon Apr 07 14:42:03 2014
CKPT started with pid=12, OS id=3668 
Mon Apr 07 14:42:03 2014
SMON started with pid=13, OS id=2612 
Mon Apr 07 14:42:03 2014
RECO started with pid=14, OS id=3384 
Mon Apr 07 14:42:03 2014
MMON started with pid=15, OS id=3188 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Apr 07 14:42:03 2014
MMNL started with pid=16, OS id=2472 
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\DATA\SUPERMAG
Mon Apr 07 14:42:04 2014
alter database mount exclusive
Successful mount of redo thread 1, with mount id 3956529276
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
LGWR: STARTING ARCH PROCESSES
Mon Apr 07 14:42:08 2014
ARC0 started with pid=20, OS id=3576 
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Mon Apr 07 14:42:08 2014
ARC1 started with pid=21, OS id=3112 
Mon Apr 07 14:42:08 2014
ARC2 started with pid=22, OS id=3176 
Mon Apr 07 14:42:08 2014
ARC3 started with pid=23, OS id=3720 
ARC1: Archival started
ARC2: Archival started
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
Thread 1 opened at log sequence 6824
  Current log# 2 seq# 6824 mem# 0: D:\DATA\SUPERMAG\NV1\NV1\REDO02.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is CL8MSWIN1251
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Starting background process QMNC
Mon Apr 07 14:42:10 2014
QMNC started with pid=24, OS id=260 
Completed: alter database open
Starting background process CJQ0
Mon Apr 07 14:42:11 2014
CJQ0 started with pid=28, OS id=4084 
Mon Apr 07 14:42:12 2014
db_recovery_file_dest_size of 46080 MB is 26.99% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Apr 07 14:42:16 2014
Errors in file d:\data\supermag\NV1\diag\rdbms\novusm1\NV1\trace\NV1_j005_1520.trc:
ORA-12012: error on auto execute of job 75502
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 633
ORA-29283: invalid file operation
ORA-06512: at "SYS.PINTERNETSHOP", line 11
Mon Apr 07 14:42:55 2014
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process QMNC
Mon Apr 07 14:42:55 2014
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 12
All dispatchers and shared servers shutdown
alter database close normal
Mon Apr 07 14:42:56 2014
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon Apr 07 14:42:56 2014
Shutting down archive processes
Archiving is disabled
Mon Apr 07 14:42:56 2014
ARCH shutting down
ARC0: Archival stopped
Mon Apr 07 14:42:56 2014
ARCH shutting down
ARC2: Archival stopped
Mon Apr 07 14:42:56 2014
ARCH shutting down
ARC3: Archival stopped
Mon Apr 07 14:42:56 2014
ARCH shutting down
ARC1: Archival stopped
Thread 1 closed at log sequence 6824
Successful close of redo thread 1
Completed: alter database close normal
alter database dismount
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Apr 07 14:42:59 2014
Stopping background process VKTM: 
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Apr 07 14:43:01 2014
Instance shutdown complete
 
07.04.2014 15:14  
alicedr
то же самое с 11.203
супермаг:
Код:
2014.04.07 (понедельник) 15:08:45 1.30.0.0 Sm.Main
----- Прерывание работы программы -----
сообщение: "ORA-20017: Клиентский процесс не зарегистрирован сервером
ORA-06512: at "SUPERMAG.CORE", line 301
ORA-06512: at "SUPERMAG.CORE", line 1503
ORA-06512: at line 1
"
исключение: System.Data.OracleClient.OracleException
источник: System.Data.OracleClient
метод: Void CheckError(System.Data.OracleClient.OciErrorHandle, Int32)
   at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
алерт.лог
Код:
Mon Apr 07 15:08:15 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =35
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Windows NT Version V6.1 Service Pack 1 
CPU                 : 4 - type 8664, 4 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:6643M/8186M, Ph+PgF:14435M/16370M 
Using parameter settings in server-side spfile C:\SM2000\ORASRV11203\DATABASE\SPFILEN1.ORA
System parameters with non-default values:
  processes                = 200
  event                    = ""
  sga_target               = 584M
  control_files            = "D:\DATA\ORADATA\N1\CONTROL01.CTL"
  control_files            = "D:\DATA\ORADATA\N1\CONTROL02.CTL"
  control_files            = "D:\DATA\ORADATA\N1\CONTROL03.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = "D:\ORA_Archivelog\"
  db_recovery_file_dest_size= 45G
  undo_management          = "AUTO"
  undo_tablespace          = "UNDOTBS1"
  O7_DICTIONARY_ACCESSIBILITY= TRUE
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  job_queue_processes      = 10
  audit_file_dest          = "C:\ORACLE\ADMIN\N1\ADUMP"
  core_dump_dest           = "D:\DATA\ORADATA\ADMIN\N1\CDUMP"
  db_name                  = "N1"
  open_cursors             = 300
  pga_aggregate_target     = 194M
  diagnostic_dest          = "D:\DATA\SUPERMAG"
Mon Apr 07 15:08:15 2014
PMON started with pid=2, OS id=2188 
Mon Apr 07 15:08:15 2014
PSP0 started with pid=3, OS id=1316 
Mon Apr 07 15:08:16 2014
VKTM started with pid=4, OS id=2588 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Apr 07 15:08:16 2014
GEN0 started with pid=5, OS id=1160 
Mon Apr 07 15:08:16 2014
DIAG started with pid=6, OS id=3352 
Mon Apr 07 15:08:16 2014
DBRM started with pid=7, OS id=3760 
Mon Apr 07 15:08:16 2014
DIA0 started with pid=8, OS id=3628 
Mon Apr 07 15:08:16 2014
MMAN started with pid=9, OS id=1744 
Mon Apr 07 15:08:16 2014
DBW0 started with pid=10, OS id=3444 
Mon Apr 07 15:08:16 2014
LGWR started with pid=11, OS id=3224 
Mon Apr 07 15:08:16 2014
CKPT started with pid=12, OS id=3620 
Mon Apr 07 15:08:16 2014
SMON started with pid=13, OS id=2692 
Mon Apr 07 15:08:16 2014
RECO started with pid=14, OS id=320 
Mon Apr 07 15:08:16 2014
MMON started with pid=15, OS id=2464 
Mon Apr 07 15:08:16 2014
MMNL started with pid=16, OS id=3268 
ORACLE_BASE from environment = D:\DATA\SUPERMAG
Mon Apr 07 15:08:16 2014
alter database mount exclusive
Successful mount of redo thread 1, with mount id 3956550048
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Thread 1 opened at log sequence 756
  Current log# 3 seq# 756 mem# 0: D:\DATA\ORADATA\N1\REDO03.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
[1112] Successfully onlined Undo Tablespace 1.
Undo initialization finished serial:0 start:253518020 end:253518223 diff:203 (2 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is CL8MSWIN1251
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Mon Apr 07 15:08:22 2014
QMNC started with pid=18, OS id=3908 
Completed: alter database open
Starting background process CJQ0
Mon Apr 07 15:08:24 2014
CJQ0 started with pid=19, OS id=2444 
Mon Apr 07 15:08:24 2014
db_recovery_file_dest_size of 46080 MB is 33.20% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Apr 07 15:08:57 2014
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process QMNC
Mon Apr 07 15:08:57 2014
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 8
alter database close normal
Mon Apr 07 15:08:59 2014
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon Apr 07 15:08:59 2014
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 756
Successful close of redo thread 1
Completed: alter database close normal
alter database dismount
Shutting down archive processes
Archiving is disabled
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Mon Apr 07 15:09:00 2014
Stopping background process VKTM
Mon Apr 07 15:09:02 2014
Instance shutdown complete
 
07.04.2014 15:19  
Mtirt
А если отключить O7_DICTIONARY_ACCESSIBILITY= TRUE ? Он нужен только Генератору БД по большому счету.
 
07.04.2014 15:29  
alicedr
Цитата:
Сообщение от Mtirt
А если отключить O7_DICTIONARY_ACCESSIBILITY= TRUE ? Он нужен только Генератору БД по большому счету.
А если вдруг пользователю оракла по имени Супермаг захочется сделать выборку по какой-то системной табличке и он не сможет? Например, посмотреть время начала выполнения задания в модуле "администратор"-база данных-задания
 
07.04.2014 15:33  
alicedr
Цитата:
Сообщение от Mtirt
А если отключить O7_DICTIONARY_ACCESSIBILITY= TRUE ? Он нужен только Генератору БД по большому счету.
Все равно попробовала. То же самое.
 
07.04.2014 15:56  
alicedr
Цитата:
Сообщение от OlegON
очень похоже, что клиент, т.е. Сервер приложений, отваливается, потому, что криво установили винду, Oracle или сервер с несколькими интерфейсами, часть из которых скачет.
Сессии сервера приложений, а если запущен модуль администратора-то и его сессия, могут быть открытыми сколько нужно долго, отваливаний не наблюдается.
При вводе неправильного пароля в супермаг выдается сообщение о неправильном пароле, т.е. соединение с ораклом устанавливается. Логи листенера, кстати, это подтверждают (ниже). Однако ошибок соединения нет ни в логе оракла, ни в логе листенера, так что соединение завершается корректно, получается так.

Лог листенера:
Код:
Mon Apr 07 14:42:04 2014
Dynamic address is already listened on (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=KIDTSQL0)(PORT=1521)))
07-APR-2014 14:42:04 * service_register * nv1 * 0
07-APR-2014 14:42:08 * service_update * nv1 * 0
07-APR-2014 14:42:11 * service_update * nv1 * 0
Mon Apr 07 14:42:14 2014
07-APR-2014 14:42:14 * service_update * nv1 * 0
07-APR-2014 14:42:19 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50739)) * establish * n1 * 0
07-APR-2014 14:42:20 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50741)) * establish * n1 * 0
07-APR-2014 14:42:20 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50742)) * establish * n1 * 0
07-APR-2014 14:42:20 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50743)) * establish * n1 * 0
07-APR-2014 14:42:20 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50744)) * establish * n1 * 0
07-APR-2014 14:42:20 * service_update * nv1 * 0
07-APR-2014 14:42:20 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50745)) * establish * n1 * 0
07-APR-2014 14:42:23 * service_update * nv1 * 0
07-APR-2014 14:42:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50746)) * establish * n1 * 0
Mon Apr 07 14:42:26 2014
07-APR-2014 14:42:26 * service_update * nv1 * 0
Mon Apr 07 14:42:38 2014
07-APR-2014 14:42:38 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.Main.exe)(HOST=KIDTSQL0)(USER=master))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50757)) * establish * n1 * 0
07-APR-2014 14:42:39 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.Main.exe)(HOST=KIDTSQL0)(USER=master))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50758)) * establish * n1 * 0
07-APR-2014 14:42:47 * service_update * nv1 * 0
07-APR-2014 14:42:48 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50759)) * establish * n1 * 0
Mon Apr 07 14:42:50 2014
07-APR-2014 14:42:50 * service_update * nv1 * 0
07-APR-2014 14:42:56 * service_update * nv1 * 0
07-APR-2014 14:42:58 * service_died * nv1 * 12537
Mon Apr 07 15:08:15 2014
Dynamic address is already listened on (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=KIDTSQL0)(PORT=1521)))
07-APR-2014 15:08:15 * service_register * n1 * 0
07-APR-2014 15:08:16 * service_update * n1 * 0
07-APR-2014 15:08:21 * service_update * n1 * 0
07-APR-2014 15:08:24 * service_update * n1 * 0
Mon Apr 07 15:08:27 2014
07-APR-2014 15:08:27 * service_update * n1 * 0
07-APR-2014 15:08:29 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50767)) * establish * n1 * 0
07-APR-2014 15:08:29 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50768)) * establish * n1 * 0
07-APR-2014 15:08:29 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50769)) * establish * n1 * 0
07-APR-2014 15:08:30 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50770)) * establish * n1 * 0
07-APR-2014 15:08:30 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50771)) * establish * n1 * 0
07-APR-2014 15:08:30 * service_update * n1 * 0
07-APR-2014 15:08:30 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50772)) * establish * n1 * 0
07-APR-2014 15:08:34 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50773)) * establish * n1 * 0
07-APR-2014 15:08:36 * service_update * n1 * 0
Mon Apr 07 15:08:44 2014
07-APR-2014 15:08:44 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.Main.exe)(HOST=KIDTSQL0)(USER=master))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50774)) * establish * n1 * 0
07-APR-2014 15:08:45 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.Main.exe)(HOST=KIDTSQL0)(USER=master))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50775)) * establish * n1 * 0
07-APR-2014 15:08:49 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=n1)(CID=(PROGRAM=C:\SM2000\Bin\Sm.AppServer.exe)(HOST=KIDTSQL0)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7c46:4ca4:6e2d:8f16%16)(PORT=50776)) * establish * n1 * 0
07-APR-2014 15:08:51 * service_update * n1 * 0
Mon Apr 07 15:08:57 2014
Пользователь Master входит в группу администраторов и является основной учетной записью для администрирования сервера, в том числе и для установки ПО.
 
07.04.2014 16:06  
OlegON
Я вообще-то определенную последовательность просил... И проверить журнал винды.
После того, как клиент незарегистрирован, закрыть/открыть сервер приложений, банка зеленая? Если нет - правой кнопкой на ней - "Последняя ошибка".
 
07.04.2014 16:14  
alicedr
Цитата:
Сообщение от OlegON
Я вообще-то определенную последовательность просил... И проверить журнал винды.
После того, как клиент незарегистрирован, закрыть/открыть сервер приложений, банка зеленая? Если нет - правой кнопкой на ней - "Последняя ошибка".
БАНКА ЗЕЛЕНАЯ. Правой кнопкой по ней-активно только "отключить бд"

В журнале Винды чисто, красных сообщений нет!
Сегодняшние только типа "The OracleServiceNV1 service entered the running state", "The Супермаг - Сервер приложений service entered the running state"-в системных, в application-Initializing PGA for process SMCO in instance nv1, Initializing PGA for process SMCO in instance nv1.

Я ж пишу, что ВСЕ, абсолютно ВСЕ работает как надо. Кроме Супермага.
 
 


Опции темы



Часовой пояс GMT +3, время: 23:25.

Все в прочитанное - Календарь - RSS - - Карта - Вверх 👫 Яндекс.Метрика
Форум сделан на основе vBulletin®
Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. Перевод: zCarot и OlegON
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.