How to upgrade Apex 2.1 on Oracle 10g

I started to try to upgrade by using the document you adviced. I connected sql*plus as a sysdba as sys. BUt it gave error:

SQL> @apexins SYSAUX SYSAUX TEMP /i/
Error reading file

SQL> @C:\Users\Serafettin\Desktop\Programlar\apex 3.2.1 kurulum/apex/apxldimg.sql C:\Users\Serafettin\Desktop\Programlar\apex 3.2.1 kurulum
Error reading file

what is the problem?

I couldn't understand how I will use sql plus. I have it. By the way, I can not connect with the user sys as a DBA in sqlplus, is it normal? Thanks in advance.

>>By the way, I can not connect with the user sys as a DBA in sqlplus, is it normal?

Earlier you said
>>I connected sql*plus as a sysdba as sys.

So which is it?


You need to run the APEX installation package via sqlplus

A conflict :), I connected sql*plus as  a sysdba in plsql developer; but I couldn't connect sql*plus as a sysdba in SQL developer program which I downloaded from the link written in the documentation you suggested.  Sorry for conflicts in words.

I think I should change my working directory, how can I do this?

Sorry gatorvip,   I realized that I can not connect sql*plus as  a sysdba in plsql developer. What can possible reasons be?

It seemed that I had connected, but I realized that I can not connect when I saw this:

@C:\apex\apex_3.2.1\apexins htmldb APEX APEX_FILES TEMP /i/

Session altered
.  ____   ____           ____        ____
. /    \ |    \   /\    /     |     /
.|      ||    /  /  \  |      |    |
.|      ||---    ----  |      |    |---
.|      ||   \  /    \ |      |    |
. \____/ |    \/      \ \____ |____ \____
.
. Application Express Installation.
...................................
.
... Checking prerequisites





Application Express installation requires a connection with the SYSDBA privilege.

begin
    if 'NOSYSDBA' = 'NOSYSDBA' then
        dbms_output.put_line('Application Express installation requires a connection with the SYSDBA privilege.');
        execute immediate 'bogus statement to force exit';
    end if;
end;

ORA-00900: invalid SQL statement
ORA-06512: at line 4

By the way, I learned the problem. I connected using command window, then I connected as sysdba; and I solved the working directory problem, by writing the directory after @ like:

@C:\apex\apex_3.2.1\apexins htmldb APEX APEX_FILES TEMP /i/

But I confronted some other problems, like:

- The command above took very little time, like 5 seconds.

- It gave lots of error like :  SP2-0310: unable to open file  "core/....sql"

I don't know the reason.

thanks for  your help.

It is funny for me seeing myself solving problems step by step and befora my questions are answered.

The last problem reasoned by wrong working directory choice. I solved it by choosing working directory in command prompt. Like:

 C:\apex\apex_3.2.1>@apexins htmldb APEX APEX_FILES TEMP /i/

then, it installed.

I closed with B, because these answers weren't  enough to solve my problem easily, and I solve my problems with more effort. Thanks everyone for their helps.

"I solved it by choosing working directory in command prompt"

that's what gatorvip suggested in http:#25515222

Hmm, you are right, but I had not understood how to change working directory from gatorvip's suggestion. I found it myself.