Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Apex (Oracle Database 10g Enterprise Edition Release 10.2.0.1.0)
Apex [message #642389] Wed, 09 September 2015 08:05 Go to next message
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 #642390 is a reply to message #642389] Wed, 09 September 2015 08:07 Go to previous messageGo to next message
valera71_05
Messages: 11
Registered: September 2015
Junior Member
I try to put first time. Each time abortively
Re: Appex [message #642391 is a reply to message #642389] Wed, 09 September 2015 08:15 Go to previous messageGo to next message
John Watson
Messages: 7399
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 #642392 is a reply to message #642391] Wed, 09 September 2015 08:40 Go to previous messageGo to next message
valera71_05
Messages: 11
Registered: September 2015
Junior Member
During 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...
Re: Appex [message #642394 is a reply to message #642392] Wed, 09 September 2015 08:46 Go to previous messageGo to next message
BlackSwan
Messages: 26001
Registered: January 2009
Location: SoCal
Senior Member
install VIRTUALBOX
then load VM below
http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html
Re: Appex [message #642395 is a reply to message #642394] Wed, 09 September 2015 08:50 Go to previous messageGo to next message
valera71_05
Messages: 11
Registered: September 2015
Junior Member
As far as I understand - it for the version of 12c, and for me 10.2.0.1.0
Re: Appex [message #642396 is a reply to message #642395] Wed, 09 September 2015 08:58 Go to previous messageGo to next message
BlackSwan
Messages: 26001
Registered: January 2009
Location: SoCal
Senior Member
Oracle V10 is obsoleted & unsupported.
If you insist on V10, then You're On Your Own.
If you desire APEX that works without error, then I showed you path to get it.
It is your choice.
Re: Appex [message #642397 is a reply to message #642392] Wed, 09 September 2015 09:02 Go to previous messageGo to next message
John Watson
Messages: 7399
Registered: January 2010
Location: Global Village
Senior Member
valera71_05 wrote on Wed, 09 September 2015 14:40
During 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 #642398 is a reply to message #642396] Wed, 09 September 2015 09:06 Go to previous messageGo to next message
valera71_05
Messages: 11
Registered: September 2015
Junior Member
turns out - or to migrate on Oracle 12c or to continue to be tormented with setting...
Re: Appex [message #642399 is a reply to message #642397] Wed, 09 September 2015 09:10 Go to previous messageGo to next message
valera71_05
Messages: 11
Registered: September 2015
Junior Member
I today will reinstall the test base of Oracle and will whip off errors which are given out in the process of setting
Re: Appex [message #642951 is a reply to message #642397] Wed, 23 September 2015 07:21 Go to previous messageGo to next message
valera71_05
Messages: 11
Registered: September 2015
Junior Member
I began setting of Apex 2.2 and at a start @apexins SYSAUX SYSAUX TEMP did /I/ get a question - enter a value for 6 what needs to be entered?
Re: Appex [message #642953 is a reply to message #642951] Wed, 23 September 2015 07:26 Go to previous messageGo to next message
Littlefoot
Messages: 21415
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Apex 2.2?!? Are you sure? It was released in 2006; why would you want to install that version?

@apexins SYSAUX SYSAUX TEMP did /I/

What is "did" doing here?

Anyway: installation process is very well described in the documentation. All you have to do is to follow the instructions. Carefully.
Re: Appex [message #642957 is a reply to message #642953] Wed, 23 September 2015 07:41 Go to previous messageGo to next message
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 #642958 is a reply to message #642957] Wed, 23 September 2015 07:49 Go to previous messageGo to next message
Littlefoot
Messages: 21415
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:

I put 2.2 because more late versions at instalyacii give out errors

What errors? I installed 3.2, 4.x on 10g and 11g databases and had no errors.



Please, post a link to a document which instructs you to execute

@apexins SYSAUX SYSAUX TEMP did /I/
Re: Appex [message #642959 is a reply to message #642958] Wed, 23 September 2015 07:55 Go to previous messageGo to next message
valera71_05
Messages: 11
Registered: September 2015
Junior Member
http://oracle.axoft.ru/fordev/setupapex.php

Re: Appex [message #642960 is a reply to message #642959] Wed, 23 September 2015 07:59 Go to previous messageGo to next message
Littlefoot
Messages: 21415
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Once again: where exactly do you see "did" in instructions?

I'm going offline, but will be back in several hours. In the meantime, I'd suggest you to follow the documentation (by the way, why don't you use the original?). Also, someone else might hop into this discussion and assist you further. Though, I'm not sure how to tell you that "did" should be omitted ...
Re: Appex [message #642961 is a reply to message #642960] Wed, 23 September 2015 08:04 Go to previous messageGo to next message
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 #642962 is a reply to message #642961] Wed, 23 September 2015 09:08 Go to previous messageGo to next message
valera71_05
Messages: 11
Registered: September 2015
Junior Member
Probably, there will not be I to suffer and to torment you. Now I will set oracle 12с and will make an effort influence apex on him. and then will simply do link between these bases
Re: Appex [message #642973 is a reply to message #642962] Wed, 23 September 2015 14:47 Go to previous message
Littlefoot
Messages: 21415
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"
SYSAUX isn't a password - you should have provided it as the first parameter to the APEXINS.

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).
Previous Topic: ORDS Glassfish Tomcat
Next Topic: blob file in Apex 5
Goto Forum:
  


Current Time: Fri May 25 08:02:03 CDT 2018