Apex Installation

Oracle Application Express - web application development tool (antigamente conhecido como Oracle HTML-DB)
Post Reply
Luisinho
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 4
Joined: Fri, 26 Aug 2011 12:43 pm
Location: são Leopoldo - RS

Hello I am new to the forum and would like help in the installation of the apex.ton 10g e ex and I installed the last version Apex 4.01, follow a torria and gave no error. But when I execute in the browser appears in the APPLATION EXPRESS login browser tab Pagina gets all white, not from Nehuma error message. Can anyone give me a light?

Thanks.
marcus.kobel
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 45
Joined: Thu, 12 May 2011 4:54 pm
Location: Porto Alegre - RS

What would be a "Torria"?
marcus.kobel
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 45
Joined: Thu, 12 May 2011 4:54 pm
Location: Porto Alegre - RS

And another, I know it has a topic in the Forum on Application Express that has tutorials and everything. Looking there that you will be happy.
marcus.kobel
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 45
Joined: Thu, 12 May 2011 4:54 pm
Location: Porto Alegre - RS

I meant, "installation tutorials".
User avatar
stcoutinho
Moderador
Moderador
Posts: 850
Joined: Wed, 11 May 2011 5:15 pm
Location: são Paulo - SP

Muisinho,

Can you explain with more detail the problem you are facing?

The Apex login page appears for you? Are the figures on the page appear? Any error message appears?

Based on your answer, maybe we can "give you a light" on how to make Apex work.

Hugs and welcome to the APEX world!

Sergio Coutinho
User avatar
stcoutinho
Moderador
Moderador
Posts: 850
Joined: Wed, 11 May 2011 5:15 pm
Location: são Paulo - SP

Luisinho,

Just complement: You said you followed an installation tutorial.

If by chance of the link where this tutorial is, could you post here in this forum, along with a more detailed description of the error that is encountering?

Hugs,

Sergio Coutinho
Luisinho
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 4
Joined: Fri, 26 Aug 2011 12:43 pm
Location: são Leopoldo - RS

Hi everyone, thank you very much for the answers. Sorry the mistakes of Portuguese, when you want to say tutorial.

well the tuerial that followed was this:

- Preparing the database;
Turn the Oracle Text script.
in the 10G Ex version The path to rotate the script is slightly different. If your installation was made by the installer default The path will be as follows:

Select all

C:\oraclexe\app\oracle\product\10.2.0\server\ctx\admin\defaults
Open the command prompt (CMD)
Start menu - Run

Select all

cmd 
sqlplus sys as sysdba
Enter the password.

Select all

@C:\oraclexe\app\oracle\product\10.2.0\server\ctx\admin\defaults\drdefus.sql 
exit
Navigate to the APEX \ OWA directory [

Select all

Cd c:\apex_4.0\apex\owa 
sqlplus sys as sysdba
Enter the password.

Select all

@owainst.sql 
@?/rdbms/admin/utlrp.sql 
exit.
Navigate to the directory where the Apex was uncompressed.

Select all

Cd c:\apex_4.0\apex 
sqlplus sys as sysdba
Enter the password.

Select all

@apexins SYSAUX SYSAUX TEMP /i/
After the end of the process we will set the Apex Admin password.

Select all

sqlplus sys as sysdba
Enter the password.

Select all

@apxchpwd
Enter a password.

After type:

Select all

@apex_epg_config 
Set the apex extraction directory)
Example

Select all

@apex_epg_config C:\apex_4.0[ 
exit/code] 
 
- Instalando a tradução pt-br 
Novamente no prompt de comando (cmd) 
[code]cd C:\apex_4.0\apex\builder\pt-br 
set NLS_LANG=American_America.AL32UTF8 
sqlplus sys as sysdba
Report the password.

Select all

ALTER SESSION SET CURRENT_SCHEMA = APEX_040000; 
@load_pt-br.sql 
exit
Access:

Select all

http://127.0.0.1:8080/apex/apex_admin

UserName: admin
Password: (set after the @ApxChpwd) command
You will be prompted for password.

Everything has occurred without errors, so how much I try to log in a white screen and not of any error. I think it's some problem with the images.

Thanks all that they are trying to help me.
ishii
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 82
Joined: Tue, 28 Dec 2010 7:41 pm
Location: São Paulo - SP

Hello,

View which your browser and version to see if it is compatible with APEX.
[] S Ishii
Luisinho
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 4
Joined: Fri, 26 Aug 2011 12:43 pm
Location: são Leopoldo - RS

Hi, I tested with Firefox 3.6.13 and with the crome.nos two of the same thing.
User avatar
stcoutinho
Moderador
Moderador
Posts: 850
Joined: Wed, 11 May 2011 5:15 pm
Location: são Paulo - SP

Luisinho,

I do not think the problem you report refer to the browser, unless you use any other than Explorer, Chrome or Firefox browser.

In these links below, you can view the Apex documentation and the installation process:
[[0] http://download.oracle.com/docs/cd/E239 ... e21673.pdf
I understand that you are Trying to install Apex on an Oracle 10G XE base. If this is the case, you can follow the installation script described below:

01) Download the APEX 4.1 (APEX_4.1.ZIP) package;
02) Unzip a directory the APEX_4.1.ZIP file;
03) via Windows CMD, position in the Apex subdirectory of the uncompressed file;
04) From it, trigger the SQL * plus and connect to the same via sysdba:

Select all

sqlplus /nolog <enter> 
    SQL> conn / as sysdba <enter>
05) Install APEX through the apexins.sql script

Select all

@apexins SYSAUX SYSAUX TEMP /i/
After the finish script, three accounts are created in your database: apex_040100, flows_files and apex_public_user);
07) Changing the user password APEX Admin

Select all

sqlplus /nolog <enter> 
    SQL> conn / as sysdba <enter> 
    SQL> @apxchpwd
08) Configuring Embedded PL / SQL Gateway

Select all

sqlplus /nolog <enter> 
    SQL> conn / as sysdba <enter> 
    SQL> @apex_epg_config C:\TEMP
Important: Where it reads "C : \ Temp, "you must interpret as the directory below which is the
package unzipped the Apex installation kit. If for example, the installation kit is in
"C: \ Temp \ Apex", you must inform here "C: \ Temp ". If the directory is related to the directory, you can
come across an error running this script, or the APEX login page will find it distorted
when you access it;

09) Unlock the Oracle Anonymous user

Select all

ALTER USER ANONYMOUS ACCOUNT UNLOCK;
10) Only if you are upgrading Apex (from an earlier version), it is necessary to run
Apxyldimg.sql script:

Select all

@apxldimg.sql C:\TEMP
Ignore this step if you are installing APEX (and not upgrade);
Important: where you read "C: \ Temp", you must interpret as the directory below which is the
package uncompressed the Apex installation kit. If for example, the installation kit is in
"C: \ Temp \ Apex", you must inform here "C: \ Temp ". If the directory is related to the directory, you can
come across an error running this script, or the APEX login page will find it distorted
when you access it;
11) If you want to install the Apex to be translated into English:
- via Windows (MS-DOS), position in the APEX / BUILDER / "directory. <Language PTB>" , where "<language PTB>" corresponds to the name of the Portuguese language directory;
- Run the command:

Select all

set NLS_LANG=American_America.AL32UTF8
- Call SQL * plus as sysdba and perform the following steps

Select all

sqlplus /nolog 
      SQL>ALTER SESSION SET CURRENT_SCHEMA = APEX_040100; 
      SQL>@load_[lang].sql (onde [lang] corresponde à sigla do idioma português);
This, you should access the Apex on these links

Select all

http://[nome_hostname]:8080/apex/apex_admin 
http://[nome_hostname]:8080/apex/apex 
Onde "nome_host" seria o nome da sua maquina ou o IP dela
Run the installation of APEX by following the script above and let us report.

Hugs,

Sergio Coutinho
Luisinho
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 4
Joined: Fri, 26 Aug 2011 12:43 pm
Location: são Leopoldo - RS

Ola Sergio Coutinho, thank you very much for your help. I describe what was wrong in my installation. I have not set up the images.

My installation was like this:

Select all

C:\Oraclexe\Apex 4.1
When it turns the Script @ apex_epg_config.sql was giving error because in the script the default folder is Apex.

I changed the folder to:

Select all

C:\Oraclexe\Apex
Then I rode the scrip @ apex_epg_config.sql and only went to run to the arm, goal board.

Thanks to all who have been able to help me.






: D
User avatar
stcoutinho
Moderador
Moderador
Posts: 850
Joined: Wed, 11 May 2011 5:15 pm
Location: são Paulo - SP

Wow,

How cool it worked, Luisinho.

I did not know that "C: \ oraclexe \ Apex 4.1" could impact and generate errors in the execution of the script apex_epg_config.sql
] It was nice to know this detail you posted.

Hugs,

Sergio
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 10 guests