Create Physical Standby Database Using 12.1 EM Cloud Contorl Fails with ORA-02017 (Doc ID 2105603.1)

Last updated on JULY 29, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.5.0 and later
Information in this document applies to any platform.

Symptoms

Create standby using 12c EM Cloud control fails with,


Database dismounted.
ORACLE instance shut down.
SQL> SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 24 21:30:52 2015

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

SQL> Connected to an idle instance.
SQL> ORACLE instance started.

Total System Global Area 8254390272 bytes
Fixed Size 7783824 bytes
Variable Size 1526729328 bytes
Database Buffers 6710886400 bytes
Redo Buffers 8990720 bytes
SQL> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 group 7 size 195312.5K,
*
ERROR at line 11:
ORA-02017: integer value required

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms