Problem with the product user profile [message #673742] |
Fri, 07 December 2018 15:31 |
|
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 #673773 is a reply to message #673754] |
Mon, 10 December 2018 03:24 |
cookiemonster
Messages: 13943 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
|
|
|