Oracle error ORA-65052: statement involves operations with different container scope

oracleoracle-12c

I'm a relative newb to Oracle. I have set up an instance of Oracle 12c running on a RHEL 7 VM. I am connecting to the database created during installation through and running some installation scripts.

Below is the output from the script that I am trying to run, can anyone point me in the right direction? I have a feeling I'm doing something fundamentally wrong.

Error starting at line : 4 in command -
GRANT CONNECT TO TDSUSER IDENTIFIED BY "TDSPASSWORD"
Error report -
SQL Error: ORA-65052: statement involves operations with different container scope
65052. 00000 -  "statement involves operations with different container scope"
*Cause:    An attempt was made to combine one operation that applies to all
           containers with another that only applies to the local container
           into one statement.
*Action:   Execute the operations in separate statements.
old:ALTER USER TDSUSER DEFAULT TABLESPACE &TBLSPC_TDS_TABLES TEMPORARY TABLESPACE &TBLSPC_TDS_TEMP PROFILE &DBPROFILE
new:ALTER USER TDSUSER DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp PROFILE TRIDION_SYS

Error starting at line : 6 in command -
ALTER USER TDSUSER DEFAULT TABLESPACE &TBLSPC_TDS_TABLES TEMPORARY TABLESPACE &TBLSPC_TDS_TEMP PROFILE &DBPROFILE
Error report -
SQL Error: ORA-02380: profile TRIDION_SYS does not exist
02380. 00000 -  "profile %s does not exist"
*Cause:    Try to assign a user to a non-existant profile
*Action:

Best Answer

I think this Q & A on the Tridion beta Stack Exchange site may help you:

Oracle Content Delivery CreateTridionSYSUser.sql errors

Basically you need to be in the pluggable database because of the multi-tenancy that is a new feature of 12c.

alter session set container=pdborcl;

Related Solutions

Linux – ORA-00905: missing keyword

there's a space missing before to in 'to myuser'.

BEGIN
FOR X in (select * from all_tables where owner in ('TESTDTA', 'TESTCTL'))
LOOP
    EXECUTE IMMEDIATE 'GRANT SELECT, INSERT, UPDATE, DELETE ON '
        ||X.owner||'.'||X.table_name||
        ' to TESTUSER';
END LOOP;
END;
/

Error While Calling A Procedure

When you create an object in Oracle with double quotes, Oracle creates that objects with the same case as you entered it. Try dropping the "insert_family" procedure and creating it without the double quotes.

This should help.

SQL> CREATE TABLE family
  2       ( NAME          VARCHAR2(25),
  3         NICK_NAME     VARCHAR2(15),
  4         GENDER        CHAR(1),
  5         AGE           NUMBER(3),
  6         MARITL_STATUS VARCHAR2(15),
  7         QUALIFICTN    VARCHAR2(20),
  8         NO_OF_CHLDRN  NUMBER(2) );

Table created.

SQL>
SQL> create or replace procedure "insert_family"
  2     ( NAME varchar2 ,
  3       NICK_NAME varchar2 ,
  4       GENDER VARCHAR2,
  5       AGE number,
  6       MARITL_STAUS varchar2,
  7       QUALIFICTN varchar2,
  8       NO_OF_CHLDRN number)
  9  is
 10  begin
 11  insert into family values(NAME,NICK_NAME,GENDER,AGE,MARITL_STAUS,QUALIFICTN,NO_OF_CHLDRN);
 12  end;
 13  /

Procedure created.

SQL>
SQL> create or replace procedure "Insert_family"
  2     ( NAME varchar2 ,
  3       NICK_NAME varchar2 ,
  4       GENDER VARCHAR2,
  5       AGE number,
  6       MARITL_STAUS varchar2,
  7       QUALIFICTN varchar2,
  8       NO_OF_CHLDRN number)
  9  is
 10  begin
 11  insert into family values(NAME,NICK_NAME,GENDER,AGE,MARITL_STAUS,QUALIFICTN,NO_OF_CHLDRN);
 12  end;
 13  /

Procedure created.

SQL>
SQL> create or replace procedure "iNsert_family"
  2     ( NAME varchar2 ,
  3       NICK_NAME varchar2 ,
  4       GENDER VARCHAR2,
  5       AGE number,
  6       MARITL_STAUS varchar2,
  7       QUALIFICTN varchar2,
  8       NO_OF_CHLDRN number)
  9  is
 10  begin
 11  insert into family values(NAME,NICK_NAME,GENDER,AGE,MARITL_STAUS,QUALIFICTN,NO_OF_CHLDRN);
 12  end;
 13  /

Procedure created.

SQL>
SQL> create or replace procedure "inSert_family"
  2     ( NAME varchar2 ,
  3       NICK_NAME varchar2 ,
  4       GENDER VARCHAR2,
  5       AGE number,
  6       MARITL_STAUS varchar2,
  7       QUALIFICTN varchar2,
  8       NO_OF_CHLDRN number)
  9  is
 10  begin
 11  insert into family values(NAME,NICK_NAME,GENDER,AGE,MARITL_STAUS,QUALIFICTN,NO_OF_CHLDRN);
 12  end;
 13  /

Procedure created.

SQL>
SQL> exec insert_family('AYUSH','SHUKLA','MALE',12,'UNMARRIED','SCHOOL',0);
BEGIN insert_family('AYUSH','SHUKLA','MALE',12,'UNMARRIED','SCHOOL',0); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'INSERT_FAMILY' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


SQL> select object_name, object_type, status from user_objects where upper(object_name)=upper('inSert_family') order by 1;

OBJECT_NAME                    OBJECT_TYPE          STATUS
------------------------------ -------------------- ------------
Insert_family                  PROCEDURE            VALID
iNsert_family                  PROCEDURE            VALID
inSert_family                  PROCEDURE            VALID
insert_family                  PROCEDURE            VALID

4 rows selected.