|
-
Originally posted by elintrend
SELECT * FROM v$pwfile_users WHERE sysdba='TRUE'
and it return error as below
ERROR:
ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], []
This is a known bug in 8.1.5, fixed in 8.1.6. For a workaround, add an ORDER BY clause and it will work:
SELECT * FROM v$pwfile_users WHERE sysdba='TRUE'
ORDER BY 1;
also
connect / as sysdba
grand sysdba to user username
error show beloww
ORA-01994: GRANT failed: cannot add users to public password file
In Error Messages manual you'll find the explanation:
ORA-01994 GRANT failed: cannot add users to public password file
Cause: A grant failed because a user could not be added to the password file.
This is because the value of the REMOTE_LOGIN_PASSWORDFILE
initialization parameter is set to PUBLIC.
Action: To add a user to the password file, shutdown the database, change the
REMOTE_LOGIN_PASSWORDFILE initialization parameter to PRIVATE, and
restart the database.
HTH,
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|