Forum Stats

  • 3,769,497 Users
  • 2,252,970 Discussions
  • 7,875,057 Comments

Discussions

Can DB 18c XE, APEX 21.1 and ORDS 21.1 be installed on Windows 7 Professional?

BillC
BillC Member Posts: 1,065 Bronze Badge

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

  • L. Fernigrini
    L. Fernigrini Data Engineer Sr Consultant Member Posts: 3,666 Silver Crown

    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

    BillC
  • BillC
    BillC Member Posts: 1,065 Bronze Badge

    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>

  • jariola
    jariola Member Posts: 10,459 Silver Crown
    edited Oct 27, 2021 3:48PM

    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

    https://docs.oracle.com/en/database/oracle/application-express/21.1/htmig/downloading-installing-apex.html#GUID-7E432C6D-CECC-4977-B183-3C654380F7BF

  • BillC
    BillC Member Posts: 1,065 Bronze Badge
    edited Oct 27, 2021 7:33PM

    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
    
  • BillC
    BillC Member Posts: 1,065 Bronze Badge

    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 and mod_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 and APEX_PUBLIC_USER is created if it does not already exist.

    @@@ then in 6.2.5 Configuring RESTful Services

    @apex_rest_config.sql
    
    1. When Prompted, enter a password for the APEX_LISTENER and APEX_REST_PUBLIC_USER accounts.
    2. 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.

  • BillC
    BillC Member Posts: 1,065 Bronze Badge

    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

  • BillC
    BillC Member Posts: 1,065 Bronze Badge