Fri. Apr 23rd, 2021

Problem Statement: At the time of Installing Oracle APEX, when I fired the @apexins APEX_SPACE APEX_SPACE TEMP /i/ command, I got the below error.

SQL> @apexins APEX_SPACE APEX_SPACE TEMP /i/ ...set_appun.sql
PL/SQL procedure successfully completed.
...set_ufrom_and_upgrade.sql
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Performing installation in multitenant container database in the background. The installation progress is spooled into apexins_cdb*.log files.
Please wait...
catcon::set_log_file_base_path: ALL catcon-related output will be written to [D:\apex\apexins_cdb_catcon_3764.lst]
catcon::set_log_file_base_path: catcon: See [D:\apex\apexins_cdb*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [D:\apex\apexins_cdb_*.lst] files for spool files, if any
catcon::validate_con_names: ORCLPDB is not open
catcon::get_affected_containers: Unexpected error returned by validate_con_names for default Container list
catcon::catconInit2: Unexpected error returned by get_affected_containers
Unexpected error encountered in catconInit2; exiting
Installation completed. Log files for each container can be found in:
apexins_cdb*.log
You can quickly scan for ORA errors or compilation errors by using a utility like grep:
grep ORA- *.log grep PLS- *.log

Solution: For solution of the above error, follow the steps as shown below:

Step 1: Connect to the Oracle Database and run the below command

SQL> select name,open_mode from v$pdbs;

The output will be as shown below

NAME          OPEN_MODE
----------   --------------------
PDBORCL       MIGRATE

Step 2: Run the below command to shutdown the database

SQL> shutdown immediate;

The output will be as shown below

Database closed.
Database dismounted.
ORACLE instance shut down.

Step 3: Check the status of the Pluggable Database, for that run the below command

SQL> STARTUP;

Thus, we will get the output as shown below

ORACLE instance started.
Total System Global Area  788529152 bytes
Fixed Size     2929352 bytes
Variable Size   541068600 bytes
Database Buffers   239075328 bytes
Redo Buffers     5455872 bytes
Database mounted.
Database opened.

Step 4: Now run the below command

SQL> select name,open_mode from v$pdbs;

The output will be as shown below

NAME          OPEN_MODE
----------   --------------------
PDBORCL       MOUNTED

Step 5: We need to start the pluggable database in upgrade state for which run the below command

SQL> SHUTDOWN IMMEDIATE;

The output will be as shown below

Database closed.
Database dismounted.
ORACLE instance shut down.

Step 5: Run the below SQL command to upgrade

SQL> STARTUP UPGRADE;

The output will be as shown below

ORACLE instance started.
Total System Global Area  788529152 bytes
Fixed Size     2929352 bytes
Variable Size   541068600 bytes
Database Buffers   239075328 bytes
Redo Buffers     5455872 bytes
Database mounted.
Database opened.

Step 6: Run the below command to upgrade the pluggable database

SQL> ALTER PLUGGABLE DATABASE ALL OPEN UPGRADE;

The output will be as shown below

Pluggable database altered.

Step 7: Now run the below command

SQL> select name,open_mode from v$pdbs;

The output will be as shown below

NAME          OPEN_MODE
----------   --------------------
PDBORCL       MIGRATE

Thus exit the window by running the below command

SQL> exit;

Hence, the solution to our requirement.

If you like the post please comment, share, and do join me on Facebook. Please subscribe to my YouTube Channel for video tutorials.

Thanks & Regards,
Susanto Paul

 266 total views,  7 views today

By Susanto Paul

Susanto is an Oracle ACE, a qualified MCA, MBA, and a highly-skilled Senior Oracle Specialist. He is an enthusiastic Blogger and YouTuber who helps learners to solve their complex problems more efficiently. He has 9+ years of experience in multiple technologies like AWS, Oracle ADF, Oracle APEX, Oracle JET, Oracle VBCS, Oracle IDCS, Oracle PL/SQL, Oracle Integration Cloud, Java, JDBC, Servlets, JSP, Spring, Hibernate, HTML5, CSS3, JavaScript, TypeScript, NodesJS, Angular, MySQL, Oracle WebLogic Server, JUnit, JMeter, Selenium Web Driver, etc. He is a certified: Oracle Certified Professional Java SE 6 Programmer, Oracle ADF 11g Certified Implementation Specialist, Oracle Cloud Platform Application Integration 2020 Certified Specialist, Oracle Cloud Infrastructure Foundations 2020 Certified Associate, and Oracle Cloud Infrastructure Developer 2020 Certified Associate

Leave a Reply

Your email address will not be published. Required fields are marked *