Home » RDBMS Server » Security » errors in running pupbld.sql script (2 Merged) (oracle 10.2.0.3 win 7)
errors in running pupbld.sql script (2 Merged) [message #527544] Tue, 18 October 2011 13:57 Go to next message
shvn23
Messages: 5
Registered: October 2011
Location: Lucknow
Junior Member
i have created database manually and this is what happens when i run the script and try to login as a user :

I am executing the script with SYSTEM as dba

SQL> @?/sqlplus/admin/pupbld.sql;

Synonym dropped.

DATE_VALUE FROM PRODUCT_USER_PROFILE
*
ERROR at line 3:
ORA-00980: synonym translation is no longer valid


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


ALTER TABLE SQLPLUS_PRODUCT_PROFILE ADD (LONG_VALUE LONG)
*
ERROR at line 1:
ORA-01430: column being added already exists in table


CREATE TABLE SQLPLUS_PRODUCT_PROFILE
*
ERROR at line 1:
ORA-00955: name is already used by an existing object


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



View dropped.


View created.


Grant succeeded.


Synonym dropped.


Synonym created.

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



Synonym created.


Synonym dropped.


Synonym created.

SQL> connect hr/hr;
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL> show user;
USER is "HR"
SQL>
Re: errors in running pupbld.sql script [message #527549 is a reply to message #527544] Tue, 18 October 2011 14:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I am executing the script with SYSTEM as dba

Do you mean SYSTEM or SYSTEM AS SYSDBA?

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel


EDIT: fixed quote tags

[Updated on: Wed, 19 October 2011 04:49] by Moderator

Report message to a moderator

Re: errors in running pupbld.sql script [message #527680 is a reply to message #527549] Wed, 19 October 2011 13:44 Go to previous messageGo to next message
shvn23
Messages: 5
Registered: October 2011
Location: Lucknow
Junior Member
i mean SYSTEM as SYSDBA
Re: errors in running pupbld.sql script [message #527682 is a reply to message #527680] Wed, 19 October 2011 13:48 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
below is from the file itself

-- USAGE
-- sqlplus system/<system_password> @pupbld
--
Re: errors in running pupbld.sql script [message #527688 is a reply to message #527680] Wed, 19 October 2011 14:14 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
shvn23 wrote on Wed, 19 October 2011 20:44
i mean SYSTEM as SYSDBA


So this wrong:

Quote:
You may need to run PUPBLD.SQL as SYSTEM


When you connect <anything> AS SYSDBA, you are then SYS and no more <anything>.

Regards
Michel

Previous Topic: audit the update/modify and insert
Next Topic: oracle account limitation
Goto Forum:
  


Current Time: Thu Mar 28 13:47:46 CDT 2024