-
Does sys auomatically have sysdba priveledges?
I tried to grant sysdba to sys but it failed.
Below is what I did:
SQL> connect internal
Connected.
SQL> grant sysdba to sys;
grant sysdba to sys
*
ERROR at line 1:
ORA-01994: GRANT failed: cannot add users to public password file
SO I DID:
SQL> show parameter password
NAME TYPE VALUE
-------------------------- ------- -----
remote_login_passwordfile string NONE
SQL>
According to ORA-01994 I need set the password file to exclusive which I did.
So I started the database as follows and got an error:
SQL> startup
ORACLE instance started.
Total System Global Area 45268884 bytes
Fixed Size 73620 bytes
Variable Size 31916032 bytes
Database Buffers 13107200 bytes
Redo Buffers 172032 bytes
ORA-01990: error opening password file
'/oracle/app/oracle/product/8.1.7/dbs/orapw'
All I want is to grant sysdba to sys.
Any help?
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
|