Home » RDBMS Server » Server Administration » insufficient privileges error ORA-01031 when trying to connect as sysdba (oracle,8.7.0.1(upgrading to 9.2.0.1),Windows 2000)
insufficient privileges error ORA-01031 when trying to connect as sysdba [message #393215] Fri, 20 March 2009 14:50 Go to next message
aviana
Messages: 101
Registered: July 2007
Senior Member
hi i am trying to upgrade the oracle database on one of our user's laptop from oracle 8i to oracle 9i
i installed oracle 9i in a different oracle home (selected the option, "just the software" as I wanted to upgrade the existing db to 9i)
The installation was successful and I started to run the DBUA(database upgrade assistant) and selected the old DB name for upgrade.In the bottom of the form where i want to give a username and p.w for authentication, it says,
"You do not have operating system privileges so need to provide a username and password having the sysdba privileges"
Also Nobody has the correct password for SYS user/or not available.
The username I logged in is in the ORA_DBA and also administrators group
I have 2 questions here:
1)what should i do to get the operating system privileges?
2)How do i reset the sys password?
I tried the foll: in an attempt to alter SYS password but no use!
sqlplus /nolog
connect / as sysdba
It says:
ORA-01031:insufficient privileges

pls try to resolve.What else should i check?

[Updated on: Fri, 20 March 2009 14:56]

Report message to a moderator

Re: insufficient privileges error ORA-01031 when trying to connect as sysdba [message #393217 is a reply to message #393215] Fri, 20 March 2009 14:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just search this forum.
This is a frequently asked question.
If the database is in a 'laptop', I assume it is not much complex.
Why not just export and import into a new 9i database and save yourself from DBUA?
And you really wanted to go for 9i?
Re: insufficient privileges error ORA-01031 when trying to connect as sysdba [message #393218 is a reply to message #393215] Fri, 20 March 2009 14:58 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
sqlplus /nolog
connect / as sysdba
It says:
ORA-01031:insufficient privileges

pls try to resolve.What else should i check?

There is a whole long NOTE on Metalink that provides a checklist.
It contains your answer(s).
Re: insufficient privileges error ORA-01031 when trying to connect as sysdba [message #393219 is a reply to message #393217] Fri, 20 March 2009 15:01 Go to previous messageGo to next message
aviana
Messages: 101
Registered: July 2007
Senior Member
Thanks Mahesh for a very quick reply!
yes it was a management decision basically to go to 9i enterprise edition, as the company has license only for it and 8i is desupported
yes i searched a lot for it but cant try to solve this.

OK, if doing export/import option, do i need to reinstall the oracle 9i as i only installed the software..but no database
also, i was afraid i might need to do manual steps when doing exp/imp, and it was very urgent and i thought dbua will be easier
Re: insufficient privileges error ORA-01031 when trying to connect as sysdba [message #393222 is a reply to message #393219] Fri, 20 March 2009 15:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>i thought dbua will be easier
It is easier if everything works good (before and after).

Did you take atleast a backup before starting with DBUA?
WHat if you run into trouble half way through?
>>ORA-01031:insufficient privileges
Is a very common error and just search.

YOu can create an empty database within minutes and just do exp/imp.

Re: insufficient privileges error ORA-01031 when trying to connect as sysdba [message #393223 is a reply to message #393219] Fri, 20 March 2009 15:10 Go to previous messageGo to next message
aviana
Messages: 101
Registered: July 2007
Senior Member
hi blackswan thanks for the reply..i searched metalink and there is a whole lot of documentation..so please give me the docid which contains the checklist for windows platform?thanks in advance
Re: insufficient privileges error ORA-01031 when trying to connect as sysdba [message #393224 is a reply to message #393222] Fri, 20 March 2009 15:15 Go to previous messageGo to next message
aviana
Messages: 101
Registered: July 2007
Senior Member
i didnt take any backup but all data files is still there in the old oracle home, config files in new oracle home...(this is what the installer reported after installation.)
but even for doing exp/imp i need the sys password right?Please tell me how to recreate it, and this issue still need to be resolved

also pls tell me how to create empty database quickly?Using DBCA?when doing exp/imp will there be any noncompatible issues?

[Updated on: Fri, 20 March 2009 15:18]

Report message to a moderator

Re: insufficient privileges error ORA-01031 when trying to connect as sysdba [message #393225 is a reply to message #393223] Fri, 20 March 2009 15:19 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
aviana wrote on Fri, 20 March 2009 13:10
hi blackswan thanks for the reply..i searched metalink and there is a whole lot of documentation..so please give me the docid which contains the checklist for windows platform?thanks in advance

Sorry, I am not being paid to do your job.
search on error code & "AS SYSDBA"
Re: insufficient privileges error ORA-01031 when trying to connect as sysdba [message #393228 is a reply to message #393225] Fri, 20 March 2009 15:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
... you can also search here and you will get the docid that was posted several times.

Regards
Michel
Re: insufficient privileges error ORA-01031 when trying to connect as sysdba [message #393232 is a reply to message #393224] Fri, 20 March 2009 15:30 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>i didnt take any backup but all data files is still there in the old oracle home
Good luck with that. Do you know what DBUA does do your database?
>>but even for doing exp/imp i need the sys password right?
Not essential. All you need is a dba account or atleast the user password (for the schema you want to export).
>>also pls tell me how to create empty database quickly?Using DBCA
May be.
Some find DBCA easy. I find command line createdb easy.
It is upto your comfort level.
DBCA is usually preferred for less experienced users.
>>when doing exp/imp will there be any noncompatible issues?
How can I say that?
It is your database. You should know about it.

search for ORA-01031: insufficient privileges
It is all over the web.
http://forums.oracle.com/forums/thread.jspa?messageID=1754959
Previous Topic: after shutdown ORA-12514
Next Topic: Analyze schema
Goto Forum:
  


Current Time: Fri Dec 02 14:21:30 CST 2016

Total time taken to generate the page: 0.11735 seconds