Sys user can login with as sysdba privilege? [message #295329] |
Tue, 22 January 2008 02:33 |
IBNHUSSAIN
Messages: 39 Registered: December 2007 Location: INDIA
|
Member |
|
|
Hello friends
I have a strange situation, at least to me that when I
try to login to my database using sys user.
The attempt fails when try like below.
SQL> CONN /AS SYSDBA
ERROR IS INSUFFICIENT PRIVILEGE
BUT WHEN I TRY ONLY LIKE BELOW
SQL> CONN SYS@MYDATA
ENTER PASSWORD:
CONNECTED.
But sys must be login as sysdba. It will not allow sys user
without sysdba, but how it is in my case?
HERE I HAVE MANUALLY GIVEN THE SCENARIO SINCE I DO NOT HAVE ACCESS TO THE DATABASE RIGHT NOW.
AND I AM SURE THAT I LOG IN TO THE MACHINE WITH ORACLE OWNER
AND SQLNET.AUTHENTICATION_SERVICES = (NTS) IS SET.
please clarify , why this strange behavior
|
|
|
|
|
|
|
|
Re: Sys user can login with as sysdba privilege? [message #295374 is a reply to message #295329] |
Tue, 22 January 2008 03:59 |
Arju
Messages: 1554 Registered: June 2007 Location: Dhaka,Bangladesh. Mobile:...
|
Senior Member |
|
|
I think O7_DICTIONARY_ACCESSIBILITY has no impact to connect to database.
SQL> show parameter O7_DICTIONARY_ACCESSIBILITY
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
O7_DICTIONARY_ACCESSIBILITY boolean TRUE
SQL> conn / as sysdba
Connected.
SQL> conn sys/arju
Connected.
[edit: I mean in case of true.]
[Updated on: Tue, 22 January 2008 04:21] Report message to a moderator
|
|
|
|
|
|
Re: Sys user can login with as sysdba privilege? [message #295387 is a reply to message #295384] |
Tue, 22 January 2008 04:21 |
IBNHUSSAIN
Messages: 39 Registered: December 2007 Location: INDIA
|
Member |
|
|
Thankyou Mr. Michel
I get your point.
But why it is not allowing as sysdba connection.
one more thing is that when i try to give this privilege(sysdba)
to system.
SQL> show user
USER is "SYS"
SQL> grant sysdba to system;
grant sysdba to system
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL>
Is this means SYS itself do not have sysdba privilege?
what shall i do? Please help me out.
Regards,
[Updated on: Tue, 22 January 2008 04:22] Report message to a moderator
|
|
|
|
Re: Sys user can login with as sysdba privilege? [message #295399 is a reply to message #295391] |
Tue, 22 January 2008 04:39 |
IBNHUSSAIN
Messages: 39 Registered: December 2007 Location: INDIA
|
Member |
|
|
Thankyou all friends.
Yes I have tried it.
SQL> conn sys/pwd@db as sysdba
ERROR:
ORA-01031: insufficient privileges
and this as well
SQL> conn sys@db as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges
As i asked before is it possible that sys can lost its sysdba privilege? If it is how can i grant it againt to sys?
Please help.
|
|
|
|
|
Re: Sys user can login with as sysdba privilege? [message #295419 is a reply to message #295410] |
Tue, 22 January 2008 05:20 |
IBNHUSSAIN
Messages: 39 Registered: December 2007 Location: INDIA
|
Member |
|
|
Thanks for your reply.
Dear Michel,
As I know when i grant sysdba privilege to any user and the password file is not present it gives the following error.
SQL> GRANT SYSDBA TO SYSTEM;
GRANT SYSDBA TO SYSTEM
*
ERROR at line 1:
ORA-01994: GRANT failed: cannot add users to public password file
And this error is different,
SQL> show user
USER is "SYS"
SQL> grant sysdba to system;
grant sysdba to system
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL>
Please clarify me if i am wrong.
[Updated on: Tue, 22 January 2008 05:21] Report message to a moderator
|
|
|
|
Re: Sys user can login with as sysdba privilege? [message #295432 is a reply to message #295415] |
Tue, 22 January 2008 05:42 |
IBNHUSSAIN
Messages: 39 Registered: December 2007 Location: INDIA
|
Member |
|
|
thanks for all that effort from you all.
yes I am sure that i am using correct password.
sqlnet.ora:
# SQLNET.ORA Network Configuration File: /u03/mydata/mydata/9.2.0/network/admin/
sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
$ exit
SQL> conn /as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
SQL> exit
$ sqlplus
SQL*Plus: Release 9.2.0.5.0 - Production on Tue Jan 22 14:30:00 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: /as sysdba
ERROR:
ORA-01031: insufficient privileges
AND NOW I HAVE USED DIFFERENT SETTINGS IN SQLNET.ORA
# SQLNET.ORA Network Configuration File: /u03/MYDATA/mydata/9.2.0/network/admin/
sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES)
~
~
SQL*Plus: Release 9.2.0.5.0 - Production on Tue Jan 22 14:35:20 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: /as sysdba
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
please clarify
|
|
|
|
Re: Sys user can login with as sysdba privilege? [message #295443 is a reply to message #295433] |
Tue, 22 January 2008 06:01 |
IBNHUSSAIN
Messages: 39 Registered: December 2007 Location: INDIA
|
Member |
|
|
Yes Michel you are correct in some or the other way.
Actually i have multiple oracle homes, i was not running correct environment file to set ORACLE HOME.
Now it is ok. My problem is solved after running correct environment file.
Thankyou all very much.
|
|
|
Re: ERROR while loggin as Sys [message #354623 is a reply to message #295443] |
Mon, 20 October 2008 10:38 |
kkraj
Messages: 2 Registered: October 2008
|
Junior Member |
|
|
Can any 1 say wat is the problem here...imnot able to login as SYS....
SQL> CONN /AS SYSDBA
Connected.
SQL> CONN SYS@MYDATA
Enter password:
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper
Warning: You are no longer connected to ORACLE.
Any help would be appriciated.
|
|
|
|
Re: ERROR while loggin as Sys [message #354634 is a reply to message #354632] |
Mon, 20 October 2008 10:59 |
kkraj
Messages: 2 Registered: October 2008
|
Junior Member |
|
|
Any thing i do in my database....im getting an error which says
"ORA-06553:PLS-232:package Standard not accessible"
I had my databse working fine...then i changed some privilages and roles of SYS user to execute an statement ..which changed the whole thing...
any command i give it says "package standard not accesible.."
I hav tried running standard.sql from
oracle-home/rdbms/admin...but unable to compile it...
I get an error "package standrad not accesible..."
Will i hav to reinstall oracle or can i login through an user id to run the standard package successfully..
please help me out.
|
|
|
|