Home » SQL & PL/SQL » SQL & PL/SQL » Problem with the product user profile (Oracle 12c Release 2)
Problem with the product user profile [message #673742] Fri, 07 December 2018 15:31 Go to next message
petar97
Messages: 120
Registered: October 2018
Senior Member
I'm connected as system user, when I tried to connect user conn user/password I get this messages
ERROR:
ORA-00942: table or view does not exist


Error accessing PRODUCT_USER_PROFILE
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.

When i tried @$ORACLE_HOME/sqlplus/admin/pupbld.sql I get this errors
SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql

Session altered.

DROP SYNONYM PRODUCT_USER_PROFILE
             *
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist


BEGIN
*
ERROR at line 1:
ORA-01654: unable to extend index SYS.I_OBJ1 by 8 in tablespace SYSTEM
ORA-06512: at line 21
ORA-06512: at line 2


DROP VIEW PRODUCT_PRIVS
*
ERROR at line 1:
ORA-00942: table or view does not exist


  FROM SQLPLUS_PRODUCT_PROFILE
       *
ERROR at line 4:
ORA-00942: table or view does not exist


GRANT SELECT ON PRODUCT_PRIVS TO PUBLIC
                *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP PUBLIC SYNONYM PRODUCT_PROFILE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


CREATE PUBLIC SYNONYM PRODUCT_PROFILE FOR SYSTEM.PRODUCT_PRIVS
*
ERROR at line 1:
ORA-01654: unable to extend index SYS.I_OBJ1 by 8 in tablespace SYSTEM


DROP SYNONYM PRODUCT_USER_PROFILE
             *
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist


CREATE SYNONYM PRODUCT_USER_PROFILE FOR SYSTEM.SQLPLUS_PRODUCT_PROFILE
*
ERROR at line 1:
ORA-01654: unable to extend index SYS.I_OBJ1 by 8 in tablespace SYSTEM


DROP PUBLIC SYNONYM PRODUCT_USER_PROFILE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


CREATE PUBLIC SYNONYM PRODUCT_USER_PROFILE FOR SYSTEM.PRODUCT_PRIVS
*
ERROR at line 1:
ORA-01654: unable to extend index SYS.I_OBJ1 by 8 in tablespace SYSTEM



Session altered.
I hope I explained the problem clearly. Thanks advance
Re: Problem with the product user profile [message #673743 is a reply to message #673742] Fri, 07 December 2018 16:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
my first guess is that the SYSTEM tablespace is FULL.

post results from SQL below

select * from dba_free_space where tablespace_name = 'SYSTEM';

TABLESPACE_NAME FILE_ID BLOCK_ID BYTES BLOCKS
------------------------------ ---------- ---------- ---------- ----------
RELATIVE_FNO
------------
SYSTEM 9 44104 5701632 696
1

Re: Problem with the product user profile [message #673744 is a reply to message #673743] Fri, 07 December 2018 17:02 Go to previous messageGo to next message
petar97
Messages: 120
Registered: October 2018
Senior Member
I did not mention that I just created a database


SQL> select * from dba_free_space where tablespace_name = 'SYSTEM';  

no rows selected
Re: Problem with the product user profile [message #673745 is a reply to message #673744] Fri, 07 December 2018 17:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
results may change when run from SYS schema
Re: Problem with the product user profile [message #673746 is a reply to message #673745] Fri, 07 December 2018 17:08 Go to previous messageGo to next message
petar97
Messages: 120
Registered: October 2018
Senior Member
I get the same results
Re: Problem with the product user profile [message #673748 is a reply to message #673746] Fri, 07 December 2018 17:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post results from SQL below

select sum(bytes/1024/1024) MB from dba_segments where tablespace_name ='SYSTEM';

MB
----------
343.5625

Re: Problem with the product user profile [message #673749 is a reply to message #673748] Fri, 07 December 2018 17:39 Go to previous messageGo to next message
petar97
Messages: 120
Registered: October 2018
Senior Member
SQL> select sum(bytes/1024/1024) MB from dba_segments where tablespace_name ='SYSTEM';

	MB
----------
       324
Re: Problem with the product user profile [message #673750 is a reply to message #673749] Fri, 07 December 2018 17:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
As I said the SYSTEM tablespace is FULL; no FREE space.
You can either make the existing file larger or you can add another file to this tablespace.
Re: Problem with the product user profile [message #673751 is a reply to message #673750] Fri, 07 December 2018 17:58 Go to previous messageGo to next message
petar97
Messages: 120
Registered: October 2018
Senior Member
SQL> alter tablespace users add datafile
  2  '/u01/oradata/MYNEWDB/data/users02.dbf'
  3  SIZE 300m autoextend on next 100m maxsize unlimited;
I add another file in tablespace, and i get same error

[Updated on: Fri, 07 December 2018 17:58]

Report message to a moderator

Re: Problem with the product user profile [message #673752 is a reply to message #673751] Fri, 07 December 2018 17:59 Go to previous messageGo to next message
petar97
Messages: 120
Registered: October 2018
Senior Member
SQL> conn
Enter user-name: petar
Enter password: 
ERROR:
ORA-00942: table or view does not exist


Error accessing PRODUCT_USER_PROFILE
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.

When I run PUBLD.SQL I get same errro

[Updated on: Fri, 07 December 2018 18:00]

Report message to a moderator

Re: Problem with the product user profile [message #673753 is a reply to message #673751] Fri, 07 December 2018 17:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
petar97 wrote on Fri, 07 December 2018 15:58
SQL> alter tablespace users add datafile
  2  '/u01/oradata/MYNEWDB/data/users02.dbf'
  3  SIZE 300m autoextend on next 100m maxsize unlimited;
I add another file in tablespace, and i get same error
You added the file to USERS tablespace; not SYSTEM tablespace!
Re: Problem with the product user profile [message #673754 is a reply to message #673753] Fri, 07 December 2018 18:06 Go to previous messageGo to next message
petar97
Messages: 120
Registered: October 2018
Senior Member
SQL> alter tablespace system add datafile
  2  '/u01/oradata/MYNEWDB/data/system02.dbf'
  3  SIZE 300m autoextend on next 100m maxsize unlimited;
Thank you very much!
In the land where I live is now very late and I'm sleepy(so I make mistakes) Smile

[Updated on: Fri, 07 December 2018 18:09]

Report message to a moderator

Re: Problem with the product user profile [message #673773 is a reply to message #673754] Mon, 10 December 2018 03:24 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Also adding the datafile alone probably won't fix anything.
What will do is allow you to run pupbld.sql sucessfully.
You'll still get the errors about objects to be dropped not existing - that's normal.
But it'll get rid of this one:
ERROR at line 1:
ORA-01654: unable to extend index SYS.I_OBJ1 by 8 in tablespace SYSTEM
Previous Topic: Need some help understanding parallels
Next Topic: Question on rank over partition
Goto Forum:
  


Current Time: Thu Mar 28 05:10:46 CDT 2024