OraFAQ Forum: Security » Cannot login as sysdba

Home » RDBMS Server » Security » Cannot login as sysdba (Oracle 9i , windows XP)

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

Cannot login as sysdba [message #314874]

Fri, 18 April 2008 01:45

oracle_me
Messages: 59
Registered: March 2008

Member

Hi,
I am not able to logon to as sysdba.
It always gives ORA:01031 Insufficient Priveleges or
invalid username/password

However I am able to connect to scott/tiger.
I badly need to connect as sysdba.
Can you please help me fix this.

I user the login as sys/sys
and system/system
Neither worked.
Are there any problems because installation was not proper?
Please help Sad

Report message to a moderator

Re: Cannot login as sysdba [message #314875 is a reply to message #314874]

Fri, 18 April 2008 01:52

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

Senior Member
Account Moderator

Answers to your previous topic :

Michel Cadot wrote on Fri, 18 April 2008 08:32

How is this a SQL expert question?

It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Read them, follow them.

As you are an expert, I don't answer the question because you obviously already knows it.

Littlefoot wrote on Fri, 18 April 2008 08:33

Check the OraFAQ Forum Guide; in there you'll find links to useful sites. One of them is Oracle documentation - visit the site and search for CREATE USER SQL statement. It will show you which privileges are necessary for a user to be able to create another user.
...
Finally, "creating users", "privileges", "grants" and "roles" do not belong to SQL Experts forum as they don't require advanced SQL knowledge; these are "security" terms.

Why don't you want to follow the guide lines?

Moderators, isn't it time to burn the rules and just make one big forum?

[Updated on: Fri, 18 April 2008 02:33]

Report message to a moderator

Re: Cannot login as sysdba [message #314876 is a reply to message #314874]

Fri, 18 April 2008 01:52

gopu_g
Messages: 54
Registered: March 2008
Location: mumbai

Member

Good question Smile

the password and the username is correct or not Sad

Report message to a moderator

Re: Cannot login as sysdba [message #314878 is a reply to message #314876]

Fri, 18 April 2008 02:12

oracle_me
Messages: 59
Registered: March 2008

Member

Hi,
First of all I am sorry that I logged this doubt in experts forum.
However I do not know how to move it to sql newbees forum,Perhaps a moderator can ..
Also I would like to say that I fixed it..
Now it works.
Thanks

Report message to a moderator

Re: Cannot login as sysdba [message #314882 is a reply to message #314878]

Fri, 18 April 2008 02:35

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

Senior Member
Account Moderator

Quote:

First of all I am sorry that I logged this doubt in experts forum.

If you have doubt, post in NEWBIE, you are a NEWBIE, post in NEWBIE.
In addition, as LittleFoot said "privilege" is a keywork for "Security" isn't it?

Regards
Michel

Report message to a moderator

Previous Topic:	scott /tiger cant see system tables/cant create another user
Next Topic:	privileage issue in V$session?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 07:55:50 CST 2025