9 Replies Latest reply: Mar 20, 2014 5:59 AM by RAKESH CHUNCHEGOWDA RSS

    Cannot install OBIEE 11.1.1.7 with Database 12c

    RAKESH CHUNCHEGOWDA

      My plan for preparing a latest OBI setup

      1. Install database 12c - http://docs.oracle.com/cd/E16655_01/install.121/e17720/inst_task.htm#BABJGGJH

           (In typical Installation screen, selected Create as Container Database & Pluggable database name : pdborcl, Global Database name was orcl, character set selected as AL32UTF8)

      2. Check all prerequisites for OBIEE installation

      3. Check RCU prerequisites for repository creation - http://docs.oracle.com/html/E38687_01/12c_fusion_requirements.htm#CHDJGECA

           (Changed DB parameters as required)

      4. "Create Database Schemas Using the Repository Creation Utility (RCU)"

           (Service Name: orcl, Username: SYS)

      The plan went well until last step in  "Create Database Schemas Using the Repository Creation Utility (RCU)"

       

      And I receive this error with a Ignore and Stop button underneath:

      ORA-65096: invalid common user or role name

      File:/home/oracle/Downloads/RCU/ofm_rcu_linux_11.1.1.7.0_64_disk1_1of1/rcuHome/rcu/integration//mds/sql/mds_user.sql

      Statement:CREATE USER &&1 IDENTIFIED BY ****** DEFAULT TABLESPACE &&3 TEMPORARY TABLESPACE &&4

      I selected Stop and haven't been able to continue since.

       

      mds.log:

      2013-10-21 11:33:58.929 rcu:Extracting Statement from File Name: '/home/oracle/Downloads/RCU/ofm_rcu_linux_11.1.1.7.0_64_disk1_1of1/rcuHome/rcu/integration//mds/sql/mds_user.sql'Line Number: 32

      2013-10-21 11:33:58.929 rcu:Extracted SQL Statement: [CREATE USER &&1 IDENTIFIED BY "&&2" DEFAULT TABLESPACE &&3 TEMPORARY TABLESPACE &&4]

      2013-10-21 11:33:58.929 rcu:Statement Type: 'DDL Statement'

      JDBC SQLException - ErrorCode: 65096SQLState:99999 Message: ORA-65096: invalid common user or role name

       

      Error encountered executing SQL statement  FileName: '/home/oracle/Downloads/RCU/ofm_rcu_linux_11.1.1.7.0_64_disk1_1of1/rcuHome/rcu/integration//mds/sql/mds_user.sql' LineNumber: '34'

      SQL Statement: [CREATE USER &&1 IDENTIFIED BY ****** DEFAULT TABLESPACE &&3 TEMPORARY TABLESPACE &&4]

      java.sql.SQLException: ORA-65096: invalid common user or role name

       

      2013-10-22 06:15:36.543 rcu:Executing SQL statement: DROP USER DEV_MDS CASCADE

      JDBC SQLException - ErrorCode: 1918SQLState:42000 Message: ORA-01918: user 'DEV_MDS' does not exist

       

      JDBC SQLException handled by error handler

       

       

      2013-10-22 06:15:39.607 rcu:Executing SQL statement: drop tablespace DEV_MDS including contents and datafiles

       

      2013-10-22 06:15:45.501 rcu:Executing SQL statement: drop tablespace DEV_IAS_TEMP including contents and datafiles

       

       

      biplatform.log:

      2013-10-21 11:42:39.555 rcu:Extracting Statement from File Name: '/home/oracle/Downloads/RCU/ofm_rcu_linux_11.1.1.7.0_64_disk1_1of1/rcuHome/rcu/integration//biplatform/scripts/oracle/create_user.sql'Line Number: 1

      2013-10-21 11:42:39.555 rcu:Extracted SQL Statement: [CREATE USER &&1 identified by &&2 default tablespace &&3 temporary tablespace &&4]

      2013-10-21 11:42:39.555 rcu:Statement Type: 'DDL Statement'

      JDBC SQLException - ErrorCode: 65096SQLState:99999 Message: ORA-65096: invalid common user or role name

       

      Error encountered executing SQL statement  FileName: '/home/oracle/Downloads/RCU/ofm_rcu_linux_11.1.1.7.0_64_disk1_1of1/rcuHome/rcu/integration//biplatform/scripts/oracle/create_user.sql' LineNumber: '1'

      SQL Statement: [CREATE USER &&1 identified by ****** default tablespace &&3 temporary tablespace &&4]

      java.sql.SQLException: ORA-65096: invalid common user or role name

       

      2013-10-22 06:15:45.853 rcu:Executing SQL statement: DROP USER DEV_BIPLATFORM CASCADE

      JDBC SQLException - ErrorCode: 1918SQLState:42000 Message: ORA-01918: user 'DEV_BIPLATFORM' does not exist

       

      JDBC SQLException handled by error handler

       

       

      2013-10-22 06:15:48.896 rcu:Executing SQL statement: drop tablespace DEV_BIPLATFORM including contents and datafiles

       

      2013-10-22 06:15:54.278 rcu:Executing SQL statement: drop tablespace DEV_IAS_TEMP including contents and datafiles

       

      JDBC SQLException - ErrorCode: 959SQLState:42000 Message: ORA-00959: tablespace 'DEV_IAS_TEMP' does not exist

       

      JDBC SQLException handled by error handler

       

       

      I have found this Doc ID 1573640.1that has similar issue but not sure how it could help.


      Any idea how I can continue with this installation ?