7 Replies Latest reply: Mar 21, 2013 11:14 AM by Turbokat RSS

    RCU-6130:Action failed.RCU-6131:Error while trying to connect to database

    Sudha777
      Hi,

      Iam facing issue while installing RCU in UBUNTU, its unable to create MDS schema showing "RCU-6130:Action failed.RCU-6131:Error while trying to connect to database" error.

      Any solutions welcome plz
        • 2. Re: RCU-6130:Action failed.RCU-6131:Error while trying to connect to database
          Sudha777
          2013-03-20 17:53:17.450 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/mds_user.sql'Line Number: 30
          2013-03-20 17:53:17.450 rcu:Extracted SQL Statement: [CREATE USER &&1 IDENTIFIED BY &&2 DEFAULT TABLESPACE &&3 TEMPORARY TABLESPACE &&4]
          2013-03-20 17:53:17.450 rcu:Statement Type: 'DDL Statement'
          JDBC SQLException - ErrorCode: 1920SQLState:42000 Message: ORA-01920: user name 'DEV_MDS' conflicts with another user or role name

          JDBC SQLException handled by error handler


          2013-03-20 17:53:17.475 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/mds_user.sql'Line Number: 32
          2013-03-20 17:53:17.475 rcu:Extracted SQL Statement: [GRANT connect TO &&1]
          2013-03-20 17:53:17.475 rcu:Statement Type: 'DDL Statement'
          2013-03-20 17:53:17.542 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/mds_user.sql'Line Number: 33
          2013-03-20 17:53:17.543 rcu:Extracted SQL Statement: [GRANT create type TO &&1]
          2013-03-20 17:53:17.543 rcu:Statement Type: 'DDL Statement'
          2013-03-20 17:53:17.559 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/mds_user.sql'Line Number: 34
          2013-03-20 17:53:17.559 rcu:Extracted SQL Statement: [GRANT create procedure TO &&1]
          2013-03-20 17:53:17.559 rcu:Statement Type: 'DDL Statement'
          2013-03-20 17:53:17.576 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/mds_user.sql'Line Number: 35
          2013-03-20 17:53:17.576 rcu:Extracted SQL Statement: [GRANT create table TO &&1]
          2013-03-20 17:53:17.576 rcu:Statement Type: 'DDL Statement'
          2013-03-20 17:53:17.592 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/mds_user.sql'Line Number: 36
          2013-03-20 17:53:17.593 rcu:Extracted SQL Statement: [GRANT create sequence TO &&1]
          2013-03-20 17:53:17.593 rcu:Statement Type: 'DDL Statement'
          2013-03-20 17:53:17.609 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/mds_user.sql'Line Number: 39
          2013-03-20 17:53:17.609 rcu:Extracted SQL Statement: [ALTER USER &&1 QUOTA unlimited ON &&3]
          2013-03-20 17:53:17.610 rcu:Statement Type: 'DDL Statement'
          2013-03-20 17:53:17.634 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/mds_user.sql'Line Number: 40
          2013-03-20 17:53:17.635 rcu:Extracted SQL Statement: [DECLARE
          cnt NUMBER;
          package_not_found EXCEPTION;
          PRAGMA EXCEPTION_INIT(package_not_found, -00942);

          insufficient_privs EXCEPTION;
          PRAGMA EXCEPTION_INIT(insufficient_privs, -01031);
          BEGIN

          cnt := 0;
          SELECT count(*) INTO cnt FROM dba_tab_privs WHERE grantee = 'PUBLIC'
          AND owner='SYS' AND table_name='DBMS_OUTPUT'
          AND privilege='EXECUTE';
          IF (cnt = 0) THEN
          -- Grant MDS user execute on dbms_output only if PUBLIC
          -- doesn't have the privilege.
          EXECUTE IMMEDIATE 'GRANT execute ON dbms_output TO &&1';
          END IF;

          cnt := 0;
          SELECT count(*) INTO cnt FROM dba_tab_privs WHERE grantee = 'PUBLIC'
          AND owner='SYS' AND table_name='DBMS_LOB'
          AND privilege='EXECUTE';
          IF (cnt = 0) THEN
          -- Grant MDS user execute on dbms_lob only if PUBLIC
          -- doesn't have the privilege.
          EXECUTE IMMEDIATE 'GRANT execute ON dbms_lob TO &&1';
          END IF;

          EXCEPTION
          -- If the user doesn't have privilege to access dbms_* package,
          -- database will report that the package cannot be found. RCU
          -- even doesn't throw the exception to the user, since ORA-00942
          -- is an ignored error defined in its global configuration xml
          -- file.
          WHEN package_not_found THEN
          RAISE insufficient_privs;
          WHEN OTHERS THEN
          RAISE;
          END;
          ]
          2013-03-20 17:53:17.635 rcu:Statement Type: 'BEGIN/END Anonymous Block'
          2013-03-20 17:53:17.694 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/cremds-rcu.sql'Line Number: 27
          2013-03-20 17:53:17.694 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/cremds-rcu.sql'Line Number: 28
          2013-03-20 17:53:17.694 rcu:Extracted SQL Statement: [SET ECHO ON]
          2013-03-20 17:53:17.694 rcu:Skipping Unsupported Statement
          2013-03-20 17:53:17.694 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/cremds-rcu.sql'Line Number: 29
          2013-03-20 17:53:17.695 rcu:Extracted SQL Statement: [SET FEEDBACK 1]
          2013-03-20 17:53:17.695 rcu:Skipping Unsupported Statement
          2013-03-20 17:53:17.695 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/cremds-rcu.sql'Line Number: 30
          2013-03-20 17:53:17.695 rcu:Extracted SQL Statement: [SET NUMWIDTH 10]
          2013-03-20 17:53:17.695 rcu:Skipping Unsupported Statement
          2013-03-20 17:53:17.695 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/cremds-rcu.sql'Line Number: 31
          2013-03-20 17:53:17.695 rcu:Extracted SQL Statement: [SET LINESIZE 80]
          2013-03-20 17:53:17.695 rcu:Skipping Unsupported Statement
          2013-03-20 17:53:17.695 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/cremds-rcu.sql'Line Number: 32
          2013-03-20 17:53:17.695 rcu:Extracted SQL Statement: [SET TRIMSPOOL ON]
          2013-03-20 17:53:17.695 rcu:Skipping Unsupported Statement
          2013-03-20 17:53:17.696 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/cremds-rcu.sql'Line Number: 33
          2013-03-20 17:53:17.696 rcu:Extracted SQL Statement: [SET TAB OFF]
          2013-03-20 17:53:17.696 rcu:Skipping Unsupported Statement
          2013-03-20 17:53:17.696 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/cremds-rcu.sql'Line Number: 34
          2013-03-20 17:53:17.696 rcu:Extracted SQL Statement: [SET PAGESIZE 100]
          2013-03-20 17:53:17.696 rcu:Skipping Unsupported Statement
          2013-03-20 17:53:17.696 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration//mds/sql/cremds-rcu.sql'Line Number: 35
          2013-03-20 17:53:17.696 rcu:Extracted SQL Statement: [ALTER SESSION SET CURRENT_SCHEMA=&&1]
          2013-03-20 17:53:17.696 rcu:Statement Type: 'DDL Statement'
          2013-03-20 17:53:17.712 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration/mds/sql/cremds.sql'Line Number: 36
          2013-03-20 17:53:17.713 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration/mds/sql/cremds.sql'Line Number: 37
          2013-03-20 17:53:17.713 rcu:Extracted SQL Statement: [SET ECHO ON]
          2013-03-20 17:53:17.713 rcu:Skipping Unsupported Statement
          2013-03-20 17:53:17.713 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration/mds/sql/cremds.sql'Line Number: 38
          2013-03-20 17:53:17.713 rcu:Extracted SQL Statement: [SET FEEDBACK 1]
          2013-03-20 17:53:17.713 rcu:Skipping Unsupported Statement
          2013-03-20 17:53:17.713 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration/mds/sql/cremds.sql'Line Number: 39
          2013-03-20 17:53:17.713 rcu:Extracted SQL Statement: [SET NUMWIDTH 10]
          2013-03-20 17:53:17.713 rcu:Skipping Unsupported Statement
          2013-03-20 17:53:17.714 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration/mds/sql/cremds.sql'Line Number: 40
          2013-03-20 17:53:17.714 rcu:Extracted SQL Statement: [SET LINESIZE 80]
          2013-03-20 17:53:17.714 rcu:Skipping Unsupported Statement
          2013-03-20 17:53:17.714 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration/mds/sql/cremds.sql'Line Number: 41
          2013-03-20 17:53:17.714 rcu:Extracted SQL Statement: [SET TRIMSPOOL ON]
          2013-03-20 17:53:17.714 rcu:Skipping Unsupported Statement
          2013-03-20 17:53:17.714 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration/mds/sql/cremds.sql'Line Number: 42
          2013-03-20 17:53:17.714 rcu:Extracted SQL Statement: [SET TAB OFF]
          2013-03-20 17:53:17.714 rcu:Skipping Unsupported Statement
          2013-03-20 17:53:17.714 rcu:Extracting Statement from File Name: '/obiapps/RCU/rcuHome/rcu/integration/mds/sql/cremds.sql'Line Number: 43
          2013-03-20 17:53:17.715 rcu:Extracted SQL Statement: [SET PAGESIZE 100]
          2013-03-20 17:53:17.715 rcu:Skipping Unsupported Statement
          /obiapps/RCU/rcuHome/rcu/integration/mds/sql/cremdcmtbs.sql (No such file or directory)
          • 3. Re: RCU-6130:Action failed.RCU-6131:Error while trying to connect to database
            Turbokat
            Are you installing after a failed install again .?
            • 5. Re: RCU-6130:Action failed.RCU-6131:Error while trying to connect to database
              Turbokat
              You need to drop and recreate the schemas.

              Please follow the guide : http://docs.oracle.com/cd/E23943_01/doc.1111/e14259/rcu.htm#RCUUG196

              let us know if you have any questions.

              Hope this helps. mark if helps.

              Thanks,
              SVS
              • 6. Re: RCU-6130:Action failed.RCU-6131:Error while trying to connect to database
                Christian Berg
                Oh come on...
                1.) read an error message
                2.) see this: ORA-01920: user name 'DEV_MDS' conflicts with another user or role name
                3.) google?!
                • 7. Re: RCU-6130:Action failed.RCU-6131:Error while trying to connect to database
                  Turbokat
                  Christian Berg wrote:
                  Oh come on...
                  1.) read an error message
                  2.) see this: ORA-01920: user name 'DEV_MDS' conflicts with another user or role name
                  3.) google?!
                  :)