Note:
when you didn't provide the username/password and just login by "sqlplus / as sydba"
it means you actually login as an authorized os user, you actually clearing the os authentication. However if you want to know the login user then just type show user, it shows the login user.
And now talk to problem i.e if facing problem while login to the Oracle10g via sqlplus / as sysdba.
The problem:
The solution:
Go to Control Panel. Select Administration tools, and then Computer management. The computer management tool allows you to modify user rights and local groups, so select this option in the tree on the left. Right click on your user name (I am assuming that you are logged in as administrator), and choose properties. On the second tab search for a group “ora_dba”.
Finally your user’s account should look like this:
Retest:
when you didn't provide the username/password and just login by "sqlplus / as sydba"
it means you actually login as an authorized os user, you actually clearing the os authentication. However if you want to know the login user then just type show user, it shows the login user.
And now talk to problem i.e if facing problem while login to the Oracle10g via sqlplus / as sysdba.
The problem:
1
2
3
4
5
6
7
8
| C:\>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 11 07:50:36 2012Copyright (c) 1982, 2010, Oracle. All rights reserved.ERROR:ORA-01031: niewystarczajace uprawnienia |
The solution:
Go to Control Panel. Select Administration tools, and then Computer management. The computer management tool allows you to modify user rights and local groups, so select this option in the tree on the left. Right click on your user name (I am assuming that you are logged in as administrator), and choose properties. On the second tab search for a group “ora_dba”.
Finally your user’s account should look like this:
Retest:
1
2
3
4
5
6
7
8
9
10
11
| C:\>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 11 08:08:43 2012Copyright (c) 1982, 2010, Oracle. All rights reserved.Connected to: Personal Oracle Database 11g Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> You can visit the site for your solution while performing operation on Oracle server.http://www.runningoracle.com/index.php?cPath=59&osCsid=9s18c2d488qstkncbgmu5j0fe4 |
No comments:
Post a Comment