[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1818
  • Last Modified:

ora-01031 insufficient privilges

I took a cold backup  of a 9.2 instance from one server and untarred it onto a second.  When I try to log into sqlplus as sysdba, i get ora-01031 insufficient privileges.  The directory stucture is identical on the two servers.  I've tried orapwd with the same results. How do i get to log in to sqlplus as sysdba?
0
xoxomos
Asked:
xoxomos
  • 9
  • 6
  • 2
  • +1
2 Solutions
 
Ivo StoykovCommented:
Hello xoxomos,

Did you restore password file as well?

HTH

I
0
 
xoxomosAuthor Commented:
Yes, it was in two .tar files.  One .tar contained software, the other data.
0
 
meluhkCommented:
What OS is this on?

Check the permissions on the files, check the owner is correct.  

here is a link to point you to some possible solutions:
http://home.clara.net/dwotton/dba/ora1031.htm

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
radja7Commented:
when untar, use parameter -p to extract all protection information on files.
0
 
xoxomosAuthor Commented:
It is on Solaris.  I just noticed, on the new server the owner and group for all the software is oracle/ oinstall.  On the old one it is oracle/dba.  Could that make a difference?
0
 
meluhkCommented:
Absolutely.  Either remove and untar again as radjaZ suggested with thie -p option, or you can the group for all files recursively.

 $ chgrp -fR dba .

The command above changed the group for all files '.' recursively, with the force option.

Also, make sure that dba is defined as a group at the OS level and that oracle is in the dba group by default (not oinstall).
0
 
xoxomosAuthor Commented:
Just tried to chgrp -fR to make  the software oracle/dba.  Oracle is in the dba group, but i'm still getting the same error.
0
 
meluhkCommented:
Did you do the command from above the ORACLE_HOME level?  And be sure to use the DOT '.' after the -fR.
0
 
xoxomosAuthor Commented:
I did it at the ORACLE_HOME level.
0
 
meluhkCommented:
What happens when you do the following:

$ sqlplus /nolog

Are you getting an error message then or do you get into sqlplus?
0
 
meluhkCommented:
To connect as sysdba, you have to be part of the dba group.  Are you getting the error message when you connect as sysdba in the oracle account?  If so, please have your system administrators change the default group of oracle to dba instead of oinstall (you need to do this anyway if you haven't already).  If you are getting the error as some other user, then they need to be added to the dba group.  

If these are not your issue, then it is probably to do with the tar process.  Did you shutdown the database, stop all processes including listener before getting the tar on the original system?  Make sure to extract the tar using the -p option.  Completely remove and re-extract using the -p option so that you get the files with the same permissions and group that they had when they were added to the tar.

Try these things and if none of them work.  I suggest that you actually install the Oracle binaries from installation CD.  Then clone the database itself (and move any apps as appropriate) from the source system.  

There are many options.  I tend to lean toward a clean installation of Oracle on new boxes.  You have more control on the whole environment and can be sure it is done properly.  It is up to you how much time you spend trying to get the tar move of Oracle binaries to work.  The suggestions above may be all you need.  But again, if not, then  I would recommend you do a clean install and then move the database and/or apps to the new server.
0
 
xoxomosAuthor Commented:
The command completed successfully
-bash-3.00$ $ORACLE_HOME/bin/sqlplus /NOLOG

SQL*Plus: Release 9.2.0.6.0 - Production on Tue Apr 18 09:59:14 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connect sys /as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges

0
 
xoxomosAuthor Commented:
I'm actually trying to upgrade from 9.2 to 10.2.  I did a clean install of the 10.2 server software only.  I'm trying to untar a backup of our 9.2 install in order to run the dbua  to upgrade that 9.2 to 10.2.
0
 
meluhkCommented:
I suggest that you install the 10.2 on the server that has the 9.2 and upgrade it.  Then you move the database/app to the new server.  If you are trying to do the upgrade on another server and leave your original alone until complete or tested.  Then install 9.2, move database/app to new server, and upgrade there.  Please note that the database upgrade assistant will only work if there is absolutely no issue with your database.  You can certainly try it, but Oracle told us after trying to use that this little tidbit of information....  In which case a more traditional upgrade will be required.
0
 
xoxomosAuthor Commented:
Yes, that is the smart way, but there is a space issue on the 9.2 server, about 80GB is just wasted space.  May have to resort to import.
0
 
xoxomosAuthor Commented:
Well this turned out to be the way /someotherdir and /u01 was set up.  Oversight essentially.
I did get around that problem by vi'ing a sqlnet.ora file and putting 'NONE' in some authentication parameter.  At least i get in and startup the database, but sysdba had to have the correct password.
0
 
xoxomosAuthor Commented:
Now dbua requires running netca first.
my netca -silent command line returns a command for me to set DISPLAY?????
0
 
radja7Commented:
Network configuration Assistant is a GUI tool, so you need enter *nix box with XServer
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 9
  • 6
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now