Home » Infrastructure » Windows » system admin log in error
system admin log in error [message #576595] Wed, 06 February 2013 07:43 Go to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
hello experts,

i want to log-in my local machine database as a system administrator ,
but it is giving an error:


C:\Windows\system32>sqlplus /@myprodb as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:18:15 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name:



C:\Windows\system32>sqlplus /@myprodb as sysoper

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:19:28 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name:




but

C:\Windows\system32>sqlplus sys@myprodb as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:20:45 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

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>



and i have run cmd as administrator

am i missing something?

thanks in advance.......
Re: system admin log in error [message #576596 is a reply to message #576595] Wed, 06 February 2013 08:04 Go to previous messageGo to next message
Roachcoach
Messages: 1178
Registered: May 2010
Location: UK
Senior Member
Your windows account is probably not in the correct dba group.

[Updated on: Wed, 06 February 2013 08:09]

Report message to a moderator

Re: system admin log in error [message #576597 is a reply to message #576596] Wed, 06 February 2013 08:37 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks for your kind response.

Quote:


Your windows account is probably not in the correct dba group.



then what DBA group is needed for it.

thanks....
Re: system admin log in error [message #576600 is a reply to message #576597] Wed, 06 February 2013 08:52 Go to previous messageGo to next message
Roachcoach
Messages: 1178
Registered: May 2010
Location: UK
Senior Member
From memory (not looked at a windows box in a while) ORA_DBA is the windows user group.

If I'm wrong, my apologies, it'll be in the documents though.
Re: system admin log in error [message #576601 is a reply to message #576596] Wed, 06 February 2013 08:58 Go to previous messageGo to next message
Michel Cadot
Messages: 58532
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Roachcoach wrote on Wed, 06 February 2013 15:04
Your windows account is probably not in the correct dba group.


This is not the problem: remote connection (when you use @xxx) do not use OS group but password file and password is mandatory so you can't use "/@xxx as sysdba".

Regards
Michel
Re: system admin log in error [message #576602 is a reply to message #576600] Wed, 06 February 2013 08:58 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks


i think system administrator (or other OS user that is member of 'Administrator' group) is super user ,

it also need this ora_dba group?

sorry, i just want to confirm only.

thanks again.....
Re: system admin log in error [message #576606 is a reply to message #576602] Wed, 06 February 2013 09:05 Go to previous messageGo to next message
Michel Cadot
Messages: 58532
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read the post I wrote when you was writing yours.

Regards
Michel
Re: system admin log in error [message #576607 is a reply to message #576602] Wed, 06 February 2013 09:06 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
sorry sir i didn't get your message while replying ,

Quote:

This is not the problem: remote connection (when you use @xxx) do not use OS group but password file and password is mandatory so you can't use "/@xxx as sysdba".


then what should be do in this case if i have lost sys password,

but i can log in as system admin group user on server.


thanks.....
Re: system admin log in error [message #576608 is a reply to message #576607] Wed, 06 February 2013 09:12 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
i have also tried it:

C:\Windows\system32>set oracle_sid=myprodb

C:\Windows\system32>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 20:48:23 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name:



thanks...
Re: system admin log in error [message #576609 is a reply to message #576608] Wed, 06 February 2013 09:18 Go to previous messageGo to next message
BlackSwan
Messages: 22490
Registered: January 2009
Senior Member
OS user is not member of correct group
Re: system admin log in error [message #576610 is a reply to message #576609] Wed, 06 February 2013 09:20 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks for your response sir,

then which is that group ?

thanks.....
Re: system admin log in error [message #576611 is a reply to message #576610] Wed, 06 February 2013 09:27 Go to previous messageGo to next message
BlackSwan
Messages: 22490
Registered: January 2009
Senior Member
http://www.lmgtfy.com/?q=oracle+windows+sysdba+group
Re: system admin log in error [message #576656 is a reply to message #576611] Thu, 07 February 2013 00:35 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks sir,

is it compulsory that the OS user should be member of ORA_DBA group even it is already member or Administrator group on windows,

to perform System Admin operations in database?

i just want to confirm

thanks.......
Re: system admin log in error [message #576657 is a reply to message #576656] Thu, 07 February 2013 00:46 Go to previous messageGo to next message
Michel Cadot
Messages: 58532
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Yes, it is mandatory, Oracle is designed as it, it is more secure to have a database admin account than to be able to administer them only with Administrator group, don't you think?

2/ The standard administration of the database don't need to be connected as SYSDBA, only recovery (and some other rare things) needs it. Other operations only need a standard database account with DBA role (or even less).

Regards
Michel
Re: system admin log in error [message #576669 is a reply to message #576601] Thu, 07 February 2013 02:03 Go to previous messageGo to next message
Roachcoach
Messages: 1178
Registered: May 2010
Location: UK
Senior Member
Michel Cadot wrote on Wed, 06 February 2013 14:58
Roachcoach wrote on Wed, 06 February 2013 15:04
Your windows account is probably not in the correct dba group.


This is not the problem: remote connection (when you use @xxx) do not use OS group but password file and password is mandatory so you can't use "/@xxx as sysdba".

Regards
Michel



Thanks Smile

I missed the significance of the "@" part Embarassed
Re: system admin log in error [message #576736 is a reply to message #576595] Thu, 07 February 2013 10:42 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks sir,

one more thing

Quote:

This is not the problem: remote connection (when you use @xxx) do not use OS group but password file and password is mandatory so you can't use "/@xxx as sysdba".


but we also have to use @ when the host system has 2 or more database even we are

accessing one of the database from the host machine(or server).

if we login like C:\> sqlplus sys/password as sysdba

then it throws error .


thanks.......




[Updated on: Thu, 07 February 2013 10:43]

Report message to a moderator

Re: system admin log in error [message #576737 is a reply to message #576736] Thu, 07 February 2013 10:48 Go to previous messageGo to next message
BlackSwan
Messages: 22490
Registered: January 2009
Senior Member
>but we also have to use @ when the host system has 2 or more database even we are
WRONG!

>if we login like C:\> sqlplus sys/password as sysdba
>then it throws error .

ERROR?
What Error?
I don't see any error.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: system admin log in error [message #576738 is a reply to message #576736] Thu, 07 February 2013 11:02 Go to previous messageGo to next message
Michel Cadot
Messages: 58532
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But we also have to use @ when the host system has 2 or more database even we are
accessing one of the database from the host machine(or server).


Wrong, just set your ORACLE_SID (and possibly ORACLE_HOME) to the one for the database you have to connect.

Regards
Michel
Re: system admin log in error [message #576941 is a reply to message #576738] Mon, 11 February 2013 02:54 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks sir

you both are right (set oracle_sid on host machine).

we have set oracle_sid , is there any way to get current oracle_sid on windows7?


thanks again..........

Re: system admin log in error [message #576944 is a reply to message #576941] Mon, 11 February 2013 03:07 Go to previous messageGo to next message
Michel Cadot
Messages: 58532
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
we have set oracle_sid , is there any way to get current oracle_sid on windows7?


The question is meaningless, you do not get current ORACLE_SID on Windows7, you can get this value in a program that runs under Windows 7 then the answer depends on the tool.
In CMD, use SET.
The default value for Windows application is in the registry: HKLM\Software\Oracle\<your Oracle home name>.

Regards
Michel
Re: system admin log in error [message #576949 is a reply to message #576944] Mon, 11 February 2013 05:20 Go to previous message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks alot sir........

i have get it.



thanks again........
Previous Topic: OEL installation using VM Virtual BOX on Windows 8
Next Topic: select insttallation Method does not display
Goto Forum:
  


Current Time: Thu Jul 24 11:15:45 CDT 2014

Total time taken to generate the page: 0.09412 seconds