This discussion is archived
7 Replies Latest reply: Mar 21, 2013 9:14 AM by Turbokat RSS

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

Sudha777 Explorer
Currently Being Moderated
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
  • 1. Re: RCU-6130:Action failed.RCU-6131:Error while trying to connect to database
    Turbokat Pro
    Currently Being Moderated
    What does your rcu.log say .?
  • 2. Re: RCU-6130:Action failed.RCU-6131:Error while trying to connect to database
    Sudha777 Explorer
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    Are you installing after a failed install again .?
  • 5. Re: RCU-6130:Action failed.RCU-6131:Error while trying to connect to database
    Turbokat Pro
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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?!
    :)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points