OraFAQ Forum: Security » Unable to log on as sysdba

Home » RDBMS Server » Security » Unable to log on as sysdba

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

Unable to log on as sysdba [message #110059]

Thu, 03 March 2005 03:54

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.

Report message to a moderator

Re: Unable to log on as sysdba [message #110070 is a reply to message #110059]

Thu, 03 March 2005 04:51

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"

Report message to a moderator

Re: Unable to log on as sysdba [message #110071 is a reply to message #110070]

Thu, 03 March 2005 04:54

anmol1947
Messages: 34
Registered: February 2005
Location: Gurgaon

Member

not, but will it make some diff..

Report message to a moderator

Re: Unable to log on as sysdba [message #110079 is a reply to message #110071]

Thu, 03 March 2005 07:23

_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

Cool

Report message to a moderator

Re: Unable to log on as sysdba [message #110081 is a reply to message #110079]

Thu, 03 March 2005 07:27

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

Report message to a moderator

Re: Unable to log on as sysdba [message #110083 is a reply to message #110081]

Thu, 03 March 2005 07:34

_simma_dba
Messages: 34
Registered: November 2003

Member

What error do you get when you try conn / as sysdba?

Report message to a moderator

Re: Unable to log on as sysdba [message #110084 is a reply to message #110083]

Thu, 03 March 2005 07:36

anmol1947
Messages: 34
Registered: February 2005
Location: Gurgaon

Member

insufficient privileges

Report message to a moderator

Re: Unable to log on as sysdba [message #110085 is a reply to message #110084]

Thu, 03 March 2005 07:38

_simma_dba
Messages: 34
Registered: November 2003

Member

R u member of ORA_DBA group?

Report message to a moderator

Re: Unable to log on as sysdba [message #110086 is a reply to message #110085]

Thu, 03 March 2005 07:40

anmol1947
Messages: 34
Registered: February 2005
Location: Gurgaon

Member

No,but i want to be ..

Report message to a moderator

Re: Unable to log on as sysdba [message #110087 is a reply to message #110086]

Thu, 03 March 2005 07:44

_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

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

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

Report message to a moderator

Re: Unable to log on as sysdba [message #110090 is a reply to message #110088]

Thu, 03 March 2005 07:55

_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

Cool

Report message to a moderator

Re: Unable to log on as sysdba [message #110188 is a reply to message #110090]

Thu, 03 March 2005 23:04

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.

Report message to a moderator

Re: Unable to log on as sysdba [message #110241 is a reply to message #110188]

Fri, 04 March 2005 09:47

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

Report message to a moderator

Re: Unable to log on as sysdba [message #110293 is a reply to message #110241]

Fri, 04 March 2005 23:48

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

Report message to a moderator

Re: Unable to log on as sysdba [message #110329 is a reply to message #110293]

Sat, 05 March 2005 23:13

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;

Report message to a moderator

Re: Unable to log on as sysdba [message #110469 is a reply to message #110059]

Mon, 07 March 2005 16:35

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

Report message to a moderator

Re: Unable to log on as sysdba [message #110891 is a reply to message #110059]

Thu, 10 March 2005 17:47

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)

Report message to a moderator

Re: Unable to log on as sysdba [message #112416 is a reply to message #110891]

Fri, 25 March 2005 01:41

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

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

Report message to a moderator

Re: Unable to log on as sysdba [message #220132 is a reply to message #110059]

Mon, 19 February 2007 01:10

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

Report message to a moderator

Re: Unable to log on as sysdba [message #516400 is a reply to message #110059]

Sun, 17 July 2011 14:07

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.

Report message to a moderator

Re: Unable to log on as sysdba [message #516401 is a reply to message #516400]

Sun, 17 July 2011 14:15

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

Report message to a moderator

Previous Topic:	ORA-20007
Next Topic:	active directory authentication for oracle 10g database running on solaris

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 21:10:19 CST 2024