hi i did the following
SQL>
SQL> connect test01/TEST01-Sep29
ERROR:
ORA-12560: TNS:protocol adapter error
SQL> connect test01/TEST01-Sep29@dbname
ERROR:
ORA-28001: the password has expired
Changing password for test01
New password:
Retype new password:
SP2-0650: New passwords do not match
Password unchanged
SQL> connect test01/TEST01-Sep29@dbname
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> connect test01/TEST01-Sep30@dbname
ERROR:
ORA-28001: the password has expired
Changing password for test01
New password:
Retype new password:
ERROR:
ORA-28041: Authentication protocol internal error
Password changed
ERROR:
ORA-01012: not logged on
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
ERROR:
ORA-01012: not logged on
Error accessing package DBMS_APPLICATION_INFO
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.
Connected.
SQL> connect test01/TEST01-Sep30@dbname
ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 0
Session ID: 0 Serial number: 0
ERROR:
ORA-28001: the password has expired
Changing password for test01
New password:
Retype new password:
ERROR:
ORA-28041: Authentication protocol internal error
Password changed
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
ERROR:
ORA-01012: not logged on
Error accessing package DBMS_APPLICATION_INFO
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.
Connected.
SQL>
i also did this
SQL> connect sys /as sysdba
Enter password:
Connected.
SQL> @pupbld.sql
Session altered.
DROP SYNONYM PRODUCT_USER_PROFILE
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist
PL/SQL procedure successfully completed.
DROP VIEW PRODUCT_PRIVS
*
ERROR at line 1:
ORA-00942: table or view does not exist
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.
Session altered.
SQL> commit;
Commit complete.
SQL>