Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
 Oracle 12 impdp ORA-31626 job does not exist  [new]
teejay
Member

Откуда:
Сообщений: 10
Добрый день.
Есть свежеустановленный Oracle:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
PL/SQL Release 12.2.0.1.0 - Production
CORE	12.2.0.1.0	Production
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
NLSRTL Version 12.2.0.1.0 - Production


Необходимо накатить схему из дампа, созданного при помощи expdp.
Процедура отработанная, повторяли ни раз:
-делаем бэкап схемы
-на новой базе создаём схему
-при помощи impdp накатываем его на чистую базу

В этот раз что-то пошло не так :)
при попытке запустить impdp из консоли как обычно
impdp sys/password@xxx SCHEMA=yyyy directory=UTL_FILE_DIR dumpfile='file.dmp' logfile='file.log'

получили ошибку:
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_IMPORT_SCHEMA_01 for user SYS
ORA-06512: as "SYS.KUPV$FT", line 1140
...
ORA-21561: OID generation failed
...

Аналогично при попытке запустить в Oracle (из под sys, system и простого пользователя с необходимыми правами), получаем исключение:
DECLARE 
    HAND NUMBER;
    FTYPE$ NUMBER;
    RES$ BOOLEAN := DBMS_DATAPUMP.DATAPUMP_JOB;
    PRIVS$ BOOLEAN := DBMS_DATAPUMP.HAS_PRIVS('SNSZ');
BEGIN

    HAND := DBMS_DATAPUMP.OPEN(
    'IMPORT',
    'SCHEMA',
    NULL,
    NULL);

    DBMS_DATAPUMP.ADD_FILE(HANDLE => HAND,
    FILENAME => 'test-test.dmp',
    DIRECTORY=> 'UTL_FILE_DIR');
  
    DBMS_DATAPUMP.START_JOB(HAND);
    DBMS_DATAPUMP.DETACH(HAND);
END;

...

ORA-31626: задание не существует -31626

В пакете это исключение описано следующим образом:
+
no_such_job EXCEPTION;
PRAGMA EXCEPTION_INIT(no_such_job, -31626);
no_such_job_num CONSTANT NUMBER := -31626;
-- "job does not exist"
-- *Cause: A invalid reference to a job which is no longer executing,
-- is not executing on the instance where the operation was
-- attempted, or that does not have a valid Master Table.
-- Refer to the secondary error messages that follow this one for
-- clarification concerning the problems with the Master Table.
-- *Action: Start a new job, or attach to an existing job that has a
-- valid Master Table.


Делать Attach не к чему, перезапуск не помогает.

Основной совет, который даёт гугл, это очистить джобы datapump'a из таблиц
DBA_DATAPUMP_JOBS
USER_DATAPUMP_JOBS
DBA_DATAPUMP_SESSIONS

но в них пусто, ведь ещё ничего нет: база чистая!
Директория присутствует, файл дампа в порядке и читается процедурой DBMS_DATAPUMP.GET_DUMPFILE_INFO
Привилегии IMP_FULL_DATABASE, DATAPUMP_IMP_FULL_DATABASE, DATAPUMP_EXP_FULL_DATABASE, EXP_FULL_DATABASE в наличии.

В пакете DBMS_DATAPUMP имеется пара процедур DATAPUMP_JOB и HAS_PRIVS('SYS'). Обе возвращают false.

Пока даже не понятно, где искать проблему. Может кто сталкивался с подобным?
28 фев 19, 15:13    [21821849]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
Elic
Member

Откуда: 1984. Выбраковка финно-угром продолжается. КЯЗ
Сообщений: 28718
teejay
ORA-21561: OID generation failed
Поиском не владеешь?
28 фев 19, 15:23    [21821865]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
teejay
Member

Откуда:
Сообщений: 10
Elic,

читать умеем?
DECLARE 
    HAND NUMBER;
    FTYPE$ NUMBER;
    RES$ BOOLEAN := DBMS_DATAPUMP.DATAPUMP_JOB;
    PRIVS$ BOOLEAN := DBMS_DATAPUMP.HAS_PRIVS('SNSZ');
BEGIN

    HAND := DBMS_DATAPUMP.OPEN(
    'IMPORT',
    'SCHEMA',
    NULL,
    NULL);

    DBMS_DATAPUMP.ADD_FILE(HANDLE => HAND,
    FILENAME => 'test-test.dmp',
    DIRECTORY=> 'UTL_FILE_DIR');
  
    DBMS_DATAPUMP.START_JOB(HAND);
    DBMS_DATAPUMP.DETACH(HAND);
END;

...

ORA-31626: задание не существует -31626

no_such_job EXCEPTION;
PRAGMA EXCEPTION_INIT(no_such_job, -31626);
no_such_job_num CONSTANT NUMBER := -31626;
-- "job does not exist"
-- *Cause: A invalid reference to a job which is no longer executing,
-- is not executing on the instance where the operation was
-- attempted, or that does not have a valid Master Table.
-- Refer to the secondary error messages that follow this one for
-- clarification concerning the problems with the Master Table.
-- *Action: Start a new job, or attach to an existing job that has a
-- valid Master Table.
28 фев 19, 15:30    [21821878]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
andrey_anonymous
Member

Откуда: Москва
Сообщений: 17146
teejay
читать умеем?

Внимательно прочтите свой стек ошибок.
Много думайте.
Прочтите сообщение Elic еще раз.
На будущее: педаль акселератора обычно расположена справа от педали тормоза.
28 фев 19, 15:43    [21821896]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
flexgen
Member

Откуда: Город на песке
Сообщений: 683
teejay,

Я так подозреваю что тебе надо сюда - ORA-31637: Cannot Create Job Sys_export_table_01 For User System (Doc ID 871873.1)
1 мар 19, 01:15    [21822307]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
flexgen
Member

Откуда: Город на песке
Сообщений: 683
flexgen
teejay,

Я так подозреваю что тебе надо сюда - ORA-31637: Cannot Create Job Sys_export_table_01 For User System (Doc ID 871873.1)


Не обратил внимание что у тебя падает импорт а не экспорт. Что-нибудь в алерт-логе есть?
1 мар 19, 01:21    [21822310]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
Elic
Member

Откуда: 1984. Выбраковка финно-угром продолжается. КЯЗ
Сообщений: 28718
flexgen
Что-нибудь … есть?
Ты тоже учись читать.
1 мар 19, 07:23    [21822363]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
teejay
Member

Откуда:
Сообщений: 10
flexgen,
На самом деле с экспортом такая же проблема как и с импортом.
Алерт лог есть, могу ошибаться, но он не особо проясняет ситуацию
+

Starting ORACLE instance (normal) (OS id: 11808)

CLI notifier numLatches:37 maxDescs:3194

All SGA segments were allocated at startup

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Initial number of CPU is 24

Number of processor cores in the system is 24

Number of processor sockets in the system is 24

Shared memory segment for instance monitoring created

Using LOG_ARCHIVE_DEST_1 parameter default value as c:\app\db\product\12.2.0\dbhome_1\RDBMS

Autotune of undo retention is turned on.

IMODE=BR

ILAT =319

LICENSE_MAX_USERS = 0

SYS auditing is enabled

NOTE: remote asm mode is local (mode 0x1; from cluster type)

NOTE: Using default ASM root directory ASM

NOTE: Cluster configuration type = NONE [2]

NUMA system with 2 nodes detected

Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production.

Windows NT Version V6.2
ORACLE_HOME = c:\app\db\product\12.2.0\dbhome_1
Node name : db4
CPU : 24 - type 8664, 24 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:8391M/153599M, Ph+PgF:232

VM name : VMWare Version (6)

Using parameter settings in client-side pfile C:\APP\db\ADMIN\company\PFILE\INIT.ORA on machine db4

System parameters with non-default values:

processes = 1920

nls_language = AMERICAN

nls_territory = AMERICA

sga_target = 24192M

control_files = G:\ORADATA\company\CONTROL01.CTL

control_files = G:\ORADATA\company\CONTROL02.CTL

db_block_size = 8192

compatible = 12.2.0

undo_tablespace = UNDOTBS1

remote_login_passwordfile= EXCLUSIVE

dispatchers = (PROTOCOL=TCP) (SERVICE=companyXDB)

local_listener = LISTENER_company

audit_file_dest = C:\APP\db\ADMIN\company\ADUMP

audit_trail = DB

db_name = company

open_cursors = 300

pga_aggregate_target = 8047M

diagnostic_dest = C:\APP\db

NOTE: remote asm mode is local (mode 0x1; from cluster type)

============================================================

NOTE: PatchLevel of this instance 0

============================================================

Starting background process PMON

PMON started with pid=2, OS id=26692

Starting background process CLMN

CLMN started with pid=3, OS id=28764

Starting background process PSP0

Starting background process VKTM

PSP0 started with pid=4, OS id=24768

VKTM started with pid=5, OS id=19216 at elevated (Time Critical) priority

VKTM running at (5)millisec precision with DBRM quantum (100)ms

Starting background process GEN0

GEN0 started with pid=6, OS id=12624

Starting background process MMAN

MMAN started with pid=7, OS id=1604

Starting background process GEN1

GEN1 started with pid=9, OS id=13116

Starting background process DIAG

DIAG started with pid=10, OS id=21516

Starting background process OFSD

OFSD started with pid=11, OS id=18384

Oracle running with ofslib:'·' version=2

Starting background process DBRM

DBRM started with pid=8, OS id=9624

Starting background process VKRM

VKRM started with pid=11, OS id=7708

Starting background process SVCB

SVCB started with pid=12, OS id=20124

Starting background process PMAN

Starting background process DIA0

Starting background process DBW0

PMAN started with pid=13, OS id=27640

DIA0 started with pid=14, OS id=29520

Using default pga_aggregate_limit of 16094 MB

DBW0 started with pid=15, OS id=16792

Starting background process DBW1

DBW1 started with pid=16, OS id=1564

Starting background process DBW2

DBW2 started with pid=17, OS id=5696

Starting background process LGWR

LGWR started with pid=18, OS id=21196

Starting background process CKPT

CKPT started with pid=19, OS id=19772

LGWR slave LG00 created with pid=20, OS pid=18796

Starting background process SMON

SMON started with pid=21, OS id=4968

LGWR slave LG01 created with pid=22, OS pid=16284

Starting background process SMCO

SMCO started with pid=23, OS id=10764

Starting background process RECO

RECO started with pid=24, OS id=10064

Starting background process LREG

LREG started with pid=26, OS id=20852

Starting background process PXMN

PXMN started with pid=28, OS id=28240

Starting background process FENC

FENC started with pid=29, OS id=20904

Starting background process MMON

MMON started with pid=30, OS id=16588

Starting background process MMNL

MMNL started with pid=31, OS id=3504

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

starting up 1 shared server(s) ...

Starting background process TMON

TMON started with pid=34, OS id=15560

ORACLE_BASE from environment = c:\app\db

CREATE DATABASE company
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'g:\oradata\company\system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'g:\oradata\company\sysaux01.dbf' SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'g:\oradata\company\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE 'g:\oradata\company\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET CL8MSWIN1251
NATIONAL CHARACTER SET UTF8
LOGFILE GROUP 1 ('g:\oradata\company\redo01.log') SIZE 200M,
GROUP 2 ('g:\oradata\company\redo02.log') SIZE 200M,
GROUP 3 ('g:\oradata\company\redo03.log') SIZE 200M
USER SYS IDENTIFIED BY USER SYSTEM IDENTIFIED BY

Expanded controlfile section 32 from 31 to 128 records

Requested to grow by 97 records; added 3 blocks of records

Network throttle feature is disabled as mount time

Database mounted in Exclusive Mode

Lost write protection disabled

Using STANDBY_ARCHIVE_DEST parameter default value as c:\app\db\product\12.2.0\dbhome_1\RDBMS

Successful mount of redo thread 1, with mount id 3274104927

Ping without log force is disabled:

instance mounted in exclusive mode.

Buffer Cache Full DB Caching mode changing from FULL CACHING DISABLED to FULL CACHING ENABLED

Database SCN compatibility initialized to 1

Assigning activation ID 3274104927 (0xc326e05f)

TT00: Gap Manager starting (PID:21420)

Thread 1 opened at log sequence 1

Current log# 1 seq# 1 mem# 0: G:\ORADATA\company\REDO01.LOG

Successful open of redo thread 1

processing %ORACLE_HOME%\RDBMS\ADMIN\dcore.bsq

create tablespace SYSTEM datafile 'g:\oradata\company\system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED

EXTENT MANAGEMENT LOCAL online

Endian type of dictionary set to little

Completed: create tablespace SYSTEM datafile 'g:\oradata\company\system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED

EXTENT MANAGEMENT LOCAL online

create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)

Completed: create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)

Caching undo dictionary info: used hint for object index=0

Caching undo dictionary info: used hint for object index=1

Caching undo dictionary info: used hint for object index=2

Caching undo dictionary info: used hint for object index=3

Caching undo dictionary info: used hint for object index=4

Undo initialization finished serial:0 start:452992297 end:452992297 diff:0 ms (0.0 seconds)

alter tablespace system force logging

Completed: alter tablespace system force logging

processing %ORACLE_HOME%\RDBMS\ADMIN\dsqlddl.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\dmanage.bsq

CREATE TABLESPACE sysaux DATAFILE 'g:\oradata\company\sysaux01.dbf' SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE FORCE LOGGING

Completed: CREATE TABLESPACE sysaux DATAFILE 'g:\oradata\company\sysaux01.dbf' SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE FORCE LOGGING

alter tablespace system default compress for all operations

Completed: alter tablespace system default compress for all operations

alter tablespace sysaux default compress for all operations

Completed: alter tablespace sysaux default compress for all operations

processing %ORACLE_HOME%\RDBMS\ADMIN\dplsql.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\dtxnspc.bsq

CREATE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE 'g:\oradata\company\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED


[20008] Successfully onlined Undo Tablespace 2.

Completed: CREATE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE 'g:\oradata\company\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED


CREATE SMALLFILE TEMPORARY TABLESPACE TEMP TEMPFILE 'g:\oradata\company\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED


Completed: CREATE SMALLFILE TEMPORARY TABLESPACE TEMP TEMPFILE 'g:\oradata\company\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED


ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP

Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP

ALTER DATABASE DEFAULT TABLESPACE SYSTEM

Completed: ALTER DATABASE DEFAULT TABLESPACE SYSTEM

processing %ORACLE_HOME%\RDBMS\ADMIN\dfmap.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\denv.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\drac.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\dsec.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\doptim.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\dobj.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\djava.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\dpart.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\drep.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\daw.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\dsummgt.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\dtools.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\dexttab.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\ddm.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\dlmnr.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\ddst.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\dfba.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\dpstdy.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\drupg.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\dtlog.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\dmisc.bsq

processing %ORACLE_HOME%\RDBMS\ADMIN\dhcs.bsq

Successfully created internal service SYS$BACKGROUND at open

Successfully created internal service SYS$USERS at open

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process AQPC

AQPC started with pid=39, OS id=24400

Completed: CREATE DATABASE company
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'g:\oradata\company\system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'g:\oradata\company\sysaux01.dbf' SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'g:\oradata\company\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE 'g:\oradata\company\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET CL8MSWIN1251
NATIONAL CHARACTER SET UTF8
LOGFILE GROUP 1 ('g:\oradata\company\redo01.log') SIZE 200M,
GROUP 2 ('g:\oradata\company\redo02.log') SIZE 200M,
GROUP 3 ('g:\oradata\company\redo03.log') SIZE 200M
USER SYS IDENTIFIED BY USER SYSTEM IDENTIFIED BY

CREATE SMALLFILE TABLESPACE USERS LOGGING DATAFILE 'g:\oradata\company\users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

Completed: CREATE SMALLFILE TABLESPACE USERS LOGGING DATAFILE 'g:\oradata\company\users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

ALTER DATABASE DEFAULT TABLESPACE USERS

Completed: ALTER DATABASE DEFAULT TABLESPACE USERS

Thread 1 advanced to log sequence 2 (LGWR switch)

Current log# 2 seq# 2 mem# 0: G:\ORADATA\company\REDO02.LOG

Thread 1 advanced to log sequence 3 (LGWR switch)

Current log# 3 seq# 3 mem# 0: G:\ORADATA\company\REDO03.LOG

Create Relation IPS_PACKAGE_UNPACK_HISTORY

Thread 1 cannot allocate new log, sequence 4

Checkpoint not complete

Current log# 3 seq# 3 mem# 0: G:\ORADATA\company\REDO03.LOG

Thread 1 advanced to log sequence 4 (LGWR switch)

Current log# 1 seq# 4 mem# 0: G:\ORADATA\company\REDO01.LOG

Thread 1 cannot allocate new log, sequence 5

Checkpoint not complete

Current log# 1 seq# 4 mem# 0: G:\ORADATA\company\REDO01.LOG

Thread 1 advanced to log sequence 5 (LGWR switch)

Current log# 2 seq# 5 mem# 0: G:\ORADATA\company\REDO02.LOG

Resize operation completed for file# 3, old size 204800K, new size 209920K

Thread 1 cannot allocate new log, sequence 6

Checkpoint not complete

Current log# 2 seq# 5 mem# 0: G:\ORADATA\company\REDO02.LOG

Thread 1 advanced to log sequence 6 (LGWR switch)

Current log# 3 seq# 6 mem# 0: G:\ORADATA\company\REDO03.LOG

Resize operation completed for file# 3, old size 209920K, new size 215040K

Resize operation completed for file# 3, old size 215040K, new size 220160K

Resize operation completed for file# 3, old size 220160K, new size 225280K

Resize operation completed for file# 3, old size 225280K, new size 230400K

Resize operation completed for file# 3, old size 230400K, new size 235520K

Resize operation completed for file# 3, old size 235520K, new size 240640K

Shared IO Pool defaulting to 512MB. Trying to get it from Buffer Cache for process 27928.

Resize operation completed for file# 3, old size 240640K, new size 250880K

Thread 1 cannot allocate new log, sequence 7

Checkpoint not complete

Current log# 3 seq# 6 mem# 0: G:\ORADATA\company\REDO03.LOG

Thread 1 advanced to log sequence 7 (LGWR switch)

Current log# 1 seq# 7 mem# 0: G:\ORADATA\company\REDO01.LOG

TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P145 (43515) VALUES LESS THAN (TO_DATE(' 2019-02-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

Resize operation completed for file# 3, old size 250880K, new size 261120K

TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P161 (43515) VALUES LESS THAN (TO_DATE(' 2019-02-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

Resize operation completed for file# 3, old size 261120K, new size 266240K

Resize operation completed for file# 3, old size 266240K, new size 271360K

Resize operation completed for file# 3, old size 271360K, new size 281600K

SERVER COMPONENT id=CATPROC: status=INVALID, version=12.2.0.1.0, timestamp=2019-02-20 21:34:13

ALTER SYSTEM SET db_securefile='NEVER' SCOPE=MEMORY;

ALTER SYSTEM SET db_securefile='PREFERRED' SCOPE=MEMORY;

Resize operation completed for file# 3, old size 281600K, new size 286720K

Resize operation completed for file# 3, old size 286720K, new size 296960K

XDB installed.

XDB initialized.

Thread 1 cannot allocate new log, sequence 8

Checkpoint not complete

Current log# 1 seq# 7 mem# 0: G:\ORADATA\company\REDO01.LOG

Thread 1 advanced to log sequence 8 (LGWR switch)

Current log# 2 seq# 8 mem# 0: G:\ORADATA\company\REDO02.LOG

Resize operation completed for file# 3, old size 296960K, new size 302080K

Resize operation completed for file# 3, old size 302080K, new size 307200K

Resize operation completed for file# 3, old size 307200K, new size 312320K

Resize operation completed for file# 3, old size 312320K, new size 322560K

Resize operation completed for file# 3, old size 322560K, new size 327680K

TABLE AUDSYS.AUD$UNIFIED: ADDED INTERVAL PARTITION SYS_P181 (56) VALUES LESS THAN (TIMESTAMP' 2019-03-01 00:00:00')

joxcsys: begin CREATE JAVA SYSTEM in pid 26872

joxcsys: open migrate not in force for CREATE JAVA SYSTEM

JIT: pid 26872 requesting full stop

Resize operation completed for file# 3, old size 327680K, new size 332800K

Resize operation completed for file# 3, old size 332800K, new size 337920K

Thread 1 cannot allocate new log, sequence 9

Checkpoint not complete

Current log# 2 seq# 8 mem# 0: G:\ORADATA\company\REDO02.LOG

Resize operation completed for file# 3, old size 337920K, new size 348160K

Thread 1 advanced to log sequence 9 (LGWR switch)

Current log# 3 seq# 9 mem# 0: G:\ORADATA\company\REDO03.LOG

Resize operation completed for file# 3, old size 348160K, new size 358400K

Resize operation completed for file# 3, old size 358400K, new size 368640K

Resize operation completed for file# 3, old size 368640K, new size 373760K

Thread 1 cannot allocate new log, sequence 10

Checkpoint not complete

Current log# 3 seq# 9 mem# 0: G:\ORADATA\company\REDO03.LOG

Resize operation completed for file# 3, old size 373760K, new size 384000K

Resize operation completed for file# 3, old size 384000K, new size 389120K

Thread 1 advanced to log sequence 10 (LGWR switch)

Current log# 1 seq# 10 mem# 0: G:\ORADATA\company\REDO01.LOG

Resize operation completed for file# 3, old size 389120K, new size 394240K

Resize operation completed for file# 3, old size 394240K, new size 399360K

Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into table

ORA-06512: at SYS.DBMS_QOPATCH, line 781

ORA-06512: at SYS.DBMS_QOPATCH, line 868

ORA-06512: at SYS.DBMS_QOPATCH, line 2219

ORA-06512: at SYS.DBMS_QOPATCH, line 744

ORA-06512: at SYS.DBMS_QOPATCH, line 2244

===========================================================

Dumping current patch information

===========================================================

Unable to obtain current patch information due to error: 20001

===========================================================

joxcsys: CREATE JAVA SYSTEM done in pid 26872

Resize operation completed for file# 3, old size 399360K, new size 409600K

Resize operation completed for file# 3, old size 409600K, new size 414720K

Resize operation completed for file# 3, old size 414720K, new size 419840K

### queuing purge of JIT compilation in pid 26872 pdb 0 due to creation of 9557b490 oracle/xml/util/XMLUtil

### queuing purge of JIT compilation in pid 26872 pdb 0 due to creation of b7434950 oracle/xdb/XMLType

Thread 1 advanced to log sequence 11 (LGWR switch)

Current log# 2 seq# 11 mem# 0: G:\ORADATA\company\REDO02.LOG

### jox_purge_jit started pid 26872 pdb 0

### jox_purge_jit broke locks pid 26872 pdb 0

### jox_purge_jit locked out jit pid 26872 pdb 0

### jox_purge_jit unlocked jit pid 26872 pdb 0

### jox_purge_jit done pid 26872 pdb 0

Resize operation completed for file# 3, old size 419840K, new size 430080K

Resize operation completed for file# 3, old size 430080K, new size 435200K

Resize operation completed for file# 3, old size 435200K, new size 440320K

Thread 1 cannot allocate new log, sequence 12

Checkpoint not complete

Current log# 2 seq# 11 mem# 0: G:\ORADATA\company\REDO02.LOG

Thread 1 cannot allocate new log, sequence 12

Private strand flush not complete

Current log# 2 seq# 11 mem# 0: G:\ORADATA\company\REDO02.LOG

Thread 1 advanced to log sequence 12 (LGWR switch)

Current log# 3 seq# 12 mem# 0: G:\ORADATA\company\REDO03.LOG

Resize operation completed for file# 1, old size 716800K, new size 727040K

Resize operation completed for file# 3, old size 440320K, new size 450560K

Resize operation completed for file# 3, old size 450560K, new size 455680K

Resize operation completed for file# 1, old size 727040K, new size 737280K

Resize operation completed for file# 3, old size 455680K, new size 460800K

Thread 1 cannot allocate new log, sequence 13

Checkpoint not complete

Current log# 3 seq# 12 mem# 0: G:\ORADATA\company\REDO03.LOG

Resize operation completed for file# 201, old size 20480K, new size 21504K

Resize operation completed for file# 201, old size 21504K, new size 22528K

Resize operation completed for file# 201, old size 22528K, new size 23552K

Resize operation completed for file# 201, old size 23552K, new size 24576K

Resize operation completed for file# 201, old size 24576K, new size 25600K

Resize operation completed for file# 201, old size 25600K, new size 26624K

Resize operation completed for file# 201, old size 26624K, new size 27648K

Resize operation completed for file# 201, old size 27648K, new size 28672K

Resize operation completed for file# 201, old size 28672K, new size 29696K

Resize operation completed for file# 201, old size 29696K, new size 30720K

Resize operation completed for file# 201, old size 30720K, new size 31744K

Resize operation completed for file# 201, old size 31744K, new size 32768K

Resize operation completed for file# 201, old size 32768K, new size 33792K

Resize operation completed for file# 201, old size 33792K, new size 34816K

Resize operation completed for file# 201, old size 34816K, new size 35840K

Resize operation completed for file# 201, old size 35840K, new size 36864K

Resize operation completed for file# 201, old size 36864K, new size 37888K

Resize operation completed for file# 201, old size 37888K, new size 38912K

Resize operation completed for file# 201, old size 38912K, new size 39936K

Resize operation completed for file# 201, old size 39936K, new size 40960K

Resize operation completed for file# 201, old size 40960K, new size 41984K

Resize operation completed for file# 201, old size 41984K, new size 43008K

Resize operation completed for file# 201, old size 43008K, new size 44032K

Resize operation completed for file# 201, old size 44032K, new size 45056K

Resize operation completed for file# 201, old size 45056K, new size 46080K

Resize operation completed for file# 201, old size 46080K, new size 47104K

Resize operation completed for file# 201, old size 47104K, new size 48128K

Resize operation completed for file# 201, old size 48128K, new size 49152K

Resize operation completed for file# 201, old size 49152K, new size 50176K

Resize operation completed for file# 201, old size 50176K, new size 51200K

Resize operation completed for file# 201, old size 51200K, new size 52224K

Thread 1 cannot allocate new log, sequence 13

Private strand flush not complete

Current log# 3 seq# 12 mem# 0: G:\ORADATA\company\REDO03.LOG

Resize operation completed for file# 201, old size 52224K, new size 53248K

Thread 1 advanced to log sequence 13 (LGWR switch)

Current log# 1 seq# 13 mem# 0: G:\ORADATA\company\REDO01.LOG

Resize operation completed for file# 201, old size 53248K, new size 54272K

Resize operation completed for file# 201, old size 54272K, new size 55296K

Resize operation completed for file# 201, old size 55296K, new size 56320K

Resize operation completed for file# 201, old size 56320K, new size 57344K

Resize operation completed for file# 201, old size 57344K, new size 58368K

Resize operation completed for file# 201, old size 58368K, new size 59392K

Resize operation completed for file# 201, old size 59392K, new size 60416K

Resize operation completed for file# 201, old size 60416K, new size 61440K

Resize operation completed for file# 3, old size 460800K, new size 471040K

Resize operation completed for file# 201, old size 61440K, new size 62464K

Resize operation completed for file# 3, old size 471040K, new size 476160K

Resize operation completed for file# 3, old size 476160K, new size 486400K

Resize operation completed for file# 1, old size 737280K, new size 747520K

Resize operation completed for file# 3, old size 486400K, new size 491520K

Thread 1 cannot allocate new log, sequence 14

Checkpoint not complete

Current log# 1 seq# 13 mem# 0: G:\ORADATA\company\REDO01.LOG

Thread 1 cannot allocate new log, sequence 14

Private strand flush not complete

Current log# 1 seq# 13 mem# 0: G:\ORADATA\company\REDO01.LOG

Thread 1 advanced to log sequence 14 (LGWR switch)

Current log# 2 seq# 14 mem# 0: G:\ORADATA\company\REDO02.LOG

Resize operation completed for file# 1, old size 747520K, new size 757760K

Thread 1 cannot allocate new log, sequence 15

Checkpoint not complete

Current log# 2 seq# 14 mem# 0: G:\ORADATA\company\REDO02.LOG

Thread 1 advanced to log sequence 15 (LGWR switch)

Current log# 3 seq# 15 mem# 0: G:\ORADATA\company\REDO03.LOG

Resize operation completed for file# 1, old size 757760K, new size 768000K

Resize operation completed for file# 1, old size 768000K, new size 778240K

Resize operation completed for file# 3, old size 491520K, new size 501760K

Resize operation completed for file# 3, old size 501760K, new size 506880K

Resize operation completed for file# 3, old size 506880K, new size 517120K

Resize operation completed for file# 3, old size 517120K, new size 522240K

Thread 1 cannot allocate new log, sequence 16

Checkpoint not complete

Current log# 3 seq# 15 mem# 0: G:\ORADATA\company\REDO03.LOG

Resize operation completed for file# 1, old size 778240K, new size 788480K

Resize operation completed for file# 3, old size 522240K, new size 527360K

Thread 1 advanced to log sequence 16 (LGWR switch)

Current log# 1 seq# 16 mem# 0: G:\ORADATA\company\REDO01.LOG

Resize operation completed for file# 1, old size 788480K, new size 798720K

Resize operation completed for file# 1, old size 798720K, new size 808960K

Resize operation completed for file# 1, old size 808960K, new size 819200K

Resize operation completed for file# 1, old size 819200K, new size 829440K

Resize operation completed for file# 3, old size 527360K, new size 532480K

Resize operation completed for file# 1, old size 829440K, new size 839680K

Resize operation completed for file# 3, old size 532480K, new size 537600K

Resize operation completed for file# 1, old size 839680K, new size 849920K

Thread 1 cannot allocate new log, sequence 17

Checkpoint not complete

Current log# 1 seq# 16 mem# 0: G:\ORADATA\company\REDO01.LOG

Thread 1 advanced to log sequence 17 (LGWR switch)

Current log# 2 seq# 17 mem# 0: G:\ORADATA\company\REDO02.LOG

Resize operation completed for file# 3, old size 537600K, new size 547840K

Resize operation completed for file# 3, old size 547840K, new size 552960K

Resize operation completed for file# 3, old size 552960K, new size 558080K

Thread 1 cannot allocate new log, sequence 18

Checkpoint not complete

Current log# 2 seq# 17 mem# 0: G:\ORADATA\company\REDO02.LOG

Thread 1 cannot allocate new log, sequence 18

Private strand flush not complete

Current log# 2 seq# 17 mem# 0: G:\ORADATA\company\REDO02.LOG

Thread 1 advanced to log sequence 18 (LGWR switch)

Current log# 3 seq# 18 mem# 0: G:\ORADATA\company\REDO03.LOG

Resize operation completed for file# 3, old size 558080K, new size 563200K

Resize operation completed for file# 3, old size 563200K, new size 568320K

Resize operation completed for file# 2, old size 563200K, new size 573440K

Resize operation completed for file# 3, old size 568320K, new size 573440K

Resize operation completed for file# 3, old size 573440K, new size 578560K

Resize operation completed for file# 2, old size 573440K, new size 583680K

Resize operation completed for file# 3, old size 578560K, new size 588800K

Resize operation completed for file# 3, old size 588800K, new size 593920K

Resize operation completed for file# 2, old size 583680K, new size 593920K

Resize operation completed for file# 3, old size 593920K, new size 599040K

Resize operation completed for file# 2, old size 593920K, new size 604160K

Resize operation completed for file# 2, old size 604160K, new size 614400K

Resize operation completed for file# 2, old size 614400K, new size 624640K

Resize operation completed for file# 2, old size 624640K, new size 634880K

Resize operation completed for file# 2, old size 634880K, new size 645120K

Resize operation completed for file# 2, old size 645120K, new size 655360K

Resize operation completed for file# 2, old size 655360K, new size 665600K

Resize operation completed for file# 2, old size 665600K, new size 675840K

Resize operation completed for file# 3, old size 599040K, new size 604160K

Thread 1 cannot allocate new log, sequence 19

Checkpoint not complete

Current log# 3 seq# 18 mem# 0: G:\ORADATA\company\REDO03.LOG

Resize operation completed for file# 3, old size 604160K, new size 609280K

Thread 1 advanced to log sequence 19 (LGWR switch)

Current log# 1 seq# 19 mem# 0: G:\ORADATA\company\REDO01.LOG

Resize operation completed for file# 3, old size 609280K, new size 619520K

Resize operation completed for file# 3, old size 619520K, new size 624640K

Resize operation completed for file# 2, old size 675840K, new size 686080K

Resize operation completed for file# 3, old size 624640K, new size 629760K

Resize operation completed for file# 1, old size 849920K, new size 860160K

Resize operation completed for file# 1, old size 860160K, new size 870400K

AUD: OS Error = 1717 encountered while writing audit record

AUD: OS Error = 1717 encountered while writing audit record

AUD: OS Error = 1717 encountered while writing audit record

AUD: OS Error = 1717 encountered while writing audit record

AUD: OS Error = 1717 encountered while writing audit record

AUD: OS Error = 1717 encountered while writing audit record

Starting ORACLE instance (normal) (OS id: 11920)

CLI notifier numLatches:37 maxDescs:3194

All SGA segments were allocated at startup

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Initial number of CPU is 24

Number of processor cores in the system is 24

Number of processor sockets in the system is 24

Using LOG_ARCHIVE_DEST_1 parameter default value as c:\app\db\product\12.2.0\dbhome_1\RDBMS

Autotune of undo retention is turned on.

IMODE=BR

ILAT =319

LICENSE_MAX_USERS = 0

SYS auditing is enabled

NOTE: remote asm mode is local (mode 0x1; from cluster type)

NOTE: Using default ASM root directory ASM

NOTE: Cluster configuration type = NONE [2]

NUMA system with 2 nodes detected

Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production.

Windows NT Version V6.2
ORACLE_HOME = c:\app\db\product\12.2.0\dbhome_1
Node name : db4
CPU : 24 - type 8664, 24 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:32688M/183599M, Ph+PgF:51

VM name : VMWare Version (6)

Using parameter settings in client-side pfile C:\APP\db\ADMIN\company\PFILE\INIT.ORA on machine db4

System parameters with non-default values:

processes = 1920

nls_language = AMERICAN

nls_territory = AMERICA

sga_target = 24192M

control_files = G:\ORADATA\company\CONTROL01.CTL

control_files = G:\ORADATA\company\CONTROL02.CTL

db_block_size = 8192

compatible = 12.2.0

undo_tablespace = UNDOTBS1

remote_login_passwordfile= EXCLUSIVE

dispatchers = (PROTOCOL=TCP) (SERVICE=companyXDB)

local_listener = LISTENER_company

audit_file_dest = C:\APP\db\ADMIN\company\ADUMP

audit_trail = DB

db_name = company

open_cursors = 300

pga_aggregate_target = 8047M

diagnostic_dest = C:\APP\db

NOTE: remote asm mode is local (mode 0x1; from cluster type)

============================================================

NOTE: PatchLevel of this instance 0

============================================================

Starting background process PMON

PMON started with pid=2, OS id=13520

Starting background process CLMN

CLMN started with pid=3, OS id=13524

Starting background process PSP0

PSP0 started with pid=4, OS id=13528

Starting background process VKTM

VKTM started with pid=5, OS id=13548 at elevated (Time Critical) priority

Starting background process GEN0

VKTM running at (5)millisec precision with DBRM quantum (100)ms

GEN0 started with pid=6, OS id=13552

Starting background process MMAN

MMAN started with pid=7, OS id=13564

Starting background process GEN1

GEN1 started with pid=9, OS id=13572

Starting background process DIAG

DIAG started with pid=10, OS id=13584

Starting background process OFSD

OFSD started with pid=11, OS id=13596

Starting background process DBRM

Oracle running with ofslib:'щ' version=2

DBRM started with pid=12, OS id=13600

Starting background process VKRM

VKRM started with pid=8, OS id=13604

Starting background process SVCB

SVCB started with pid=11, OS id=13608

Starting background process PMAN

PMAN started with pid=13, OS id=13620

Starting background process DIA0

DIA0 started with pid=14, OS id=13624

Starting background process DBW0

Using default pga_aggregate_limit of 16094 MB

DBW0 started with pid=15, OS id=13628

Starting background process DBW1

DBW1 started with pid=16, OS id=13632

Starting background process DBW2

DBW2 started with pid=17, OS id=13644

Starting background process LGWR

LGWR started with pid=18, OS id=13648

Starting background process CKPT

CKPT started with pid=19, OS id=13664

LGWR slave LG00 created with pid=20, OS pid=13668

Starting background process SMON

SMON started with pid=21, OS id=13672

LGWR slave LG01 created with pid=22, OS pid=13676

Starting background process SMCO

SMCO started with pid=23, OS id=13708

Starting background process RECO

RECO started with pid=24, OS id=13712

Starting background process LREG

LREG started with pid=26, OS id=13720

Starting background process PXMN

PXMN started with pid=28, OS id=13728

FENC started with pid=29, OS id=13732

Starting background process FENC

Starting background process MMON

MMON started with pid=30, OS id=13736

Starting background process MMNL

MMNL started with pid=31, OS id=13752

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

starting up 1 shared server(s) ...

Starting background process TMON

TMON started with pid=34, OS id=13764

ORACLE_BASE from environment = c:\app\db

ALTER DATABASE MOUNT

Network throttle feature is disabled as mount time

Successful mount of redo thread 1, with mount id 3274177745

Database mounted in Exclusive Mode

Lost write protection disabled

Using STANDBY_ARCHIVE_DEST parameter default value as c:\app\db\product\12.2.0\dbhome_1\RDBMS

Completed: ALTER DATABASE MOUNT

ALTER DATABASE OPEN

Ping without log force is disabled:

instance mounted in exclusive mode.

Buffer Cache Full DB Caching mode changing from FULL CACHING DISABLED to FULL CACHING ENABLED

Beginning crash recovery of 1 threads

Started redo scan

Completed redo scan

read 5288 KB redo, 374 data blocks need recovery

Started redo application at

Thread 1: logseq 19, block 162485, offset 0

Recovery of Online Redo Log: Thread 1 Group 1 Seq 19 Reading mem 0

Mem# 0: G:\ORADATA\company\REDO01.LOG

Completed redo application of 2.37MB

Completed crash recovery at

Thread 1: RBA 19.173061.16, nab 173061, scn 0x00000000000a36cb

374 data blocks read, 374 data blocks written, 5288 redo k-bytes read

Endian type of dictionary set to little

TT00: Gap Manager starting (PID:13860)

Thread 1 advanced to log sequence 20 (thread open)

Thread 1 opened at log sequence 20

Current log# 2 seq# 20 mem# 0: G:\ORADATA\company\REDO02.LOG

Successful open of redo thread 1

[13856] Successfully onlined Undo Tablespace 2.

Undo initialization finished serial:0 start:38610843 end:38611187 diff:344 ms (0.3 seconds)

Verifying minimum file header compatibility for tablespace encryption..

Verifying file header compatibility for tablespace encryption completed for pdb 0

Database Characterset is CL8MSWIN1251

Opening with Resource Manager plan: DEFAULT_PLAN

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process AQPC

AQPC started with pid=38, OS id=13944

Starting background process CJQ0

CJQ0 started with pid=39, OS id=13968

Completed: ALTER DATABASE OPEN

Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into table

ORA-06512: at SYS.DBMS_QOPATCH, line 781

ORA-06512: at SYS.DBMS_QOPATCH, line 868

ORA-06512: at SYS.DBMS_QOPATCH, line 2219

ORA-06512: at SYS.DBMS_QOPATCH, line 744

ORA-06512: at SYS.DBMS_QOPATCH, line 2244

===========================================================

Dumping current patch information

===========================================================

Unable to obtain current patch information due to error: 20001

===========================================================

The spfile name is ?=\DATABASE\SPFILE%ORACLE_SID%.ORA

The spfile name is ?=\DATABASE\SPFILE%ORACLE_SID%.ORA

Shutting down instance (immediate) (OS id: 13856)

Stopping background process SMCO

Shutting down instance: further logons disabled

Stopping background process CJQ0

Stopping background process MMNL

Stopping background process MMON

License high water mark = 18

Dispatchers and shared servers shutdown

ALTER DATABASE CLOSE NORMAL

Stopping Emon pool

Stopping Emon pool

Shutting down archive processes

TT00: Gap Manager exiting (PID:13860)

Archiving is disabled

Thread 1 closed at log sequence 20

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

JIT: pid 1884 requesting stop

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Stopping background process VKTM

JIT: pid 1884 requesting stop

Instance shutdown complete (OS id: 13856)

Starting ORACLE instance (normal) (OS id: 13216)

CLI notifier numLatches:37 maxDescs:3194

All SGA segments were allocated at startup

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Initial number of CPU is 24

Number of processor cores in the system is 24

Number of processor sockets in the system is 24

Using LOG_ARCHIVE_DEST_1 parameter default value as c:\app\db\product\12.2.0\dbhome_1\RDBMS

Autotune of undo retention is turned on.

IMODE=BR

ILAT =319

LICENSE_MAX_USERS = 0

SYS auditing is enabled

NOTE: remote asm mode is local (mode 0x1; from cluster type)

NOTE: Using default ASM root directory ASM

NOTE: Cluster configuration type = NONE [2]

NUMA system with 2 nodes detected

Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production.

Windows NT Version V6.2
ORACLE_HOME = c:\app\db\product\12.2.0\dbhome_1
Node name : db4
CPU : 24 - type 8664, 24 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:33750M/183599M, Ph+PgF:51

VM name : VMWare Version (6)

Using parameter settings in server-side spfile C:\APP\db\PRODUCT\12.2.0\DBHOME_1\DATABASE\SPFILEcompany.ORA

System parameters with non-default values:

processes = 1920

nls_language = AMERICAN

nls_territory = AMERICA

sga_target = 24192M

control_files = G:\ORADATA\company\CONTROL01.CTL

control_files = G:\ORADATA\company\CONTROL02.CTL

db_block_size = 8192

compatible = 12.2.0

undo_tablespace = UNDOTBS1

remote_login_passwordfile= EXCLUSIVE

dispatchers = (PROTOCOL=TCP) (SERVICE=companyXDB)

local_listener = LISTENER_company

audit_file_dest = C:\APP\db\ADMIN\company\ADUMP

audit_trail = DB

db_name = company

open_cursors = 300

pga_aggregate_target = 8047M

diagnostic_dest = C:\APP\db

NOTE: remote asm mode is local (mode 0x1; from cluster type)

============================================================

NOTE: PatchLevel of this instance 0

============================================================

Starting background process PMON

PMON started with pid=2, OS id=11372

Starting background process CLMN

CLMN started with pid=3, OS id=12808

Starting background process PSP0

PSP0 started with pid=4, OS id=5304

Starting background process VKTM

VKTM started with pid=5, OS id=12976 at elevated (Time Critical) priority

Starting background process GEN0

VKTM running at (5)millisec precision with DBRM quantum (100)ms

GEN0 started with pid=6, OS id=10620

Starting background process MMAN

MMAN started with pid=7, OS id=13732

Starting background process GEN1

GEN1 started with pid=9, OS id=8636

Starting background process DIAG

DIAG started with pid=10, OS id=12832

Starting background process OFSD

OFSD started with pid=11, OS id=14172

Starting background process DBRM

Oracle running with ofslib:'щ' version=2

DBRM started with pid=12, OS id=14308

Starting background process VKRM

VKRM started with pid=11, OS id=12464

Starting background process SVCB

SVCB started with pid=13, OS id=11016

Starting background process PMAN

PMAN started with pid=14, OS id=10704

Starting background process DIA0

DIA0 started with pid=15, OS id=11628

Starting background process DBW0

DBW0 started with pid=16, OS id=13408

Starting background process DBW1

DBW1 started with pid=17, OS id=10964

Starting background process DBW2

DBW2 started with pid=18, OS id=14008

Starting background process LGWR

LGWR started with pid=19, OS id=11284

Starting background process CKPT

CKPT started with pid=20, OS id=14268

LGWR slave LG00 created with pid=21, OS pid=14276

Starting background process SMON

SMON started with pid=22, OS id=13964

LGWR slave LG01 created with pid=23, OS pid=11328

Starting background process SMCO

SMCO started with pid=24, OS id=14076

Starting background process RECO

RECO started with pid=25, OS id=14064

Starting background process LREG

LREG started with pid=27, OS id=14108

Starting background process PXMN

PXMN started with pid=29, OS id=14112

Starting background process FENC

FENC started with pid=30, OS id=13144

Starting background process MMON

MMON started with pid=31, OS id=12956

Starting background process MMNL

MMNL started with pid=32, OS id=13580

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

starting up 1 shared server(s) ...

Starting background process TMON

TMON started with pid=35, OS id=12456

ORACLE_BASE from environment = c:\app\db

Using default pga_aggregate_limit of 16094 MB

ALTER DATABASE MOUNT

Network throttle feature is disabled as mount time

Successful mount of redo thread 1, with mount id 3274171849

Database mounted in Exclusive Mode

Lost write protection disabled

Using STANDBY_ARCHIVE_DEST parameter default value as c:\app\db\product\12.2.0\dbhome_1\RDBMS

Completed: ALTER DATABASE MOUNT

ALTER DATABASE OPEN

Ping without log force is disabled:

instance mounted in exclusive mode.

Buffer Cache Full DB Caching mode changing from FULL CACHING DISABLED to FULL CACHING ENABLED

Endian type of dictionary set to little

TT00: Gap Manager starting (PID:4484)

Thread 1 opened at log sequence 20

Current log# 2 seq# 20 mem# 0: G:\ORADATA\company\REDO02.LOG

Successful open of redo thread 1

[2268] Successfully onlined Undo Tablespace 2.

Undo initialization finished serial:0 start:39114515 end:39114812 diff:297 ms (0.3 seconds)

Verifying minimum file header compatibility for tablespace encryption..

Verifying file header compatibility for tablespace encryption completed for pdb 0

Database Characterset is CL8MSWIN1251

Opening with Resource Manager plan: DEFAULT_PLAN

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process AQPC

AQPC started with pid=38, OS id=11436

Starting background process CJQ0

CJQ0 started with pid=39, OS id=13616

Completed: ALTER DATABASE OPEN

Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into table

ORA-06512: at SYS.DBMS_QOPATCH, line 781

ORA-06512: at SYS.DBMS_QOPATCH, line 868

ORA-06512: at SYS.DBMS_QOPATCH, line 2219

ORA-06512: at SYS.DBMS_QOPATCH, line 744

ORA-06512: at SYS.DBMS_QOPATCH, line 2244

===========================================================

Dumping current patch information

===========================================================

Unable to obtain current patch information due to error: 20001

===========================================================

ALTER TABLESPACE USERS
ADD DATAFILE 'G:\ORADATA\company\USERS02.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

Completed: ALTER TABLESPACE USERS
ADD DATAFILE 'G:\ORADATA\company\USERS02.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

ALTER TABLESPACE USERS
ADD DATAFILE 'G:\ORADATA\company\USERS03.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

Completed: ALTER TABLESPACE USERS
ADD DATAFILE 'G:\ORADATA\company\USERS03.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

ALTER TABLESPACE USERS
ADD DATAFILE 'G:\ORADATA\company\USERS04.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

Completed: ALTER TABLESPACE USERS
ADD DATAFILE 'G:\ORADATA\company\USERS04.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

ALTER TABLESPACE USERS
ADD DATAFILE 'G:\ORADATA\company\USERS05.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

Completed: ALTER TABLESPACE USERS
ADD DATAFILE 'G:\ORADATA\company\USERS05.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

Resize operation completed for file# 2, old size 686080K, new size 716800K

CREATE TABLESPACE INDX DATAFILE
'g:\oradata\company\INDX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON

Completed: CREATE TABLESPACE INDX DATAFILE
'g:\oradata\company\INDX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON

ALTER TABLESPACE INDX
ADD DATAFILE 'G:\ORADATA\company\INDX02.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

Completed: ALTER TABLESPACE INDX
ADD DATAFILE 'G:\ORADATA\company\INDX02.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

ALTER TABLESPACE INDX
ADD DATAFILE 'G:\ORADATA\company\INDX03.DBF'
SIZE 1M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

Completed: ALTER TABLESPACE INDX
ADD DATAFILE 'G:\ORADATA\company\INDX03.DBF'
SIZE 1M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

ALTER TABLESPACE INDX
ADD DATAFILE 'G:\ORADATA\company\INDX04.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

Completed: ALTER TABLESPACE INDX
ADD DATAFILE 'G:\ORADATA\company\INDX04.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

ALTER TABLESPACE INDX
ADD DATAFILE 'G:\ORADATA\company\INDX05.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

Completed: ALTER TABLESPACE INDX
ADD DATAFILE 'G:\ORADATA\company\INDX05.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

ALTER TABLESPACE USERS
ADD DATAFILE 'G:\ORADATA\company\USERS06.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

Completed: ALTER TABLESPACE USERS
ADD DATAFILE 'G:\ORADATA\company\USERS06.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

ALTER TABLESPACE USERS
ADD DATAFILE 'G:\ORADATA\company\USERS07.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

Completed: ALTER TABLESPACE USERS
ADD DATAFILE 'G:\ORADATA\company\USERS07.DBF'
SIZE 10M
AUTOEXTEND ON
NEXT 1M
MAXSIZE UNLIMITED

Shared IO Pool defaulting to 512MB. Trying to get it from Buffer Cache for process 12876.

TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P201 (43516) VALUES LESS THAN (TO_DATE(' 2019-02-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P204 (43516) VALUES LESS THAN (TO_DATE(' 2019-02-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

Setting Resource Manager plan SCHEDULER[0x4A8F]:DEFAULT_MAINTENANCE_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

Resize operation completed for file# 2, old size 716800K, new size 727040K

Thread 1 cannot allocate new log, sequence 21

Private strand flush not complete

Current log# 2 seq# 20 mem# 0: G:\ORADATA\company\REDO02.LOG

Thread 1 advanced to log sequence 21 (LGWR switch)

Current log# 3 seq# 21 mem# 0: G:\ORADATA\company\REDO03.LOG

TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P205 (43517) VALUES LESS THAN (TO_DATE(' 2019-02-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P208 (43517) VALUES LESS THAN (TO_DATE(' 2019-02-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

Resize operation completed for file# 2, old size 727040K, new size 737280K

Closing scheduler window

Restoring Resource Manager plan DEFAULT_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_PLAN via parameter

Setting Resource Manager plan SCHEDULER[0x4A90]:DEFAULT_MAINTENANCE_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

Resize operation completed for file# 2, old size 737280K, new size 747520K

TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P209 (43518) VALUES LESS THAN (TO_DATE(' 2019-02-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P212 (43518) VALUES LESS THAN (TO_DATE(' 2019-02-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

Thread 1 advanced to log sequence 22 (LGWR switch)

Current log# 1 seq# 22 mem# 0: G:\ORADATA\company\REDO01.LOG

Resize operation completed for file# 2, old size 747520K, new size 757760K

Closing scheduler window

Restoring Resource Manager plan DEFAULT_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_PLAN via parameter

Setting Resource Manager plan SCHEDULER[0x4A91]:DEFAULT_MAINTENANCE_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

Resize operation completed for file# 2, old size 757760K, new size 768000K

Thread 1 cannot allocate new log, sequence 23

Private strand flush not complete

Current log# 1 seq# 22 mem# 0: G:\ORADATA\company\REDO01.LOG

Thread 1 advanced to log sequence 23 (LGWR switch)

Current log# 2 seq# 23 mem# 0: G:\ORADATA\company\REDO02.LOG

Resize operation completed for file# 2, old size 768000K, new size 778240K

Thread 1 advanced to log sequence 24 (LGWR switch)

Current log# 3 seq# 24 mem# 0: G:\ORADATA\company\REDO03.LOG

Resize operation completed for file# 2, old size 778240K, new size 788480K

TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P213 (43519) VALUES LESS THAN (TO_DATE(' 2019-02-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P216 (43519) VALUES LESS THAN (TO_DATE(' 2019-02-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

Resize operation completed for file# 2, old size 788480K, new size 798720K

Closing scheduler window

Restoring Resource Manager plan DEFAULT_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_PLAN via parameter

Setting Resource Manager plan SCHEDULER[0x4A92]:DEFAULT_MAINTENANCE_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

Thread 1 advanced to log sequence 25 (LGWR switch)

Current log# 1 seq# 25 mem# 0: G:\ORADATA\company\REDO01.LOG

Resize operation completed for file# 2, old size 798720K, new size 808960K

Resize operation completed for file# 2, old size 808960K, new size 819200K

Thread 1 advanced to log sequence 26 (LGWR switch)

Current log# 2 seq# 26 mem# 0: G:\ORADATA\company\REDO02.LOG

Resize operation completed for file# 2, old size 819200K, new size 829440K

TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P217 (43520) VALUES LESS THAN (TO_DATE(' 2019-02-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P220 (43520) VALUES LESS THAN (TO_DATE(' 2019-02-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

Resize operation completed for file# 2, old size 829440K, new size 839680K

Closing scheduler window

Restoring Resource Manager plan DEFAULT_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_PLAN via parameter

Thread 1 advanced to log sequence 27 (LGWR switch)

Current log# 3 seq# 27 mem# 0: G:\ORADATA\company\REDO03.LOG

Setting Resource Manager plan SCHEDULER[0x4A8C]:DEFAULT_MAINTENANCE_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

Resize operation completed for file# 2, old size 839680K, new size 849920K

TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P221 (43521) VALUES LESS THAN (TO_DATE(' 2019-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P224 (43521) VALUES LESS THAN (TO_DATE(' 2019-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

Closing scheduler window

Restoring Resource Manager plan DEFAULT_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_PLAN via parameter

Resize operation completed for file# 2, old size 849920K, new size 860160K

Setting Resource Manager plan SCHEDULER[0x4A8D]:DEFAULT_MAINTENANCE_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

Thread 1 cannot allocate new log, sequence 28

Private strand flush not complete

Current log# 3 seq# 27 mem# 0: G:\ORADATA\company\REDO03.LOG

Thread 1 advanced to log sequence 28 (LGWR switch)

Current log# 1 seq# 28 mem# 0: G:\ORADATA\company\REDO01.LOG

Resize operation completed for file# 2, old size 860160K, new size 870400K

TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P225 (43522) VALUES LESS THAN (TO_DATE(' 2019-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P228 (43522) VALUES LESS THAN (TO_DATE(' 2019-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

Closing scheduler window

Restoring Resource Manager plan DEFAULT_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_PLAN via parameter

Resize operation completed for file# 2, old size 870400K, new size 880640K



***********************************************************************


Fatal NI connect error 12170.


VERSION INFORMATION:
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production

Time: 27-FEB-2019 14:40:55

Tracing not turned on.

Tns error struct:

ns main err code: 12535



TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505



TNS-00505: Operation timed out

nt secondary err code: 60

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=______________)(PORT=_______))

JIT: pid 1884 requesting full stop

Shutting down instance (immediate) (OS id: 22604)

Stopping background process SMCO

Shutting down instance: further logons disabled

Stopping background process CJQ0

Stopping background process MMNL

Stopping background process MMON

License high water mark = 12

Dispatchers and shared servers shutdown

ALTER DATABASE CLOSE NORMAL

Stopping Emon pool

Stopping Emon pool

Shutting down archive processes

TT00: Gap Manager exiting (PID:4484)

Archiving is disabled

Thread 1 closed at log sequence 28

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

JIT: pid 1884 requesting stop

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

JIT: pid 1884 requesting stop

Stopping background process VKTM

Instance shutdown complete (OS id: 22604)

Starting ORACLE instance (normal) (OS id: 24864)

CLI notifier numLatches:37 maxDescs:3194

All SGA segments were allocated at startup

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Initial number of CPU is 24

Number of processor cores in the system is 24

Number of processor sockets in the system is 24

Using LOG_ARCHIVE_DEST_1 parameter default value as c:\app\db\product\12.2.0\dbhome_1\RDBMS

Autotune of undo retention is turned on.

IMODE=BR

ILAT =319

LICENSE_MAX_USERS = 0

SYS auditing is enabled

NOTE: remote asm mode is local (mode 0x1; from cluster type)

NOTE: Using default ASM root directory ASM

NOTE: Cluster configuration type = NONE [2]

NUMA system with 2 nodes detected

Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production.

Windows NT Version V6.2
ORACLE_HOME = c:\app\db\product\12.2.0\dbhome_1
Node name : db4
CPU : 24 - type 8664, 24 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:27044M/183599M, Ph+PgF:37

VM name : VMWare Version (6)

Using parameter settings in server-side spfile C:\APP\db\PRODUCT\12.2.0\DBHOME_1\DATABASE\SPFILEcompany.ORA

System parameters with non-default values:

processes = 1920

nls_language = AMERICAN

nls_territory = AMERICA

sga_target = 24192M

control_files = G:\ORADATA\company\CONTROL01.CTL

control_files = G:\ORADATA\company\CONTROL02.CTL

db_block_size = 8192

compatible = 12.2.0

undo_tablespace = UNDOTBS1

remote_login_passwordfile= EXCLUSIVE

dispatchers = (PROTOCOL=TCP) (SERVICE=companyXDB)

local_listener = LISTENER_company

audit_file_dest = C:\APP\db\ADMIN\company\ADUMP

audit_trail = DB

db_name = company

open_cursors = 300

pga_aggregate_target = 8047M

diagnostic_dest = C:\APP\db

NOTE: remote asm mode is local (mode 0x1; from cluster type)

============================================================

NOTE: PatchLevel of this instance 0

============================================================

Starting background process PMON

PMON started with pid=2, OS id=13624

Starting background process CLMN

CLMN started with pid=3, OS id=16660

Starting background process PSP0

PSP0 started with pid=4, OS id=22396

Starting background process VKTM

VKTM started with pid=5, OS id=18272 at elevated (Time Critical) priority

VKTM running at (5)millisec precision with DBRM quantum (100)ms

Starting background process GEN0

GEN0 started with pid=6, OS id=16028

Starting background process MMAN

MMAN started with pid=7, OS id=20064

Starting background process GEN1

GEN1 started with pid=9, OS id=15928

Starting background process DIAG

DIAG started with pid=10, OS id=12136

Starting background process OFSD

OFSD started with pid=11, OS id=17248

Starting background process DBRM

Oracle running with ofslib:'щ' version=2

DBRM started with pid=12, OS id=15972

Starting background process VKRM

VKRM started with pid=11, OS id=22280

Starting background process SVCB

SVCB started with pid=13, OS id=25340

Starting background process PMAN

PMAN started with pid=14, OS id=18636

Starting background process DIA0

DIA0 started with pid=15, OS id=6812

Starting background process DBW0

DBW0 started with pid=16, OS id=15164

Starting background process DBW1

DBW1 started with pid=17, OS id=22736

Starting background process DBW2

DBW2 started with pid=18, OS id=12076

Starting background process LGWR

LGWR started with pid=19, OS id=5972

Starting background process CKPT

CKPT started with pid=20, OS id=764

LGWR slave LG00 created with pid=21, OS pid=12864

Starting background process SMON

SMON started with pid=22, OS id=6460

LGWR slave LG01 created with pid=23, OS pid=22320

Starting background process SMCO

SMCO started with pid=24, OS id=10452

Starting background process RECO

RECO started with pid=25, OS id=18712

Starting background process LREG

LREG started with pid=27, OS id=4484

Starting background process PXMN

PXMN started with pid=29, OS id=15044

Starting background process FENC

FENC started with pid=30, OS id=18688

Starting background process MMON

MMON started with pid=31, OS id=21308

Starting background process MMNL

MMNL started with pid=32, OS id=8848

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

starting up 1 shared server(s) ...

Starting background process TMON

TMON started with pid=35, OS id=21600

ORACLE_BASE from environment = c:\app\db

Using default pga_aggregate_limit of 16094 MB

ALTER DATABASE MOUNT

Network throttle feature is disabled as mount time

Successful mount of redo thread 1, with mount id 3274759341

Database mounted in Exclusive Mode

Lost write protection disabled

Using STANDBY_ARCHIVE_DEST parameter default value as c:\app\db\product\12.2.0\dbhome_1\RDBMS

Completed: ALTER DATABASE MOUNT

ALTER DATABASE OPEN

Ping without log force is disabled:

instance mounted in exclusive mode.

Buffer Cache Full DB Caching mode changing from FULL CACHING DISABLED to FULL CACHING ENABLED

Endian type of dictionary set to little

TT00: Gap Manager starting (PID:25068)

Thread 1 opened at log sequence 28

Current log# 1 seq# 28 mem# 0: G:\ORADATA\company\REDO01.LOG

Successful open of redo thread 1

[16804] Successfully onlined Undo Tablespace 2.

Undo initialization finished serial:0 start:643238296 end:643238843 diff:547 ms (0.5 seconds)

Verifying minimum file header compatibility for tablespace encryption..

Verifying file header compatibility for tablespace encryption completed for pdb 0

Database Characterset is CL8MSWIN1251

Opening with Resource Manager plan: DEFAULT_PLAN

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process AQPC

AQPC started with pid=38, OS id=20024

Starting background process CJQ0

CJQ0 started with pid=39, OS id=3716

Completed: ALTER DATABASE OPEN

ORA-25253 encountered when generating server alert SMG-4120

ORA-25253 encountered when generating server alert SMG-4121

===========================================================

Dumping current patch information

===========================================================

No patches have been applied

===========================================================

ORA-25253 encountered when generating server alert SMG-4120

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4120

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4120

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4120

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4120

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4120

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4120

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4120

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121



***********************************************************************


Fatal NI connect error 12170.


VERSION INFORMATION:
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production

Time: 28-FEB-2019 12:04:52

Tracing not turned on.

Tns error struct:

ns main err code: 12535



TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505



TNS-00505: Operation timed out

nt secondary err code: 60

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=65294))

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121



***********************************************************************


Fatal NI connect error 12170.


VERSION INFORMATION:
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production

Time: 28-FEB-2019 13:07:19

Tracing not turned on.

Tns error struct:

ns main err code: 12535



TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505



TNS-00505: Operation timed out

nt secondary err code: 60

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=58549))

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121



***********************************************************************


Fatal NI connect error 12170.


VERSION INFORMATION:
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production

Time: 28-FEB-2019 13:32:47

Tracing not turned on.

Tns error struct:

ns main err code: 12535



TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505



TNS-00505: Operation timed out

nt secondary err code: 60

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=58552))

ORA-25253 encountered when generating server alert SMG-4121



***********************************************************************


Fatal NI connect error 12170.


VERSION INFORMATION:
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production

Time: 28-FEB-2019 13:40:55

Tracing not turned on.

Tns error struct:

ns main err code: 12535



TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505



TNS-00505: Operation timed out

nt secondary err code: 60

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=60079))



***********************************************************************


Fatal NI connect error 12170.


VERSION INFORMATION:
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production

Time: 28-FEB-2019 13:40:56

Tracing not turned on.

Tns error struct:

ns main err code: 12535



TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505



TNS-00505: Operation timed out

nt secondary err code: 60

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=60080))

ORA-25253 encountered when generating server alert SMG-4121



***********************************************************************


Fatal NI connect error 12170.


VERSION INFORMATION:
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production

Time: 28-FEB-2019 13:44:41

Tracing not turned on.

Tns error struct:

ns main err code: 12535



TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505



TNS-00505: Operation timed out

nt secondary err code: 60

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=60117))

ORA-25253 encountered when generating server alert SMG-4121



***********************************************************************


Fatal NI connect error 12170.


VERSION INFORMATION:
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production

Time: 28-FEB-2019 13:49:45

Tracing not turned on.

Tns error struct:

ns main err code: 12535



TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505



TNS-00505: Operation timed out

nt secondary err code: 60

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=59002))

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4120

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121



***********************************************************************


Fatal NI connect error 12170.


VERSION INFORMATION:
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production

Time: 28-FEB-2019 14:05:23

Tracing not turned on.

Tns error struct:

ns main err code: 12535



TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505



TNS-00505: Operation timed out

nt secondary err code: 60

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=60355))

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4120

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4120

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121



***********************************************************************


Fatal NI connect error 12170.


VERSION INFORMATION:
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production

Time: 28-FEB-2019 16:41:39

Tracing not turned on.

Tns error struct:

ns main err code: 12535



TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505



TNS-00505: Operation timed out

nt secondary err code: 60

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=49328))

ORA-25253 encountered when generating server alert SMG-4121



***********************************************************************


Fatal NI connect error 12170.


VERSION INFORMATION:
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production

Time: 28-FEB-2019 16:42:45

Tracing not turned on.

Tns error struct:

ns main err code: 12535



TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505



TNS-00505: Operation timed out

nt secondary err code: 60

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=49348))

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121



***********************************************************************


Fatal NI connect error 12170.


VERSION INFORMATION:
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 12.2.0.1.0 - Production

Time: 28-FEB-2019 17:01:51

Tracing not turned on.

Tns error struct:

ns main err code: 12535



TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505



TNS-00505: Operation timed out

nt secondary err code: 60

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=49824))

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

Setting Resource Manager plan SCHEDULER[0x4A8F]:DEFAULT_MAINTENANCE_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P229 (43523) VALUES LESS THAN (TO_DATE(' 2019-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P232 (43523) VALUES LESS THAN (TO_DATE(' 2019-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4120

ORA-25253 encountered when generating server alert SMG-4121

TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P233 (43524) VALUES LESS THAN (TO_DATE(' 2019-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P236 (43524) VALUES LESS THAN (TO_DATE(' 2019-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

ORA-25253 encountered when generating server alert SMG-4121

Thread 1 advanced to log sequence 29 (LGWR switch)

Current log# 2 seq# 29 mem# 0: G:\ORADATA\company\REDO02.LOG


ORA-25253 encountered when generating server alert SMG-4121

Closing scheduler window

Restoring Resource Manager plan DEFAULT_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_PLAN via parameter

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

TABLE AUDSYS.AUD$UNIFIED: ADDED INTERVAL PARTITION SYS_P237 (57) VALUES LESS THAN (TIMESTAMP' 2019-04-01 00:00:00')

ORA-25253 encountered when generating server alert SMG-4120

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

ORA-25253 encountered when generating server alert SMG-4121

Resize operation completed for file# 1, old size 870400K, new size 880640K

ORA-25253 encountered when generating server alert SMG-4120

ORA-25253 encountered when generating server alert SMG-4121

1 мар 19, 19:08    [21823049]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
flexgen
Member

Откуда: Город на песке
Сообщений: 683
teejay
flexgen,
На самом деле с экспортом такая же проблема как и с импортом.


Что возвращает

show parameter AQ_TM_PROCESSES
2 мар 19, 16:03    [21823347]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
flexgen
Member

Откуда: Город на песке
Сообщений: 683
flexgen
Что возвращает

show parameter AQ_TM_PROCESSES


И вдогонку - AQ_TM_PROCESSES
2 мар 19, 16:09    [21823350]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
teejay
Member

Откуда:
Сообщений: 10
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
4 мар 19, 14:28    [21824413]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
flexgen
Member

Откуда: Город на песке
Сообщений: 683
teejay
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1


Так, похоже что aq_tm_processes здесь ни причем.

Я правильно понимаю, база у тебя на сервере Windows стоит? И impdp ты запускаешь на этом же сервере? Или на другой машине?
tnsping к базе проходит?
Посмотри что написано в файле C:\Windows\System32\drivers\etc\hosts на той машине, с которой запускается impdp и expdp и добавь туда строку такого вида (IP адрес и имя сервера подставь свои):
192.168.1.1 mydbserver

Потом попробуй запустить impdp еще раз.
4 мар 19, 20:23    [21824807]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
-2-
Member

Откуда:
Сообщений: 14420
flexgen
tnsping к базе проходит?
Ага, на винде ORA- без коннекта через форточку прилетает.
4 мар 19, 20:32    [21824812]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
Тролин
Member

Откуда:
Сообщений: 293
teejay,
В каком состоянии обьеты в sys?
А эти?
[SRC PLSQL]
OWNER OBJECT_NAME OBJECT_TYPE
---------- ------------------------------ ---------------
SYS KU$_M_VIEW_H_VIEW VIEW
SYS KU$_ZM_VIEW_H_VIEW VIEW
SYS KU$_M_VIEW_PH_VIEW VIEW
SYS KU$_ZM_VIEW_PH_VIEW VIEW
SYS KU$_M_VIEW_FH_VIEW VIEW
SYS KU$_ZM_VIEW_FH_VIEW VIEW
SYS KU$_M_VIEW_PFH_VIEW VIEW
SYS KU$_ZM_VIEW_PFH_VIEW VIEW
SYS KU$_M_VIEW_IOT_VIEW VIEW
SYS KU$_ZM_VIEW_IOT_VIEW VIEW
SYS KU$_M_VIEW_PIOT_VIEW VIEW
SYS KU$_ZM_VIEW_PIOT_VIEW VIEW
SYS KU$_M_ZONEMAP_H_VIEW VIEW
SYS KU$_M_ZONEMAP_PH_VIEW VIEW
SYS KU$_M_ZONEMAP_FH_VIEW VIEW
SYS KU$_M_ZONEMAP_PFH_VIEW VIEW
SYS KU$_M_ZONEMAP_IOT_VIEW VIEW
SYS KU$_M_ZONEMAP_PIOT_VIEW VIEW
/SRC]

Бд патчилась?
4 мар 19, 22:03    [21824859]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
Тролин
Member

Откуда:
Сообщений: 293
Если задать принудительно имя джобу job_name= экспорт/импорт проходит?
4 мар 19, 22:08    [21824862]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
teejay
Member

Откуда:
Сообщений: 10
Тролин,
пробовал, не помогает.
5 мар 19, 10:24    [21825116]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
teejay
Member

Откуда:
Сообщений: 10
flexgen,

Да, всё верно.
tnsping выдаёт OK
К сожалению доступа к ОС нет, только к Ораклу.
Проблема с
ORA-21561: OID generation failed

была решена почти сразу, больше она не повторялась
(по заверению местного системного администратора, он отредактировал файл hosts должным образом но, к сожалению проверить самостоятельно пока нет возможности, поэтому просто верю на слово)
5 мар 19, 10:29    [21825122]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
teejay
Member

Откуда:
Сообщений: 10
Тролин,
Указанные view впорядке.
Есть некоторое количество объектов в статусе invlalid
+

OWNER OBJECT_NAME OBJECT_TYPE STATUS
SYS CDB_TAB_COLS_V$ VIEW INVALID
SYS CDB_TAB_COLS VIEW INVALID
SYS CDB_TAB_COLUMNS VIEW INVALID
SYS DBA_VIEWS_AE VIEW INVALID
SYS CDB_VIEWS VIEW INVALID
SYS CDB_VIEWS_AE VIEW INVALID
SYS USER_VIEWS_AE VIEW INVALID
SYS CDB_CONSTRAINTS VIEW INVALID
SYS DBA_NESTED_TABLE_COLS VIEW INVALID
SYS CDB_NESTED_TABLE_COLS VIEW INVALID
SYS DBA_PUBLISHED_COLUMNS VIEW INVALID
SYS CDB_PUBLISHED_COLUMNS VIEW INVALID
SYS USER_PUBLISHED_COLUMNS VIEW INVALID
SYS USER_TAB_COL_STATISTICS VIEW INVALID
SYS ALL_TAB_COL_STATISTICS VIEW INVALID
SYS CDB_TAB_COL_STATISTICS VIEW INVALID
SYS USER_PART_COL_STATISTICS VIEW INVALID
SYS ALL_PART_COL_STATISTICS VIEW INVALID
SYS DBA_PART_COL_STATISTICS VIEW INVALID
SYS CDB_PART_COL_STATISTICS VIEW INVALID
SYS USER_SUBPART_COL_STATISTICS VIEW INVALID
SYS ALL_SUBPART_COL_STATISTICS VIEW INVALID
SYS DBA_SUBPART_COL_STATISTICS VIEW INVALID
SYS CDB_SUBPART_COL_STATISTICS VIEW INVALID
SYS EXU8ASC VIEW INVALID
SYS EXU8ASCU VIEW INVALID
SYS EXU10ASC VIEW INVALID
SYS EXU10ASCU VIEW INVALID
SYS EXU8HST VIEW INVALID
SYS EXU8HSTU VIEW INVALID
SYS USER_TSTZ_TAB_COLS VIEW INVALID
SYS DBA_TSTZ_TAB_COLS VIEW INVALID
SYS CDB_TSTZ_TAB_COLS VIEW INVALID
SYS USER_TSTZ_TABLES VIEW INVALID
SYS DBA_TSTZ_TABLES VIEW INVALID
SYS CDB_TSTZ_TABLES VIEW INVALID
SYS SM$INTEGRITY_CONS VIEW INVALID
SYS CDB_RULES VIEW INVALID
SYS ALL_POLICY_GROUPS VIEW INVALID
SYS ALL_POLICY_CONTEXTS VIEW INVALID
SYS ALL_SEC_RELEVANT_COLS VIEW INVALID
SYS USER_SEC_RELEVANT_COLS VIEW INVALID
SYS ALL_POLICY_ATTRIBUTES VIEW INVALID
SYS ALL_AUDIT_POLICIES VIEW INVALID
SYS ALL_AUDIT_POLICY_COLUMNS VIEW INVALID
SYS ALL_QUEUE_TABLES VIEW INVALID
SYS CDB_QUEUES VIEW INVALID
SYS ALL_DEQUEUE_QUEUES VIEW INVALID
SYS DBA_QUEUE_PUBLISHERS VIEW INVALID
SYS CDB_QUEUE_PUBLISHERS VIEW INVALID
SYS ALL_QUEUE_PUBLISHERS VIEW INVALID
SYS USER_QUEUE_PUBLISHERS VIEW INVALID
SYS ALL_XS_APPLICABLE_OBJECTS VIEW INVALID
SYS MDX_ODBO_DIMENSIONS VIEW INVALID
SYS MDX_ODBO_FUNCTIONS VIEW INVALID
SYS MDX_ODBO_HIERARCHIES VIEW INVALID
SYS MDX_ODBO_LEVELS VIEW INVALID
SYS MDX_ODBO_MEASURES VIEW INVALID
SYS MDX_ODBO_PROPERTIES VIEW INVALID
SYS KUPC$_ADD_FILE TYPE BODY INVALID
SYS DBMS_IREFSTATS PACKAGE BODY INVALID
SYS XMLCHARACTERINPUTSTREAM TYPE BODY INVALID

Их recompile не помогает (
БД не патчилась.
5 мар 19, 11:19    [21825169]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
Vivat!San
Member

Откуда: Отсюда не возвращаются
Сообщений: 511
Перeпeчатка документов MOS нарушает как правила дaнного сайта так и договор пoддержки oracle. Покам прeдупреждeние, в следующий раз - бан.

SY
5 мар 19, 11:27    [21825174]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
Тролин
Member

Откуда:
Сообщений: 293
teejay, БД тестовая? нужно восстановить побитые обьекты для начала и потом дальше разбираться.

бэкап->

sql> @$ORACLE_HOME/rdbms/admin/catproc.sql

sql> @$ORACLE_HOME/rdbms/admin/utlrp.sql

После этого проверить состояние объектов, если есть поврежденные отписаться.
5 мар 19, 12:51    [21825281]     Ответить | Цитировать Сообщить модератору
 Re: Oracle 12 impdp ORA-31626 job does not exist  [new]
flexgen
Member

Откуда: Город на песке
Сообщений: 683
teejay
flexgen,

Да, всё верно.
tnsping выдаёт OK
К сожалению доступа к ОС нет, только к Ораклу.
Проблема с
ORA-21561: OID generation failed

была решена почти сразу, больше она не повторялась
(по заверению местного системного администратора, он отредактировал файл hosts должным образом но, к сожалению проверить самостоятельно пока нет возможности, поэтому просто верю на слово)


А импорт так и падает? С той же ошибкой?

ORA-31626: job does not exist
ORA-31637: cannot create job SYS_IMPORT_SCHEMA_01 for user SYS
ORA-06512: as "SYS.KUPV$FT", line 1140


А после ORA-06512 что-то еще было написано?
6 мар 19, 22:58    [21826819]     Ответить | Цитировать Сообщить модератору
Все форумы / Oracle Ответить