Home » RDBMS Server » Security » Cannot login as sysdba (Oracle 9i , windows XP)
Cannot login as sysdba [message #314874] Fri, 18 April 2008 01:45 Go to next message
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 Sad
Re: Cannot login as sysdba [message #314875 is a reply to message #314874] Fri, 18 April 2008 01:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
gopu_g
Messages: 54
Registered: March 2008
Location: mumbai
Member

Good question Smile
the password and the username is correct or not Sad
Re: Cannot login as sysdba [message #314878 is a reply to message #314876] Fri, 18 April 2008 02:12 Go to previous messageGo to next message
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
Re: Cannot login as sysdba [message #314882 is a reply to message #314878] Fri, 18 April 2008 02:35 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: scott /tiger cant see system tables/cant create another user
Next Topic: privileage issue in V$session?
Goto Forum:
  


Current Time: Fri Mar 29 09:51:55 CDT 2024