| Apex installation problem [message #611601] |
Fri, 04 April 2014 05:46  |
buggleboy007
Messages: 282
Registered: November 2010
Location: Canada
|
Senior Member |
|
|
Hi there - I am trying to run the "apexins.sql" to install APEX and getting bogged down with an error called : component 'G_12c' must be declared. The error message is as follows:
SP2-0310: unable to open file "coreins.sql"
not spooling currently
if wwv_flow_global.g_12c then
*
ERROR at line 4:
ORA-06550: line 4, column 24:
PLS-00302: component 'G_12C' must be declared
ORA-06550: line 4, column 5:
PL/SQL: Statement ignored
I extracted the APEX folder(which I downloaded off Oracle site) in c:\temp and running it as follows:
SQL> @c:\temp\apex\apexins.sql APEX APEX TEMP /i/
Please note that the file- coreins.sql is present in the APEX folder. I also googled and looked into OTN site for any assistance with my kind of issue, but had no luck there.
Product details : Oracle APEX 4.0 , DB:11.2.0.1.0, OS: Windows 7 Professional 32 bit
Can any one of you help me to resolve this error.
[Updated on: Fri, 04 April 2014 05:54] Report message to a moderator |
|
|
|
|
|
| Re: Apex installation problem [message #611641 is a reply to message #611615] |
Sat, 05 April 2014 05:38  |
buggleboy007
Messages: 282
Registered: November 2010
Location: Canada
|
Senior Member |
|
|
Hi Littlefoot,
You asked: did you precreate APEX tablespace?
Answer: Yes, I created a APEX tablespace by following the link posted on : http://www.clartechsolutions.com/en/instalando-oracle-apex-4-2
I tried the solution that you gave too and am constantly getting bogged down with an error that says:
The procedure entry point longjmp could not be located in the dynamic link library orauts.dll
I will show you how I am getting this error:
Step 1: I invoke DOS prompt
Step 2: The DOS prompt window populates and then navigate to the folder where the APEX files are and that is:
c:\> cd temp/apex
c:\TEMP\APEX
Step 3: Connecting to SQL*PLUS
c:\TEMP\APEX>sqlplus /nolog
SQL*Plus: Release 10.1.0.4.2 - Production on Sat Apr 5 16:02:14 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL>
Once I get into this area, the problem begins and that is:
SQL> connect sys as sysdba
Enter password:
Once I enter the password, I get the error The procedure entry point longjmp could not be located in the dynamic link library orauts.dll
To mitigate this error, I opened SQL DEVELOPER tool and then ran the script by initially creating a table space(as mentioned in the link above), and then explicitly mentioning the path and then running the apexins.sql script with the required arguments.
Yet no luck.
Can any one help me out please???
Many thanks in advance.
|
|
|
|
| Re: Apex installation problem [message #611642 is a reply to message #611641] |
Sat, 05 April 2014 09:31 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
I think you have confused your Oracle homes. Your SQL*Plus client is release 10.1, but you say you are installing into an 11.2 database. I do not think you can connect using IPC, which is what you are trying to do.
Try setting up your environment to connect to the 11.2 home, and run SQL*Plus from there.
|
|
|
|
| Re: Apex installation problem [message #611643 is a reply to message #611641] |
Sat, 05 April 2014 09:35 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
When creating this topic, you stated that database version you use is 11.2.0.1.0. SQL*Plus information you posted says Release 10.1.0.4.2. Which database is it, really?
Is the database installed on your own PC? If so, do you have any other Oracle product installed on your computer? For example, you do have 11.2.0.1.0 database and 10.1.0.4.2 client (I don't know whether it exists, I'm just making an example). If so, try to invoke 11.2 SQL*Plus (instead of 10.1). How? When CMD window opens, specify the whole path to 11.2 SQLPLUS.EXE. For example:c:\TEMP\APEX>c:\oracle\product\11.2\bin\sqlplus /nolog
Alternatively, set ORACLE_HOME to 11.2 version, such asC:\TEMP\APEX>set ORACLE_HOME=C:\oracle\product\11.2\db_1
C:\TEMP\APEX\>sqlplus /nolog
[EDIT] Ah! Didn't notice John's answer posted while I was composing mine.
[Updated on: Sat, 05 April 2014 09:37] Report message to a moderator |
|
|
|
| Re: Apex installation problem [message #611644 is a reply to message #611642] |
Sat, 05 April 2014 11:04 |
buggleboy007
Messages: 282
Registered: November 2010
Location: Canada
|
Senior Member |
|
|
John and Littlefoot - A good catch about the versions. When I login via command prompt and go to SQL*Plus, I see the version as:
SQL*Plus: Release 10.1.0.4.2 - Production on Sat Apr 5 21:25:57 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
When I open SQL Plus directly via Oracle OraDB11g_home1, I get the version as:
SQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 5 21:26:03 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name:
As far as I know,I have Oracle11g as database and Forms/Reports 10g (yes, 10g and not 11g) as front end tool. I don't know how this 10g thinge has sneaked in.
Anyways I will work on the solution given and then see how it goes. Thanks again for all your help.
|
|
|
|
|
|
| Re: Apex installation problem [message #611646 is a reply to message #611645] |
Sat, 05 April 2014 12:52 |
|
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Did you - after installation ended - restart your database? If not, do it now.
Did you unlock APEX_PUBLIC_USER? Check its status withselect account_status
from dba_users
where username = 'APEX_PUBLIC_USER'; alter user apex_public_user account unlock;
Did you update the Images directory? If you don't do that, Apex won't work properly. How to do that:
Verify Oracle XML DB HTTP server port:SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
Finally, in your browser, go to Apex homepage; URL looks like http://127.0.0.1:8080/apex (where 127.0.0.1 represents your PC, i.e. localhost and 8080 is HTTP server port returned by previous SELECT statement).
Any improvement?
[Updated on: Sat, 05 April 2014 12:53] Report message to a moderator |
|
|
|
| Re: Apex installation problem [message #611660 is a reply to message #611646] |
Sun, 06 April 2014 10:11 |
buggleboy007
Messages: 282
Registered: November 2010
Location: Canada
|
Senior Member |
|
|
Littlefoot - Thanks a lot for your answers. Unfortunately, haven't had success. For today, I have not tried due to paucity of time.
The only thing that I looked into is:
select account_status
from dba_users
where username = 'APEX_PUBLIC_USER';
Account status is set to expired.
One of these days, I will sit in the morning and then re-run the whole set up and see how it goes. I will follow instructions presented in Oracle manual as opposed to the site that I followed in the past. I will keep you posted.
Thanks,
Sandeep
|
|
|
|
|
|
| Re: Apex installation problem [message #611662 is a reply to message #611661] |
Sun, 06 April 2014 12:14 |
buggleboy007
Messages: 282
Registered: November 2010
Location: Canada
|
Senior Member |
|
|
Why am I installing 4.0?
Answer: Well, my intention to download APEX at first instance was to practice APEX as I lack web applications skill. I actually downloaded 4.0 sometime ago and thought of going with it as I had a ebook of Apress - Beginning APEX 4.0.
I have installed Oracle 11g Enterprise Edition (a long time ago).
You said: If so, it already contains Apex 4.0 so you don't have to install anything.
My question: So you mean to say in this case as APEX 4.0 is installed by default (which is what I see in my folder after 11g was installed - C:\app\Sandeep\product\11.2.0\dbhome_1\apex), in your opinion, I just have to open a browser and then type the URL - http://127.0.0.1:8080/apex ; and then get going??
Is it that simple??
Just out of curiosity, I typed the URL and I see an APEX login screen but completely blank page. Is there anything wrong that I am doing?
|
|
|
|
| Re: Apex installation problem [message #611663 is a reply to message #611662] |
Sun, 06 April 2014 12:23 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
In my experience, a blank page often means that you have messed up the path to your images.
You can try to fix it, but if I were you I would drop all the schemas and start again with a fresh download of the current Apex and then follow the installation guide from the beginning.
|
|
|
|
|
|
|
|
| Re: Apex installation problem [message #611986 is a reply to message #611666] |
Thu, 10 April 2014 10:40 |
buggleboy007
Messages: 282
Registered: November 2010
Location: Canada
|
Senior Member |
|
|
Ok.. I am back Littlefoot and John. Need help again. Sorry to be bothering you all. I am just trying to install APEX but running into issues, so I thought of uninstalling APEX and then do this process all over again. However uninstallating APEX too is causing errors even though towards the end,it did say that "Application Express Removed". Do you think uninstallion was successful or is it screwed up. If it is, what can I do to uninstall APEX and redo this process all over again?
Here's the error that I am encountering:
SQL> connect sys as sysdba
Enter password:
Connected.
SQL>
SQL> @apxremov.sql;
...Removing Application Express
Session altered.
begin
*
ERROR at line 1:
ORA-04063: package body "APEX_040200.WWV_FLOW_UPGRADE" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"APEX_040200.WWV_FLOW_UPGRADE"
ORA-06512: at line 2
F
-
2
PL/SQL procedure successfully completed.
Session altered.
PL/SQL procedure successfully completed.
Session altered.
F
-
2
User dropped.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
...Application Express Removed
********************************************************************
** You must exit this SQL*Plus session before running apexins.sql **
********************************************************************
|
|
|
|
| Re: Apex installation problem [message #611997 is a reply to message #611986] |
Thu, 10 April 2014 12:40 |
buggleboy007
Messages: 282
Registered: November 2010
Location: Canada
|
Senior Member |
|
|
Littlefoot and John - Voila... I got it.. I dropped the schema (as suggested by John) and assuming the above script (though it gave some errors) was bug free by ignoring it; I restarted the whole PC and then followed instructions as given by Oracle APEX manual from Oracle's website.. word to word, ran all the scripts and it took about 40 minutes to complete. Bug free.
Then ran http://sandeep-pc:8080/apex
The APEX webpage loaded successfully with all the images. Finally relieved.
Thanks a lot to both of you as you both guided me patiently. I don't think I could have done this without your help. Once again Thanks a lot. You both are genius. Now time to flip the "Beginning APEX 4.2" book by Apress and then learning APEX.
Cheers!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
. I believe while running script for Embedded PL/SQL Gateway, I ran into issues(though the script did finally say it was successful and besides other scripts including the anonymous block was successful too) and that may be the reason why I cannot see APEX at all on my system. 