Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 111 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 475 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Can DB 18c XE, APEX 21.1 and ORDS 21.1 be installed on Windows 7 Professional?

Hi,
Can DB 18c XE, APEX 21.1 and ORDS 21.1 be installed on Windows 7 Professional?
Windows 7 Professional Service Pack 1 on a Dell Optiplex 990 CORE i5 vPro, 16 Gig RAM,
Searched and searched found nothing...
I've installed DB 18c XE successfully on Windows 7
installed APEX 21.1 in the XEPDB1 pluggable DB (1st time with multi-tenant) until the apex_rest_config.sql - got error "GetConsoleMode failed. LastError=[6]" in ReadKey.pm
called from concatExec in concat.pl
My 1st time installing in a multi-tenant database.
Should I switch to different versions ? Just trying to install for learning local install with the newest versions..
Thank you, Bill
Answers
-
Oracle 18c XE is certified on Windows 7 Pro:
So the DB is OK, then you need to confirm if APEX 21.1 is certified on 18c XE:
So you need to review the logs and maybe post more details, but APEX 21.1 should work on XE 18c
-
Thank you! This is the error I got.. I have tried many different ways.
C:\oraclexe\apex_21.1_en\apex>sqlplus / as sysdba
SQL> alter session set container=xepdb1;
Session altered.
SQL> @apex_rest_config.sql
PL/SQL procedure successfully completed.
About to run script[apex_rest_config_cdb.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 apex_rest_config_cdb*.log files.
Please wait...
catcon::set_log_file_base_path: ALL catcon-related output will be written to [C:\oraclexe\apex_21.1_en\apex\apex_rest_config_cdb_catcon_3572.lst]
catcon::set_log_file_base_path: catcon: See [C:\oraclexe\apex_21.1_en\apex\apex_rest_config_cdb*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [C:\oraclexe\apex_21.1_en\apex\apex_rest_config_cdb_*.lst] files for spool files, if any
catcon::catconExec_int: 'Enter:
GetConsoleMode failed, LastError=|6| at C:/Oracle/product/18.0.0/dbhomeXE/perl/site/lib/Term/ReadKey.pm line 334.
Installation completed. Log files for each container can be found in:
apex_rest_config_cdb*.log
You can quickly scan for ORA errors or compilation errors by using a utility
like grep:
grep ORA- *.log
grep PLS- *.log
SQL>
-
Have you already installed APEX?
Script you run should be run on as post-install task.
You find instructions to install APEX from below link
-
1.) cd c:\oraclexe\apex_21.1_en\apex
2.) sqlplus [email protected]:1521/XEPDB1 as sysdba
3.) SQL> alter session set container=xepdb1;
Session altered.
4.) Should only see PDB not CDB$ROOT
SQL> select CON_ID, name from v$pdbs; CON_ID NAME ---------- -------------------- 3 XEPDB1
5.) Create Tablespace specific for APEX Install.
SQL> CREATE TABLESPACE XX_APEX_TS DATAFILE 2 'C:\ORACLE\PRODUCT\18.0.0\ORADATA\XE\XEPDB1\APEX_02.dbf' 3 SIZE 200M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 1000M LOGGING 4 EXTENT MANAGEMENT LOCAL 5 SEGMENT SPACE MANAGEMENT AUTO; Tablespace created.
6.) VERIFIED IN CORRECT CON_ID
SQL> select * from v$tablespace order by 7,1; TS# NAME INC BIG FLA ENC CON_ID ---------- ------------------------------ --- --- --- --- ---------- 0 SYSTEM YES NO YES 3 1 SYSAUX YES NO YES 3 2 UNDOTBS1 YES NO YES 3 3 TEMP NO NO YES 3 5 USERS YES NO YES 3 6 XX_APEX_TS YES NO YES 3 6 rows selected.
7.) INSTALLED APEX
SQL> @apexins.sql XX_APEX_TS XX_APEX_TS 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... ...... . Application Express (APEX) Installation. ...set_appun.sql ... Checking prerequisites (MANUAL) . . SYSDBA Privilege . pass - Connection with SYSDBA privilege. . Database rolling upgrade . pass - No rolling upgrade. . DB components . pass - CATPROC: version=18.0.0.0.0 . pass - XDB: version=18.0.0.0.0 . XDB . pass - is valid . PL/SQL Web Toolkit . pass - version 11.2.0.0.1 . Tablespaces . pass - found XX_APEX_TS . pass - found XX_APEX_TS . pass - found TEMP . PHASES (1,2,3)... PL/SQL procedure successfully completed. ... Prerequisite checks passed. .... ....(more) .... # Actions in Phase 3: # ok 1 - BEGIN | 0.00 ok 2 - Computing Pub Syn Dependents | 0.00 ok 3 - Upgrade Hot Metadata and Switch Schemas | 0.00 ok 4 - Removing Jobs | 0.00 ok 5 - Creating Public Synonyms | 0.03 ok 6 - Granting Public Synonyms | 0.08 ok 7 - Granting to FLOWS_FILES | 0.00 ok 8 - Creating FLOWS_FILES grants and synonyms | 0.00 ok 9 - Creating Jobs | 0.00 ok 10 - Creating Dev Jobs | 0.00 ok 11 - Installing FLOWS_FILES Objects | 0.02 ok 12 - Installing APEX$SESSION Context | 0.00 ok 13 - Recompiling APEX_210100 | 0.02 ok 14 - Installing APEX REST Config | 0.00 ok 15 - Set Loaded/Upgraded in Registry | 1.03 ok 16 - Removing Unused SYS Objects | 0.00 ok 17 - Validating Installation | 0.07 ok 3 - 17 actions passed, 0 actions failed | 1.25 Thank you for installing Oracle Application Express 21.1.0 Oracle Application Express is installed in the APEX_210100 schema. The structure of the link to the Application Express administration services is as follows: http://host:port/ords/apex_admin The structure of the link to the Application Express development interface is as follows: http://host:port/ords timing for: Phase 3 (Switch) Elapsed: 00:01:15.13 timing for: Complete Installation Elapsed: 00:08:32.48 PL/SQL procedure successfully completed.
8.) VERIFY INSTALL
COL comp_name FOR A26 COL VERSION FOR A13 COL STATUS FOR A7 SELECT comp_name, version, status FROM dba_registry WHERE comp_id='APEX'; COMP_NAME VERSION STATUS -------------------------- ------------- ---------- Oracle Application Express 21.1.0 VALID SQL> SELECT STATUS FROM DBA_REGISTRY WHERE COMP_ID = 'APEX'; STATUS -------------------------------------------- VALID
-
In 6.2.1 Installing Application Express
It says:
When Application Express installs, it creates the following database accounts:
APEX_210100
- This account owns the Application Express schema and metadata.FLOWS_FILES
- This account owns the Application Express uploaded files.APEX_PUBLIC_USER
- This minimally privileged account is used for Application Express configuration with Oracle REST Data Services or Oracle HTTP Server andmod_plsql
.
If you configured RESTful Web services, then these additional accounts will be created:
APEX_REST_PUBLIC_USER
- The account used when invoking RESTful Services definitions stored in Oracle Application Express.APEX_LISTENER
- The account used to query RESTful Services definitions stored in Oracle Application Express.
If you are upgrading from a previous release, then
FLOWS_FILES
already exists andAPEX_PUBLIC_USER
is created if it does not already exist.@@@ then in 6.2.5 Configuring RESTful Services
@apex_rest_config.sql
- When Prompted, enter a password for the
APEX_LISTENER
andAPEX_REST_PUBLIC_USER
accounts. - When configuring RESTful Services in Oracle Application Express, it creates two new database accounts.
APEX_LISTENER
- The account used to query RESTful Services definitions stored in Oracle Application Express.APEX_REST_PUBLIC_USER
- The account used when calling RESTful Services definitions stored in Oracle Application Express.
@@ In My APEX Install it says:
ok 14 - Installing APEX REST Config | 0.00
@@ Should have installed
APEX_LISTENER and APEX_REST_PUBLIC_USER
users ??Checked users:
SQL> col USERNAME for a30 SQL> set pagesize 200 SQL> select USERNAME, USER_ID from all_users; USERNAME USER_ID ------------------------------ ---------- SYS 0 AUDSYS 8 SYSTEM 9 SYSBACKUP 2147483617 SYSDG 2147483618 SYSKM 2147483619 SYSRAC 2147483620 OUTLN 13 XS$NULL 2147483638 GSMADMIN_INTERNAL 21 GSMUSER 22 DIP 23 REMOTE_SCHEDULER_AGENT 34 DBSFWUSER 35 ORACLE_OCM 39 SYS$UMF 46 DBSNMP 53 APPQOSSYS 54 GSMCATUSER 58 GGSYS 59 XDB 61 ANONYMOUS 62 WMSYS 71 DVSYS 1279990 OJVMSYS 80 CTXSYS 82 ORDSYS 84 ORDDATA 85 ORDPLUGINS 86 SI_INFORMTN_SCHEMA 87 MDSYS 88 OLAPSYS 91 MDDATA 94 LBACSYS 96 DVF 98 APEX_PUBLIC_USER 105 PDBADMIN 101 HR 102 APEX_210100 103 FLOWS_FILES 104
40 rows selected.
-
I looked at all the logs and saw nothing besides the one I already posted.
I saw 1-2 other posting of the same exact error but no resolution.
In tracing it into the Perl code I saw there were many bugs regarding this in the comments of the code.
Can I escalate to the Oracle team?? How about it guys!
Thank you,
Bill Carlisle
-
bump