Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Enabling Extended Data Types on 12.2 on Windows

Craig HealeyApr 3 2018 — edited Apr 3 2018

Windows Server 2012 R2

Oracle 12.2

Following the instructions here: https://docs.oracle.com/database/121/REFRN/GUID-D424D23B-0933-425F-BC69-9C0E6724693C.htm#REFRN10321

There is 1 pluggable DB.

I have got the point where I run the catcon script, but it fails repeatedly at the same point.

ALTER SESSION SET CONTAINER=CDB$ROOT;

ALTER SYSTEM SET max_string_size=extended SCOPE=SPFILE;

SHUTDOWN IMMEDIATE

Using Oracle Instance Manager I started up the service and connected to SQLPlus

STARTUP UPGRADE

ALTER PLUGGABLE DATABASE ALL OPEN UPGRADE;

SQL> SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDBS;

NAME            OPEN_MODE  RESTRICTED OPEN_TIME

--------------- ---------- ---------- ------------------------------

PDB$SEED        MIGRATE    YES        03-APR-18 06.26.32.256 PM +02:

                                      00

ORCLPDB         MIGRATE    YES        03-APR-18 06.32.06.660 PM +02:

                                      00

EXIT;

d:\app\svc_oraclehome\product\12.2.0\dbhome_1\perl\bin\perl d:\app\svc_oraclehome\product\12.2.0\dbhome_1\rdbms\admin\catcon.pl -u SYS -d d:\app\svc_oraclehome\product\12.2.0\dbhome_1\rdbms\admin -l D:\app\scratch\utl32k_cdb_pdbs_output -b utl32k_cdb_pdbs_output utl32k.sql

catcon: ALL catcon-related output will be written to [D:\app\scratch\utl32k_cdb_pdbs_output/utl32k_cdb_pdbs_output_catco

n_3552.lst]

catcon: See [D:\app\scratch\utl32k_cdb_pdbs_output/utl32k_cdb_pdbs_output*.log] files for output generated by scripts

catcon: See [D:\app\scratch\utl32k_cdb_pdbs_output/utl32k_cdb_pdbs_output_*.lst] files for spool files, if any

Enter Password:

start_processes: failed to open (Resource temporarily unavailable) pipe to SQL*Plus

Unexpected error encountered in catconInit; exiting

PS D:\>

Any help would be appreciated

This post has been answered by Craig Healey on Apr 3 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2018
Added on Apr 3 2018
1 comment
709 views