OraFAQ Forum: Windows » system admin log in error

Home » Infrastructure » Windows » system admin log in error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

system admin log in error [message #576595]

Wed, 06 February 2013 07:43

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.......

Report message to a moderator

Re: system admin log in error [message #576596 is a reply to message #576595]

Wed, 06 February 2013 08:04

Roachcoach
Messages: 1576
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

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....

Report message to a moderator

Re: system admin log in error [message #576600 is a reply to message #576597]

Wed, 06 February 2013 08:52

Roachcoach
Messages: 1576
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.

Report message to a moderator

Re: system admin log in error [message #576601 is a reply to message #576596]

Wed, 06 February 2013 08:58

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: system admin log in error [message #576602 is a reply to message #576600]

Wed, 06 February 2013 08:58

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.....

Report message to a moderator

Re: system admin log in error [message #576606 is a reply to message #576602]

Wed, 06 February 2013 09:05

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Read the post I wrote when you was writing yours.

Regards
Michel

Report message to a moderator

Re: system admin log in error [message #576607 is a reply to message #576602]

Wed, 06 February 2013 09:06

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.....

Report message to a moderator

Re: system admin log in error [message #576608 is a reply to message #576607]

Wed, 06 February 2013 09:12

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...

Report message to a moderator

Re: system admin log in error [message #576609 is a reply to message #576608]

Wed, 06 February 2013 09:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

OS user is not member of correct group

Report message to a moderator

Re: system admin log in error [message #576610 is a reply to message #576609]

Wed, 06 February 2013 09:20

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

thanks for your response sir,

then which is that group ?

thanks.....

Report message to a moderator

Re: system admin log in error [message #576611 is a reply to message #576610]

Wed, 06 February 2013 09:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.lmgtfy.com/?q=oracle+windows+sysdba+group

Report message to a moderator

Re: system admin log in error [message #576656 is a reply to message #576611]

Thu, 07 February 2013 00:35

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.......

Report message to a moderator

Re: system admin log in error [message #576657 is a reply to message #576656]

Thu, 07 February 2013 00:46

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: system admin log in error [message #576669 is a reply to message #576601]

Thu, 07 February 2013 02:03

Roachcoach
Messages: 1576
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

I missed the significance of the "@" part Embarassed

Report message to a moderator

Re: system admin log in error [message #576736 is a reply to message #576595]

Thu, 07 February 2013 10:42

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

Re: system admin log in error [message #576738 is a reply to message #576736]

Thu, 07 February 2013 11:02

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: system admin log in error [message #576941 is a reply to message #576738]

Mon, 11 February 2013 02:54

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..........

Report message to a moderator

Re: system admin log in error [message #576944 is a reply to message #576941]

Mon, 11 February 2013 03:07

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: system admin log in error [message #576949 is a reply to message #576944]

Mon, 11 February 2013 05:20

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

thanks alot sir........

i have get it.

thanks again........

Report message to a moderator

Previous Topic:	OEL installation using VM Virtual BOX on Windows 8
Next Topic:	select insttallation Method does not display

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 16:45:48 CST 2025