Skip to content
This repository has been archived by the owner on Sep 26, 2021. It is now read-only.

Can't install Apex #53

Open
junpet opened this issue Jan 26, 2020 · 0 comments
Open

Can't install Apex #53

junpet opened this issue Jan 26, 2020 · 0 comments

Comments

@junpet
Copy link

junpet commented Jan 26, 2020

Please note that, I've changed the password in the Dockerfile. I've figured out that I have enter sys as sysdba as the user-name. Could you help me, what I'm doing wrong? Thanks!

bash-4.2# $ORACLE_HOME/bin/sqlplus sys/Oracle18@localhost/XEPDB1 as sysdba @apex-install.sql Oradoc_db1

SQL*Plus: Release 18.0.0.0.0 - Production on Sun Jan 26 09:05:10 2020
Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: sys as sysdba
Enter password: 

Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

old   3:   if '&admin_email.' is null then
new   3:   if '[email protected]' is null then
old   7:   if '&admin_pass.' is null then
new   7:   if 'Oradoc_db1' is null then

PL/SQL procedure successfully completed.

...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 [/tmp/apex/apexins_cdb_catcon_3589.lst]

catcon::set_log_file_base_path: catcon: See [/tmp/apex/apexins_cdb*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [/tmp/apex/apexins_cdb_*.lst] files for spool files, if any

Diagnostic output produced in conjunction with reporting an error message:
{

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9604 catcon::catconInit2 - will retain last 1000 log messages by default

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:7088 catcon::get_log_file_base_path - no log file directory was specified - using current directory (/tmp/apex)
2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:7088 catcon::get_log_file_base_path - 

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:7093 catcon::get_log_file_base_path - log file base = apexins_cdb

2020-01-26 09:05:18 INFO> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9019 catcon::set_log_file_base_path - ALL catcon-related output will be written to [/tmp/apex/apexins_cdb_catcon_3589.lst]

2020-01-26 09:05:18 INFO> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9026 catcon::set_log_file_base_path - catcon: See [/tmp/apex/apexins_cdb*.log] files for output generated by scripts

2020-01-26 09:05:18 INFO> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9028 catcon::set_log_file_base_path - catcon: See [/tmp/apex/apexins_cdb_*.lst] files for spool files, if any

2020-01-26 09:05:18 INFO> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9034 catcon::set_log_file_base_path - 
2020-01-26 09:05:18 INFO> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9034 catcon::set_log_file_base_path - !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
2020-01-26 09:05:18 INFO> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9034 catcon::set_log_file_base_path - 
2020-01-26 09:05:18 INFO> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9034 catcon::set_log_file_base_path - catcon version: /st_rdbms_18.0/8
2020-01-26 09:05:18 INFO> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9034 catcon::set_log_file_base_path -  catconInit2: start logging catcon output at 2020-01-26 09:05:18
2020-01-26 09:05:18 INFO> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9034 catcon::set_log_file_base_path - 
2020-01-26 09:05:18 INFO> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9034 catcon::set_log_file_base_path - !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
2020-01-26 09:05:18 INFO> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9034 catcon::set_log_file_base_path - 
2020-01-26 09:05:18 INFO> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9034 catcon::set_log_file_base_path - 

2020-01-26 09:05:18 VERBOSE> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9626 catcon::catconInit2 - start initializing catcon

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9628 catcon::catconInit2 - base for log and spool file names = /tmp/apex/apexins_cdb

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9641 catcon::catconInit2 -   running catconInit2(

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       DebugOn = 0

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       EchoOn = 0

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       ErrorLogging = 0

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       ExclCon = 0

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       ExtParallelism = 0

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       GUI = 0

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       InclCon = 0

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9644 catcon::catconInit2 -                       InternalUser = undefined

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       LogBase = apexins_cdb

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       LogDir = 0

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       NoErrorLoggingIdent = 0

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       NumProcs = 0

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9653 catcon::catconInit2 -                       PerProcEndStmts = <empty array>

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9653 catcon::catconInit2 -                       PerProcInitStmts = <empty array>

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       RegularArgTag_ref = SCALAR(0x2a1a410)

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       ScriptDir = 0

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9644 catcon::catconInit2 -                       ScriptUser = undefined

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       SecretArgTag_ref = SCALAR(0x2a1a518)

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       SeedMode = 99

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       SpoolOn = 0

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       SqlplusDir = 0

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       Upgrade = 0

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9666 catcon::catconInit2 -                       UserScripts = 0

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9671 catcon::catconInit2 -                      )             (2020-01-26 09:05:18)

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9763 catcon::catconInit2 - running on linux; DoneCmd = 
2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9763 catcon::catconInit2 - host sqlplus -v >

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9785 catcon::catconInit2 - TWO_TASK was not set, so there is no need to unset it

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9791 catcon::catconInit2 - regular argument delimiter was not specified - defaulting to --p

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9798 catcon::catconInit2 - secret argument delimiter was not specified - defaulting to --P

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9921 catcon::catconInit2 - no EZConnect strings supplied - using default instance

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9959 catcon::catconInit2 - User Connect String = / AS sysdba

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:9963 catcon::catconInit2 - User password not specified

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:10015 catcon::catconInit2 - setting Internal Connect String to User Connect String

2020-01-26 09:05:18 VERBOSE> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:10018 catcon::catconInit2 - finished constructing connect strings

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:10028 catcon::catconInit2 - no source file directory was specified

2020-01-26 09:05:18 DEBUG> /opt/oracle/product/18c/dbhomeXE/rdbms/admin/catcon.pm:10036 catcon::catconInit2 - locate directory in $PATH that contains sqlplus binary

}
End of diagnostic output

catcon::catconInit2: sqlplus not in PATH.

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

...set_appun.sql
...create APEX_LISTENER and APEX_REST_PUBLIC_USER users
Error: create user "APEX_LISTENER" identified by "oracle" account unlock default
tablespace  temporary tablespace TEMP
declare
*
ERROR at line 1:
ORA-00922: missing or invalid option
ORA-06512: at line 23
ORA-06512: at line 23
ORA-06512: at line 20


alter user APEX_PUBLIC_USER grant connect through APEX_REST_PUBLIC_USER
           *
ERROR at line 1:
ORA-01918: user 'APEX_PUBLIC_USER' does not exist


grant create session to APEX_LISTENER
                        *
ERROR at line 1:
ORA-01917: user or role 'APEX_LISTENER' does not exist


grant create session to APEX_REST_PUBLIC_USER
                        *
ERROR at line 1:
ORA-01917: user or role 'APEX_REST_PUBLIC_USER' does not exist


grant select on APEX_180200.wwv_flow_companies to APEX_LISTENER
                            *
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on APEX_180200.wwv_flow_lsnr_workspaces to APEX_LISTENER
                            *
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on APEX_180200.wwv_flow_lsnr_applications to APEX_LISTENER
                            *
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on APEX_180200.wwv_flow_lsnr_entry_points to APEX_LISTENER
                            *
ERROR at line 1:
ORA-00942: table or view does not exist



PL/SQL procedure successfully completed.

grant insert, update, delete, select on APEX_180200.wwv_flow_rt$privileges to APEX_LISTENER
                                                    *
ERROR at line 1:
ORA-00942: table or view does not exist


grant insert, update, delete, select on APEX_180200.wwv_flow_rt$modules to APEX_LISTENER
                                                    *
ERROR at line 1:
ORA-00942: table or view does not exist


grant insert, update, delete, select on APEX_180200.wwv_flow_rt$templates to APEX_LISTENER
                                                    *
ERROR at line 1:
ORA-00942: table or view does not exist


grant insert, update, delete, select on APEX_180200.wwv_flow_rt$handlers to APEX_LISTENER
                                                    *
ERROR at line 1:
ORA-00942: table or view does not exist


grant insert, update, delete, select on APEX_180200.wwv_flow_rt$parameters to APEX_LISTENER
                                                    *
ERROR at line 1:
ORA-00942: table or view does not exist


grant insert, update, delete, select on APEX_180200.wwv_flow_rt$clients to APEX_LISTENER
                                                    *
ERROR at line 1:
ORA-00942: table or view does not exist


grant insert, update, delete, select on APEX_180200.wwv_flow_rt$client_privileges to APEX_LISTENER
                                                    *
ERROR at line 1:
ORA-00942: table or view does not exist


grant insert, update, delete, select on APEX_180200.wwv_flow_rt$approvals to APEX_LISTENER
                                                    *
ERROR at line 1:
ORA-00942: table or view does not exist


grant insert, update, delete, select on APEX_180200.wwv_flow_rt$approval_privs to APEX_LISTENER
                                                    *
ERROR at line 1:
ORA-00942: table or view does not exist


grant insert, update, delete, select on APEX_180200.wwv_flow_rt$pending_approvals to APEX_LISTENER
                                                    *
ERROR at line 1:
ORA-00942: table or view does not exist


grant insert, update, delete, select on APEX_180200.wwv_flow_rt$user_sessions to APEX_LISTENER
                                                    *
ERROR at line 1:
ORA-00942: table or view does not exist


grant insert, update, delete, select on APEX_180200.wwv_flow_rt$privilege_groups to APEX_LISTENER
                                                    *
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on APEX_180200.wwv_flow_rt$services to APEX_LISTENER
                            *
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on APEX_180200.wwv_flow_rt$idm_privs to APEX_LISTENER
                            *
ERROR at line 1:
ORA-00942: table or view does not exist


grant select on APEX_180200.wwv_flow_rt$apex_account_privs to APEX_LISTENER
                            *
ERROR at line 1:
ORA-00942: table or view does not exist


grant execute on APEX_180200.wwv_flow_listener to APEX_LISTENER
                             *
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist


ERROR:
ORA-01435: user does not exist



Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.

ERROR:
ORA-01435: user does not exist


    wwv_flow_security.g_security_group_id := c_sgid;
    *
ERROR at line 6:
ORA-06550: line 6, column 5:
PLS-00201: identifier 'WWV_FLOW_SECURITY.G_SECURITY_GROUP_ID' must be declared
ORA-06550: line 6, column 5:
PL/SQL: Statement ignored
ORA-06550: line 8, column 5:
PLS-00201: identifier 'WWV_FLOW_LISTENER.INSTALL_PREREQ_DATA' must be declared
ORA-06550: line 8, column 5:
PL/SQL: Statement ignored
ORA-06550: line 10, column 8:
PLS-00201: identifier 'WWV_FLOW_PLATFORM.GET_PREFERENCE' must be declared
ORA-06550: line 10, column 5:
PL/SQL: Statement ignored


alter user apex_public_user identified by oracle account unlock
           *
ERROR at line 1:
ORA-01918: user 'APEX_PUBLIC_USER' does not exist


declare
*
ERROR at line 1:
ORA-46076: The specified name length not within valid range.
ORA-06512: at "SYS.XS_ADMIN_UTIL", line 53
ORA-06512: at "SYS.XS_ADMIN_UTIL", line 32
ORA-06512: at "SYS.XS$ACE_TYPE", line 23
ORA-06512: at line 12


  apex_util.set_security_group_id( 10 );
  *
ERROR at line 2:
ORA-06550: line 2, column 3:
PLS-00201: identifier 'APEX_UTIL.SET_SECURITY_GROUP_ID' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
ORA-06550: line 3, column 3:
PLS-00201: identifier 'APEX_UTIL.CREATE_USER' must be declared
ORA-06550: line 3, column 3:
PL/SQL: Statement ignored
ORA-06550: line 9, column 3:
PLS-00201: identifier 'APEX_UTIL.SET_SECURITY_GROUP_ID' must be declared
ORA-06550: line 9, column 3:
PL/SQL: Statement ignored


Disconnected from Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@junpet