| Apex [message #642389] |
Wed, 09 September 2015 08:05  |
 |
valera71_05
Messages: 11
Registered: September 2015
|
Junior Member |
|
|
Prompt me, what version of Appex can be used for this version of Oracle?
[EDITED by LF: fixed topic title typo; was "Appex"]
[Updated on: Wed, 23 September 2015 14:48] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: Appex [message #642391 is a reply to message #642389] |
Wed, 09 September 2015 08:15  |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read
You need to look at the installation doc for each APEX release. For example, the installation doc for 4.2 says this,
Quote:2.1 Oracle Database Requirements
Oracle Application Express release 4.2 requires an Oracle database (Enterprise Edition, Standard Edition or Standard Edition One) that is Release 10.2.0.4 and later. Oracle Application Express release 4.2 can also be used with Oracle Database Express Edition 10g Release 2 (10.2) and later. The Oracle HTTP Server is not included with the distribution of Oracle Database Express Edition.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Appex [message #642397 is a reply to message #642392] |
Wed, 09 September 2015 09:02 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
valera71_05 wrote on Wed, 09 September 2015 14:40During setting of Appex there are errors If start @apexins APPEX APPEX TEMP /I/ - is given out at once error on the line of execute immediate ''bogus statement to force exit'';
if in start the beginning @apex_epg_config.sql c:\oracle\product\10.2.0\db_1 that passes procedure with less of errors
I can not find clear instruction on setting of Appex...
Come on, man. You will not get assistance unless you provide better information. How about using copy/paste from your SQL*Plus session to show what you did and what the error was?
You say you can't find clear instructions - which part of the install guide, for whatever release you are trying to install, is not clear to you?
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Appex [message #642957 is a reply to message #642953] |
Wed, 23 September 2015 07:41 |
|
valera71_05
Messages: 11
Registered: September 2015
|
Junior Member |
|
|
I put 2.2 because more late versions at instalyacii give out errors
it is written in instruction - will execute @apexins SYSAUX SYSAUX TEMP did /I/ and the result of implementation of this script is rotined. and for me a script asks to enter a parameter 6... do I specify here - that it can be?
[Updated on: Wed, 23 September 2015 07:43] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Appex [message #642961 is a reply to message #642960] |
Wed, 23 September 2015 08:04 |
|
valera71_05
Messages: 11
Registered: September 2015
|
Junior Member |
|
|
SQL*Plus: Release 10.2.0.1.0 - Production on Ср Сен 23 16:03:26 2015
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Присоединен к:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> @apexins SYSAUX SYSAUX TEMP /i/
. ____ ____ ____ ____
. / \ | \ /\ / | /
.| || / / \ | | |
.| ||--- ---- | | |--
.| || \ / \ | | |
. \____/ | \/ \ \____ |____ \____
.
. Application Express Installation.
...................................
Процедура PL/SQL успешно завершена.
Введите значение для 6:
SQL> @apexins SYSAUX SYSAUX TEMP /i/
. ____ ____ ____ ____
. / \ | \ /\ / | /
.| || / / \ | | |
.| ||--- ---- | | |--
.| || \ / \ | | |
. \____/ | \/ \ \____ |____ \____
.
. Application Express Installation.
...................................
Процедура PL/SQL успешно завершена.
Введите значение для 6: NONE
Введите значение для 6: NONE
F
-
FOO3
------------------------------
install2015-09-23_16-06-12.log
строки не выбраны
Введите значение для 5: E:\oracle\product\10.2.0\db_1\apex\images
Proceeding with new installation.
Процедура PL/SQL успешно завершена.
begin
*
ошибка в строке 1:
ORA-02156: неверный идентификатор для раздела TEMPORARY
ORA-06512: на line 3
FOO
---------
INSTALLED
APEX_PUBLIC_USER exists.
Процедура PL/SQL успешно завершена.
I. O R A C L E S Y S I N S T A L L P R O C E S S
...create flows user
create user FLOWS_020200 identified by "SYSAUX"
*
ошибка в строке 1:
ORA-01920: имя пользователя 'FLOWS_020200' противоречит имени другого
пользователя или роли
Отсоединено от Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produ
ction
With the Partitioning, OLAP and Data Mining options
E:\oracle\product\10.2.0\db_1\apex>
[Updated on: Wed, 23 September 2015 08:08] Report message to a moderator |
|
|
|
|
|
| Re: Appex [message #642973 is a reply to message #642962] |
Wed, 23 September 2015 14:47 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Apex 2.2 is really old. I found (here: http://www.oracle.com/technetwork/server-storage/linux/el4-10gr2-ohs-apex-129595.txt) some instructions which say that installation looks like
SQL> @apexins oracledb SYSAUX SYSAUX TEMP /i/ none
while you ran
SQL> @apexins SYSAUX SYSAUX TEMP /i/
See the difference?
The 6th parameter you are looking for is probably "none". You provided it in the second installation attempt (you posted above) and PL/SQL procedure successfully completed.
Then there was an error ORA-02156 which says that you provided an invalid name for the temporary tablespace. You said it was "TEMP"; did you check its real name?
Yet another error, ORA-01920 says that you are trying to create user which already exists. This is obviously wrong:create user FLOWS_020200 identified by "SYSAUX"
Shortly: what a mess!
As you said that you are going to install 12c: perhaps you shouldn't. Install 11g XE instead. It already contains Apex 4.0 so you don't have to bother unless you want to upgrade it, but - think twice, as you seem to be incapable of following installation guide and you might mess up XE's 4.0 Apex as well. However, if you are willing to learn, go ahead. In my opinion, your way of learning is wrong. Try & fail method is one way to reach the goal, but is painful and time-consuming (as you've already noticed).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
