connect / as sysdba 2005-09-08 - By Sunil Bhola
Hi Deepak,
Here I am sending you some excercise, go thru from this.. hope that will solve
you issue :-
This error usually comes when you have different password for user
sys and password file.
eg:
orapwd file=pwdsunil.ora password=sunil entries=10
Say, but for sys user is having passowrd ORACLE.
when i will do:
connect sys/oracle
will connect successffuly
but if i will do :
connect sys/oracle as sysdba
than it will echo a message ORA-01031 (See ORA-01031.ora-code.com): insufficient privileges
but if i will do:
connect sys/sunil as sysdba
it will work
so after creating a password file always change the password for sys
with something new so that the new password will sync. with the
password file.
Hope this will clear your doubt :-)
QUERIES in Oracle, Feel free to Join:
http://groups.yahoo.com/group/oracle_expert/
Regards,
Sunil Bhola
Oracle_Expert, Moderator
Lou Fangxin <anysql@(protected)> wrote:
Are you connect to the domain? If so, you need to create the ORA_DBA in the
domain control. And after you add the group, please restart the oracle service.
Good luck.
On 9/8/05, DBA Deepak <oracle.tutorials@(protected)> wrote: Hi All,
I am trying to connect to my local DB (Windows XP Pro Box) using
connect / as sysdba
I am geting the error and unable to log in because of insufficient privilleges.
I have the following settings.
In initSID.ora
remote_login_passwordfile=EXCLUSIVE
In sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES = (NTS)
Under ORA_DBA os group I have added the currect os user.
What might be the problem? Please help.
--
Regards,
Deepak
Oracle DBA
--
Welcome, http://www.anysql.net/en/
-- ---- ---- ---- ---- ---- -----
Click here to donate to the Hurricane Katrina relief effort.
<DIV>Hi Deepak,</DIV>
<DIV> </DIV>
<DIV>Here I am sending you some excercise, go thru from this.. hope that
will solve you issue :-</DIV>
<DIV> </DIV>
<DIV><FONT face="Courier New" color=#202020>This error usually comes when you
have different password for user<BR>sys and password file.<BR><BR>eg:<BR>orapwd
file=pwdsunil.ora password=sunil entries=10<BR><BR>Say, but for sys user is
having passowrd ORACLE.<BR><BR>when i will do:<BR><BR>connect sys/oracle<BR
>will connect successffuly<BR>but if i will do :<BR>connect sys/oracle as sysdba
<BR>than it will echo a message ORA-01031 (See ORA-01031.ora-code.com): insufficient privileges<BR><BR>but if
i will do:<BR>connect sys/sunil as sysdba<BR>it will work<BR><BR>so after
creating a password file always change the password for sys<BR>with something
new so that the new password will sync. with the<BR>password file.<BR><BR>Hope
this will clear your doubt :-)</FONT></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><STRONG><B><FONT face=Verdana
color=#434343 size=3><SPAN style="FONT-SIZE: 12pt; COLOR: #434343; FONT-FAMILY:
Verdana">QUERIES in Oracle, Feel free to Join:</SPAN></FONT></B></STRONG><?xml
:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o
:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><STRONG><B><FONT face=Verdana
size=3><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Verdana"><A href="http:/
/groups.yahoo.com/group/oracle_expert/"><FONT color=#434343><SPAN style="COLOR:
#434343">http://groups.yahoo.com/group/oracle_expert/</SPAN></FONT></A><FONT
color=yellow><SPAN style="COLOR: yellow"> </SPAN></FONT></SPAN></FONT></B><
/STRONG><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><STRONG><B><FONT face=Verdana
size=3><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Verdana">Regards,</SPAN><
/FONT></B></STRONG><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><STRONG><B><FONT face=Verdana
color=red><SPAN style="FONT-SIZE: 12pt; COLOR: red; FONT-FAMILY: Verdana">S<
/SPAN></FONT></B></STRONG><STRONG><B><FONT face=Verdana size=3><SPAN style="FONT
-FAMILY: Verdana">unil <FONT color=red><SPAN style="COLOR: red">B</SPAN></FONT
>hola</SPAN></FONT></B></STRONG><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><STRONG><B><FONT face=Verdana>
<SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Verdana">Oracle_Expert, Moderator<
/SPAN></FONT></B></STRONG></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><STRONG><B><FONT face=Verdana>
<SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Verdana"></SPAN></FONT></B></STRONG>
<BR><B><I>Lou Fangxin <anysql@(protected)></I></B> wrote:</P>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER
-LEFT: #1010ff 2px solid">
<DIV>Are you connect to the domain? If so, you need to create the ORA_DBA in
the domain control. And after you add the group, please restart the oracle
service.</DIV>
<DIV> </DIV>
<DIV>Good luck.<BR><BR> </DIV>
<DIV><SPAN class=gmail_quote>On 9/8/05, <B class=gmail_sendername>DBA Deepak</B
> <<A href="mailto:oracle.tutorials@(protected)">oracle.tutorials@(protected)</A>
> wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV>Hi All,</DIV>
<DIV> </DIV>
<DIV>I am trying to connect to my local DB (Windows XP Pro Box) using</DIV>
<DIV> </DIV>
<DIV>connect / as sysdba</DIV>
<DIV> </DIV>
<DIV>I am geting the error and unable to log in because of insufficient
privilleges.</DIV>
<DIV> </DIV>
<DIV>I have the following settings.</DIV>
<DIV> </DIV>
<DIV>In initSID.ora</DIV>
<DIV>remote_login_passwordfile=EXCLUSIVE</DIV>
<DIV> </DIV>
<DIV>In sqlnet.ora</DIV>
<DIV>SQLNET.AUTHENTICATION_SERVICES = (NTS)</DIV>
<DIV> </DIV>
<DIV>Under ORA_DBA os group I have added the currect os user.</DIV>
<DIV> </DIV>
<DIV>What might be the problem? Please help.</DIV><SPAN class=sg>
<DIV> </DIV>
<DIV> </DIV>
<DIV><BR>-- <BR>Regards,<BR><BR>Deepak<BR>Oracle DBA </DIV></SPAN></BLOCKQUOTE>
</DIV><BR><BR clear=all><BR>-- <BR>Welcome, <A href="http://www.anysql.net/en/"
>http://www.anysql.net/en/</A> </BLOCKQUOTE><p>
<hr size=1> <a href="http://store.yahoo.com/redcross-donate3/">Click here to
donate to the Hurricane Katrina relief effort.</a>
|
|
