Home » RDBMS Server » Server Administration » insufficient privileges for sys
insufficient privileges for sys [message #565152] |
Fri, 31 August 2012 01:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/0d8d54604424af68f3c669fe2bc54c02?s=64&d=mm&r=g) |
neetesh87
Messages: 280 Registered: September 2011 Location: bhopal
|
Senior Member |
|
|
hello experts,
i have a problem when i try to connect with my database by using sys
then it gives an error of insufficient privileges to sys.
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Aug 31 12:12:47 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: sys@testdb as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges
Enter user-name: system@testdb
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> grant all privileges to sys;
Grant succeeded.
SQL> conn sys@testdb as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
SQL>
then what should i do to access my sys user?
thanks in advance........
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: insufficient privileges for sys [message #565208 is a reply to message #565203] |
Fri, 31 August 2012 10:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/0d8d54604424af68f3c669fe2bc54c02?s=64&d=mm&r=g) |
neetesh87
Messages: 280 Registered: September 2011 Location: bhopal
|
Senior Member |
|
|
C:\Users>dir /n
Volume in drive C has no label.
Volume Serial Number is A681-24CE
Directory of C:\Users
08/31/2012 07:18 PM <DIR> .
08/31/2012 07:18 PM <DIR> ..
07/27/2012 06:02 PM 98,643,968 aepuser_exp.dmp
07/27/2012 06:10 PM 98,646,016 aepuser_tbls.DMP
05/23/2012 04:55 PM <DIR> Contacts
07/24/2012 04:53 PM 8,192 data.dmp
08/31/2012 07:39 PM <DIR> Desktop
07/24/2012 12:57 PM 8,192 dmp.DMP
08/10/2012 04:51 PM <DIR> Documents
08/31/2012 08:02 PM <DIR> Downloads
07/24/2012 04:00 PM 10,240 exp.dmp
07/27/2012 06:24 PM 0 expdp
08/09/2012 12:20 PM <DIR> Favorites
05/23/2012 04:55 PM <DIR> Links
08/21/2012 07:21 PM <DIR> Music
07/06/2012 02:35 PM <DIR> New folder
05/23/2012 05:15 PM <DIR> Oracle
05/23/2012 07:23 PM <DIR> Pictures
08/31/2012 07:18 PM 1,536 pwtestdb
07/20/2012 06:17 PM 304 row_rules_data.ctl
07/19/2012 07:43 PM 300 row_rules_data.log
05/23/2012 04:55 PM <DIR> Saved Games
07/24/2012 02:04 PM 12,288 scott_tbl.dmp
05/28/2012 01:42 PM <DIR> Searches
08/31/2012 12:12 PM 22,111 sqlnet.log
07/24/2012 03:47 PM 16,384 tbl_exp.dmp
07/24/2012 11:37 AM 7,210 test.log
07/24/2012 11:35 AM 298 text_data.log
05/23/2012 04:55 PM <DIR> Videos
07/25/2012 11:59 AM 89,710,592 wlm_tbl_exp.dmp
15 File(s) 287,087,631 bytes
15 Dir(s) 58,093,903,872 bytes free
C:\Users>orapwd file=orapwtestdb password=test entries=sysdba force=yes
nosysdba=n;
Usage: orapwd file=<fname> entries=<users> force=<y/n> ignorecase=<y/n> nosysdba
=<y/n>
where
file - name of password file (required),
password - password for SYS will be prompted if not specified at command lin
e,
entries - maximum number of distinct DBA (optional),
force - whether to overwrite existing file (optional),
ignorecase - passwords are case-insensitive (optional),
nosysdba - whether to shut out the SYSDBA logon (optional Database Vault onl
y).
There must be no spaces around the equal-to (=) character.
C:\Users>dir /n
Volume in drive C has no label.
Volume Serial Number is A681-24CE
Directory of C:\Users
08/31/2012 07:18 PM <DIR> .
08/31/2012 07:18 PM <DIR> ..
07/27/2012 06:02 PM 98,643,968 aepuser_exp.dmp
07/27/2012 06:10 PM 98,646,016 aepuser_tbls.DMP
05/23/2012 04:55 PM <DIR> Contacts
07/24/2012 04:53 PM 8,192 data.dmp
08/31/2012 07:39 PM <DIR> Desktop
07/24/2012 12:57 PM 8,192 dmp.DMP
08/10/2012 04:51 PM <DIR> Documents
08/31/2012 08:50 PM <DIR> Downloads
07/24/2012 04:00 PM 10,240 exp.dmp
07/27/2012 06:24 PM 0 expdp
08/09/2012 12:20 PM <DIR> Favorites
05/23/2012 04:55 PM <DIR> Links
08/21/2012 07:21 PM <DIR> Music
07/06/2012 02:35 PM <DIR> New folder
05/23/2012 05:15 PM <DIR> Oracle
05/23/2012 07:23 PM <DIR> Pictures
08/31/2012 07:18 PM 1,536 pwtestdb
07/20/2012 06:17 PM 304 row_rules_data.ctl
07/19/2012 07:43 PM 300 row_rules_data.log
05/23/2012 04:55 PM <DIR> Saved Games
07/24/2012 02:04 PM 12,288 scott_tbl.dmp
05/28/2012 01:42 PM <DIR> Searches
08/31/2012 12:12 PM 22,111 sqlnet.log
07/24/2012 03:47 PM 16,384 tbl_exp.dmp
07/24/2012 11:37 AM 7,210 test.log
07/24/2012 11:35 AM 298 text_data.log
05/23/2012 04:55 PM <DIR> Videos
07/25/2012 11:59 AM 89,710,592 wlm_tbl_exp.dmp
15 File(s) 287,087,631 bytes
15 Dir(s) 58,058,457,088 bytes free
C:\Users>
thanks..........
|
|
|
|
Re: insufficient privileges for sys [message #565316 is a reply to message #565213] |
Mon, 03 September 2012 08:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/0d8d54604424af68f3c669fe2bc54c02?s=64&d=mm&r=g) |
neetesh87
Messages: 280 Registered: September 2011 Location: bhopal
|
Senior Member |
|
|
sorry to made a mistake.
now i have run this command on cmd-
query to show content before creation of pwdfile-
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Neetesh>dir /p
Volume in drive C has no label.
Volume Serial Number is A681-24CE
Directory of C:\Users\Neetesh
08/31/2012 07:18 PM <DIR> .
08/31/2012 07:18 PM <DIR> ..
07/27/2012 06:02 PM 98,643,968 aepuser_exp.dmp
07/27/2012 06:10 PM 98,646,016 aepuser_tbls.DMP
05/23/2012 04:55 PM <DIR> Contacts
07/24/2012 04:53 PM 8,192 data.dmp
09/03/2012 06:32 PM <DIR> Desktop
07/24/2012 12:57 PM 8,192 dmp.DMP
08/10/2012 04:51 PM <DIR> Documents
08/31/2012 09:37 PM <DIR> Downloads
07/24/2012 04:00 PM 10,240 exp.dmp
07/27/2012 06:24 PM 0 expdp
08/09/2012 12:20 PM <DIR> Favorites
05/23/2012 04:55 PM <DIR> Links
08/21/2012 07:21 PM <DIR> Music
07/06/2012 02:35 PM <DIR> New folder
05/23/2012 05:15 PM <DIR> Oracle
05/23/2012 07:23 PM <DIR> Pictures
Press any key to continue . . .
C:\Users\Neetesh>orapwd file=PWDTESTDB password=test ENTRIES=1
query to show content after creation of pwdfile-
C:\Users\Neetesh>dir /p
Volume in drive C has no label.
Volume Serial Number is A681-24CE
Directory of C:\Users\Neetesh
09/03/2012 06:52 PM <DIR> .
09/03/2012 06:52 PM <DIR> ..
07/27/2012 06:02 PM 98,643,968 aepuser_exp.dmp
07/27/2012 06:10 PM 98,646,016 aepuser_tbls.DMP
05/23/2012 04:55 PM <DIR> Contacts
07/24/2012 04:53 PM 8,192 data.dmp
09/03/2012 06:32 PM <DIR> Desktop
07/24/2012 12:57 PM 8,192 dmp.DMP
08/10/2012 04:51 PM <DIR> Documents
08/31/2012 09:37 PM <DIR> Downloads
07/24/2012 04:00 PM 10,240 exp.dmp
07/27/2012 06:24 PM 0 expdp
08/09/2012 12:20 PM <DIR> Favorites
05/23/2012 04:55 PM <DIR> Links
08/21/2012 07:21 PM <DIR> Music
07/06/2012 02:35 PM <DIR> New folder
05/23/2012 05:15 PM <DIR> Oracle
05/23/2012 07:23 PM <DIR> Pictures
09/03/2012 06:52 PM 1,536 PWDTESTDB
Press any key to continue . . .
and then i cut-paste this password file into database folder
of db_home where bydefault the password file resides.
and then i run this command from sqlplus-
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 3 19:18:51 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: sys@testdb as sysdba
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
and i also tried with that password which is given for password file-
Enter user-name: sys/test@testdb as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
thanks....
|
|
|
|
|
|
|
Goto Forum:
Current Time: Fri May 31 21:26:01 CDT 2024
|