Currently Being Moderated
Sorry I cannot format to the output...
SQL> connect USER/PASSWORD
Connected.
SQL> select * from user_role_privs;
USERNAME GRANTED_ROLE ADM DEF OS_
-------- ------------ --- --- ---
USER CONNECT NO YES NO
USER DBA NO YES NO
USER RESOURCE NO YES NO
SQL> connect USER/PASSWORD as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
SQL> connect sys/change_on_install as sysdba;
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
SQL> connect sys/change_on_install
Connected.
SQL> select * from v$pwfile_users;
ERROR:
ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [],[]
no rows selected
SQL>
I found that password file doesn't exist so I created it.
C:\>orapwd file=PWDORCL.ORA password=password
I cannot restart server until one hour to update change.
