Home » RDBMS Server » Security » Unable to log on as sysdba
Unable to log on as sysdba [message #110059] Thu, 03 March 2005 03:54 Go to next message
anmol1947
Messages: 34
Registered: February 2005
Location: Gurgaon
Member
I am working on oracle 9.0.1 version on XP
Here I am unable to log as sysdba
I am doing like this

d:\sqlplus /nolog
sql>conn /as sysdba

not working,giving an error
then i tried

sql>conn sys as sysdba
again same error :_ insufficent Priv..

where as
sql> conn system/manager
working

please help

Thanx In Adv.




Re: Unable to log on as sysdba [message #110070 is a reply to message #110059] Thu, 03 March 2005 04:51 Go to previous messageGo to next message
delarosa_ng
Messages: 3
Registered: March 2005
Location: Philippines
Junior Member
hi,

have you tried using double quotation mark ""
ex.
sqlplus "sys@TestServer as sysdba"


Re: Unable to log on as sysdba [message #110071 is a reply to message #110070] Thu, 03 March 2005 04:54 Go to previous messageGo to next message
anmol1947
Messages: 34
Registered: February 2005
Location: Gurgaon
Member
not, but will it make some diff..
Re: Unable to log on as sysdba [message #110079 is a reply to message #110071] Thu, 03 March 2005 07:23 Go to previous messageGo to next message
_simma_dba
Messages: 34
Registered: November 2003
Member
If you are using Windows XP then you have to be part of the ORA_DBA group to be able to use connection string like that. If you are not then you have to use:
conn sys/sys_password@db_service_name as sysdba

sys_password - one that you defined when you create the database

Cool
Re: Unable to log on as sysdba [message #110081 is a reply to message #110079] Thu, 03 March 2005 07:27 Go to previous messageGo to next message
anmol1947
Messages: 34
Registered: February 2005
Location: Gurgaon
Member
I already tried this ,but it is not workiong
Yesterday i spent whole night and hope 2night also....
Re: Unable to log on as sysdba [message #110083 is a reply to message #110081] Thu, 03 March 2005 07:34 Go to previous messageGo to next message
_simma_dba
Messages: 34
Registered: November 2003
Member
What error do you get when you try conn / as sysdba?
Re: Unable to log on as sysdba [message #110084 is a reply to message #110083] Thu, 03 March 2005 07:36 Go to previous messageGo to next message
anmol1947
Messages: 34
Registered: February 2005
Location: Gurgaon
Member
insufficient privileges
Re: Unable to log on as sysdba [message #110085 is a reply to message #110084] Thu, 03 March 2005 07:38 Go to previous messageGo to next message
_simma_dba
Messages: 34
Registered: November 2003
Member
R u member of ORA_DBA group?
Re: Unable to log on as sysdba [message #110086 is a reply to message #110085] Thu, 03 March 2005 07:40 Go to previous messageGo to next message
anmol1947
Messages: 34
Registered: February 2005
Location: Gurgaon
Member
No,but i want to be ..
Re: Unable to log on as sysdba [message #110087 is a reply to message #110086] Thu, 03 March 2005 07:44 Go to previous messageGo to next message
_simma_dba
Messages: 34
Registered: November 2003
Member
Then when time comes and you are part of ORA_DBA group then you will be able to use that connection string Cool i mean call your System administrator and ask him to add you in that group

[Updated on: Thu, 03 March 2005 07:45]

Report message to a moderator

Re: Unable to log on as sysdba [message #110088 is a reply to message #110087] Thu, 03 March 2005 07:50 Go to previous messageGo to next message
anmol1947
Messages: 34
Registered: February 2005
Location: Gurgaon
Member
sorry misunderstanding here .

i am member of ora_dba ,that is prerequisite to connect as sysdba

but although with that i am unable to log in

icon9.gif  Re: Unable to log on as sysdba [message #110090 is a reply to message #110088] Thu, 03 March 2005 07:55 Go to previous messageGo to next message
_simma_dba
Messages: 34
Registered: November 2003
Member
i dont know then? Try use c:\>set oracle_sid=db_name before you start sqlplus. Maybe you have multiple instances on that server Cool
Re: Unable to log on as sysdba [message #110188 is a reply to message #110090] Thu, 03 March 2005 23:04 Go to previous messageGo to next message
anmol1947
Messages: 34
Registered: February 2005
Location: Gurgaon
Member
i already made appropriate entry in the registry,that is fine i am sure.

but when i am tried to log as sysdba it is again splaishing an error insufficent privallege..
i think may be it is relsted with OS level
but exactly i dot know..
so please help

Thnax n Adv.
Re: Unable to log on as sysdba [message #110241 is a reply to message #110188] Fri, 04 March 2005 09:47 Go to previous messageGo to next message
kapil2005
Messages: 44
Registered: March 2005
Member
Copy and paste your SQLNET.ORA FILE and also tnsnames.ora file and also listener.ora file, i will see if i can help you
Re: Unable to log on as sysdba [message #110293 is a reply to message #110241] Fri, 04 March 2005 23:48 Go to previous messageGo to next message
anmol1947
Messages: 34
Registered: February 2005
Location: Gurgaon
Member
Hi ,

I have installed oracle at my home PC ,means these file dint mean lot ,what i think.

I think may it problem is because of XP authentication.

confused..
Re: Unable to log on as sysdba [message #110329 is a reply to message #110293] Sat, 05 March 2005 23:13 Go to previous messageGo to next message
oldboy
Messages: 9
Registered: March 2005
Location: Chongqing CHINA
Junior Member

follow me:
orapwd file=%ORACLE_HOME%\DATABASE\pwd%oracle-sid%.ora password=%sys-password%

connect sys/sys-password as sysdba;
icon14.gif  Re: Unable to log on as sysdba [message #110469 is a reply to message #110059] Mon, 07 March 2005 16:35 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

Try creating a password file ...

orapwd file=<> password=<>
and see if you can connect to db as sysdba using that password ..

-V
Re: Unable to log on as sysdba [message #110891 is a reply to message #110059] Thu, 10 March 2005 17:47 Go to previous messageGo to next message
jbatista
Messages: 8
Registered: March 2005
Location: Horsham, PA
Junior Member
Make sure that the following line is in your SQLNET.ORA file
SQLNET.AUTHENTICATION_SERVICES= (NTS)
Re: Unable to log on as sysdba [message #112416 is a reply to message #110891] Fri, 25 March 2005 01:41 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi

Actually you have to change parameter in parameter file .. i hope u know what is parameter file it is initsid.ora
sid stand for system identifier
so if u have database name called star then your file name must be

initstar.ora

now in this file there is one parameter change its value to none for

REMOTE_LOGIN_PASSWORDFILE=NONE

below you can know how os authentication is doen

------------------
OS AUTHENTICATION
------------------
When we load oracle, it creates a group at os level. Name of this group is ORA_DBA in 2k servers
The member (has to be authenticated user of OS) of this group can connect to DB as DBA without password

However, for that, set parameter in init.ora
REMOTE_LOGIN_PASSWORDFILE=NONE

Now to connect to DB
SQL > CONNECT / AS SYSDBA;

SQL> ALTER USER sap IDENTIFIED EXTERNALLY;
I.E. Authentication is done by OS

note:- sap is user of Operating system who is not user of Database remember sap is member of group ora_DBA...
if you dont have sap as user of operatiing system then create user sap on your os and make him member of ora_DBA..
-----------------------------------------------------------------
still u r not able to do then try things written below
-----------------------------------------------------------------

In 9i if u are able to connect as scott/tiger

then you first connect to scott tiger
you will get

SQL>

now here on SQL prompt
SQL> connect sys as sysdba
password: change_on_install

---------------------------------------------------------------

i hope things should work now ..

regards
sunil

---------------------------
Re: Unable to log on as sysdba [message #220132 is a reply to message #110059] Mon, 19 February 2007 01:10 Go to previous messageGo to next message
raghu_22295
Messages: 1
Registered: February 2007
Junior Member
remote_login_passwordfile parameter might have been set to none
so change it to exclusive it works
Re: Unable to log on as sysdba [message #516400 is a reply to message #110059] Sun, 17 July 2011 14:07 Go to previous messageGo to next message
sasankaghosh
Messages: 1
Registered: July 2011
Junior Member
I faced the problem .. i was able to logib as scott/tiger@orcl1 .. , remember " ORCL1" is the name that i and anyone could mistakenly give in net configuratuin assistant . my actual SID name is "ORCL" .

but i could not login as sys or system.

it coccured to me that it is sytem authentication problem though i am logged in as "Administrator' in my laptop.
i checked user accounts .. i m being notified as "administrator' .
then i rember that when installing oracle .. one option came to me " changing password" for accounts of diff users ..
i remember doing some changes in that but it was all uniform i.e. the password i m using to logon as "scott".
it baffelled me why i am able to login as "scott/password@orcl1' but not as "sys"/'system'.

then i tried the following ..
create a new admin account in windows as "sas" for the computer.
switich user ..login as "sas' with admin privilrge .
start oracle services .. i.e . "listener" and "ORCL" SID. go to admin services in windows . strt both these services .
login as system/"(password which u gave during installation")@connect string ( in my case it is ORCL1.
logged in successfully.
try to connect as sys as sysdba with the same "Password" and "connect string ' . it will give error .
again reconnect as system user.
alter user SYS modify password *****
try to connect as sys with the new password .. and connect string.
get connected ...
quit SQL .
quit windows as the new user .
login as old user i.e. "ADMIn " or what ever user u were during installation .
start the oracle services i.e. listener and SID .
login as scott/password@Orcl1
then login as sys/password@orcl1 ..
success.

Moral of the story .. " It is accidental or some discrepancy " between authentication synchronization between "Windows OS" and Oracle 'Software' .. accidentally some parametrs or orcle files/windows files get changed .
still if u have the windows admin facility without going through hell i.e. " changing password files , reading thousands of responses and trying them " , de installing and re installing oracle .. try this .. it should work most of the times .. if u have valid windows admin "privilege" when installing Oracle.
Re: Unable to log on as sysdba [message #516401 is a reply to message #516400] Sun, 17 July 2011 14:15 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
no problem exists when you log onto DB server as OS user "oracle" then utilize OS Authentication
sqlplus
/ as sysdba


Neither password nor SQL*Net is required to access the DB
Previous Topic: ORA-20007
Next Topic: active directory authentication for oracle 10g database running on solaris
Goto Forum:
  


Current Time: Fri Mar 29 01:30:33 CDT 2024