5 Replies Latest reply: Mar 17, 2014 11:34 AM by A.NANDA RSS

    RCU - 6135 Unable to create portal schema.

    A.NANDA

      Hi all,

       

      I having issues creating schemas for Portal using RCU on RHEL5.7 X86 ( running rcu from this server).

      Database is on 11.2.0

       

      I am getting this error -

       

      Error Screen 1

      "Portal Configuration Assistant aborted"

      Error Screen 2

       

      RCU-6130:Action Failed - RCU-6135:Error while trying to execute Java action.

       

       

      Log extracts from rcu.log & portal.log below:

       

      Log Extract from Portal.log

      Use the normal connect to SYS

       

      STEP 1 (PORTAL) : Starting the installation..

       

      STEP 2 (PORTAL) :Installing OWA packages

       

      INSTALL_ACTION :installOWA() :

       

      In sqlExecuter, OH = /u01/app/rcu_11.1.1.7.0/rcuHome

       

      Will invoke sqlplus with full path: /u01/app/rcu_11.1.1.7.0/rcuHome/bin/sqlplus -S /nolog

       

      ERROR:

       

      ORA-01017: invalid username/password; logon denied

       

       

       

       

       

      SP2-0640: Not connected

       

      SP2-0640: Not connected

       

      SP2-0640: Not connected

       

      SP2-0640: Not connected

       

      SP2-0640: Not connected

       

      SP2-0641: "PRINT" requires connection to server

       

      SP2-0640: Not connected

       

      SP2-0640: Not connected

       

      SP2-0640: Not connected

       

      SP2-0640: Not connected

       

      Enter value for pubcust_var: SP2-0310: unable to open file "/u01/app/rcu_11.1.1.7.0/rcuHome/portal/admin/plsql/owa/exit;.sql"

       

      Enter value for owa_file_var:

       

      SP2-0546: User requested Interrupt or EOF detected.

       

      SP2-0310: unable to open file "@�"

       

      Enter value for privcust_var:

       

      SP2-0546: User requested Interrupt or EOF detected.

      SP2-0310: unable to open file "@�"

       

      SP2-0640: Not connected

       

      INSTALL_ERROR: sqlExecuter() : Raised Exception oracle.webdb.config.PortalWiringException: Generated errors of type ORA-, PLS-, SP2-, ERROR: or IMP-. Refer to the log file for details.

       

      ERROR: Installing OWA Layer raised exception.

       

      Extract from RCU.Log

      2014-02-10 11:50:50.509 INCIDENT_ERROR rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: Failed to execute method:  Excepton:

      java.lang.reflect.InvocationTargetException

              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:597)

              at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:510)

              at java.lang.Thread.run(Thread.java:662)

      Caused by: java.lang.RuntimeException: ERROR: Portal Configuration Assistant aborted

              at oracle.webdb.config.PortalConfigAssistant.<init>(Unknown Source)

              at oracle.webdb.config.PortalConfigAssistant.main(Unknown Source)

              ... 6 more

       

      2014-02-10 11:50:50.510 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: ERROR: Portal Configuration Assistant aborted

       

      2014-02-10 11:50:53.291 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed

      oracle.sysman.assistants.common.task.TaskExecutionException: RCU-6135:Error while trying to execute Java action.

              at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:302)

              at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)

              at java.lang.Thread.run(Thread.java:662)

      Caused by: oracle.sysman.assistants.common.task.ActionFailedException: RCU-6135:Error while trying to execute Java action.

              at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:537)

              ... 1 more

      Caused by: java.lang.reflect.InvocationTargetException

              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:597)

              at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:510)

              ... 1 more

      Caused by: java.lang.RuntimeException: ERROR: Portal Configuration Assistant aborted

              at oracle.webdb.config.PortalConfigAssistant.<init>(Unknown Source)

              at oracle.webdb.config.PortalConfigAssistant.main(Unknown Source)

              ... 6 more

       

      Thanks a lot in advance. Appreciate your expert advice.

       

      -AN

        • 1. Re: RCU - 6135 Unable to create portal schema.
          A.NANDA

          ok. I did change the login procedure & used the user SYS to login. now the error is different in the portal.log

           

          here is the extract:

           

          ------------

          PL/SQL procedure successfully completed.

           

           

           

          declare

           

          *

           

          ERROR at line 1:

           

          ORA-06510: PL/SQL: unhandled user-defined exception

           

          ORA-06512: at "HUS_PORTAL.WWERR_API_EXCEPTION", line 164

           

          ORA-06512: at "HUS_PORTAL.WWV_CONTEXT", line 2189

           

          ORA-06510: PL/SQL: unhandled user-defined exception

           

          ORA-06512: at "HUS_PORTAL.WWERR_API_EXCEPTION", line 71

           

          ORA-06512: at "HUS_PORTAL.WWV_CONTEXT", line 2118

           

          ORA-06510: PL/SQL: unhandled user-defined exception

           

          ORA-06512: at "HUS_PORTAL.WWERR_API_EXCEPTION", line 164

           

          ORA-06512: at "HUS_PORTAL.WWV_CONTEXT", line 2077

           

          ORA-06510: PL/SQL: unhandled user-defined exception

           

          ORA-06512: at "HUS_PORTAL.WWERR_API_EXCEPTION", line 71

           

          ORA-06512: at "HUS_PORTAL.WWV_CONTEXT", line 2010

           

          ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

           

          ORA-20000: Oracle Text error:

           

          DRG-10700: preference does not exist: CTXSYS.DEFAULT_WORDLIST

           

          ORA-06512: at line 6

           

          .....

          .....

          Setting Oracle Text to enabled

           

           

           

          PL/SQL procedure successfully completed.

           

           

           

          Database version is 10G - Text index upgrade job not required

           

           

           

          PL/SQL procedure successfully completed.

           

           

           

          INSTALL_ERROR: sqlExecuter() : Raised Exception oracle.webdb.config.PortalWiringException: Generated errors of type ORA-, PLS-, SP2-, ERROR: or IMP-. Refer to the log file for details.

           

          ERROR: Error during Text index creation and statistics gathering raised exception.

          2014-02-11 09:08:17.690 rcu:Executing SQL statement: drop tablespace HUS_PORTAL including contents and datafiles

           

           

           

          -----

          • 2. Re: RCU - 6135 Unable to create portal schema.
            Jayaprakash -Oracle

            Hi,

             

            Could you please check if Oracle text has been installed by using the below command :-

             

            --->  SELECT comp_name, status, substr(version,1,10) as version FROM dba_registry WHERE comp_id = 'CONTEXT';

            ----> select * from ctxsys.ctx_version;

             

            Ex :- when the above two commands were run the output would be as below :-

             

            SQL> SELECT comp_name, status, substr(version,1,10) as version FROM dba_registry WHERE comp_id = 'CONTEXT';

             

            COMP_NAME    STATUS     VERSION

            ---------    ------     -------

            Oracle Text  VALID      11.2.0.1.0

             

             

            SQL> select * from ctxsys.ctx_version;

             

            VER_DICT     VER_CODE

            --------     ----------

            11.2.0.1.0   11.2.0.1.0

             

             

             

            If the above doesn't show that oracle text is installed then please install Oracle text because Oracle text is required before you create schema for  Portal.

             

            Regards,

            Prakash.

            • 3. Re: RCU - 6135 Unable to create portal schema.
              Jayaprakash -Oracle

              Hi,

               

              Could you please let us kn ow if you were able to create schemas for Portal.

               

              Regards,

              Prakash.

              • 4. Re: RCU - 6135 Unable to create portal schema.
                Jayaprakash -Oracle

                Hello,

                 

                 

                If you feel that your question has been answered, please mark the response as "Correct Answer".  Also if you feel that a response has offered you value, please mark it as "Helpful Answer". It will make it easier for other community members to find replies that might help them in a similar situation, since your designation will make them stand out. This will also let members who have taken the time to respond to your posting know that they were able to help and a way to say thank you. :-)

                 

                Regards,

                Prakash.

                • 5. Re: RCU - 6135 Unable to create portal schema.
                  A.NANDA

                  Hello Prakash,

                  I am sorry, I could not respond earlier. I was able to install after doing some more work

                  In fact text was installed already but still I was getting the error.

                   

                  We need to have below items enabled/installed on the DB where RCU will be creating the schemas:

                   

                  Oracle Application Express       3.2.1.00.10           VALID

                  Oracle Label Security            11.2.0.1.0            VALID

                  OLAP Catalog                     11.2.0.1.0            VALID

                  Spatial                          11.2.0.1.0            VALID

                  Oracle Multimedia                11.2.0.1.0            VALID

                  Oracle XML Database              11.2.0.1.0            VALID

                  Oracle Text                      11.2.0.1.0            VALID

                  Oracle Expression Filter         11.2.0.1.0            VALID

                  Oracle Rules Manager             11.2.0.1.0            VALID

                  Oracle Workspace Manager         11.2.0.1.0            VALID

                  Oracle Database Catalog Views         11.2.0.1.0        VALID

                  Oracle Database Packages and Types    11.2.0.1.0        VALID

                  JServer JAVA Virtual Machine          11.2.0.1.0        VALID

                  Oracle XDK                            11.2.0.1.0        VALID

                  Oracle Database Java Packages         11.2.0.1.0        VALID

                  OLAP Analytic Workspace               11.2.0.1.0        VALID

                  Oracle OLAP API                       11.2.0.1.0        VALID

                  XAVIEW Installed

                   

                  Open-Cursors > 500

                  Processes > 500

                  Sessions > 300

                   

                  We did this & it worked.

                   

                  Thanks