2 Replies Latest reply: Apr 8, 2014 11:45 AM by Jeff E RSS

    Apex installation probelm


      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



      My operating system is: Windows 7 Professional, 32 bit

      Oracle installed is:


      I extracted the APEX folder in c:\temp and running it as follows:


      SQL> @c:\temp\apex\apexins.sql APEX APEX TEMP /i/



      I also googled and looked into OTN site for APEX but did not make any headway and hence posting this question here.


      Can any one of you help me to resolve this error.




        • 1. Re: Apex installation probelm



          Are you logged into your database with SYS AS SYSDBA?


          At what point during the install do you encounter this error?



          • 2. Re: Apex installation probelm
            Jeff E

            I think your main problem is: SP2-0310: unable to open file "coreins.sql"


            According to the installation documentation you must change your working directory before calling sqlplus and the apexins.sql script.


            Before running sqlplus change your directory:


            CD c:\temp\apex


            Then you should run the apexins.sql script directly (no path prefix):


            SQL> @apexins.sql APEX APEX TEMP /i/