Skip to Main Content

APEX

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!

apexins.sql took forever to run, then stopped at sys> prompt?

vfanJun 8 2015 — edited Jun 16 2015

Here's my story:

I installed Oracle 12C and uninstalled Apex from CDB, so I am now at a point installing Apex to my one and only one PDB.

I am in the correct directory of ORACLE_HOME\apex.  So, I ran

sql> @apexins.sql apex apex temp /i/

The script ran for about 2 hours and then stopped at a sys> prompt.  The last screenshot looks like this:

Completing registration process. 18:11:46

Validating installation.  18:40:52

...Database user "SYS", database schema "APEX_040200", user# "105" 18:40:53

...Compiled 0 out of 2998 objects considered, 0 failed compilation 18:41:00

...263 packages

...255 package bodies

...453 tables

...11 functions

...16 procedures

...3 sequences

...458 triggers

...1322 indexes

...207 views

...0 libraries

...6 types

...0 type bodies

...0 operators

...0 index types

...Begin key object existence check 18:41:00

...Completed key object existence check 18:41:01

...Setting DBMS Registry 18:41:01

...Setting DBMS Registry Complete 18:41:13

...Exiting validate 18:41:13

PL/SQL procedure successfully completed.

timing for: Validate Installation

Elapsed: 00:29:30.28

old   1: alter session set current_schema = ^APPUN

new   1: alter session set current_schema = APEX_040200

Session altered.

timing for: Complete Installation

Elapsed: 01:24:45.37

Session altered.

PL/SQL procedure successfully completed.

1 row selected.

...create null.sql

SYS>

// please note that I could not capture the entire message since it is in cmd

So, it is waiting for me the input or what?  Looks like I can type things.  But I thought I should wait for the sql> prompt to enter the @sqlchpwd.sql?

Am I missing something?

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2015
Added on Jun 8 2015
1 comment
484 views