Home » Infrastructure » Windows » Instlling Oracle on top of itself (10g; Windows 2003)
Instlling Oracle on top of itself [message #611437] Wed, 02 April 2014 09:46 Go to next message
papertiger
Messages: 22
Registered: March 2014
Location: MD
Junior Member
Situation:
We have lost all the passwords to all of our Oracle accounts (including sys and system). Can we install the same version of Oracle on top of the existing installation to reset the ID's and passwords of the accounts without destroying the data that's currently there? I've already created a thread about trying to reset the passwords of the sys or system account as well as looking for some kind of back door to gain access. I've had no success with the suggestions posted by forum members (I do appreciate the effort/suggestions). I do have an RMAN backup, but that won't help me without the password for the sys and system accounts. I don't have a tape backup. Will installing Oracle on top of itself delete all of the instance information? Is there a recovery option within the installation to reset the passwords? What options do I have?

I was also thinking about installing another instance along side the existing instance and transferring the data. Is this possible? I know in SQL you can export the db and basically take it to another server with the same version on it and import the db. Would this be my final solution or is there a way of getting around the sys and system accounts?
Re: Instlling Oracle on top of itself [message #611438 is a reply to message #611437] Wed, 02 April 2014 09:57 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just connect "/ as sysdba" and change SYS and SYSTEM passwords.

Re: Instlling Oracle on top of itself [message #611439 is a reply to message #611437] Wed, 02 April 2014 09:57 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
which OS user owns the Oracle software folder & files?
Re: Instlling Oracle on top of itself [message #611440 is a reply to message #611438] Wed, 02 April 2014 10:08 Go to previous messageGo to next message
papertiger
Messages: 22
Registered: March 2014
Location: MD
Junior Member
I've already tried this with my OS account as well as a sys and system local OS account. On all three accounts I get "Insufficient Privileges" error.

Just to verify:

C:documents and settings\<userid>\> sqlplus / as sysdba

All id's are in the ora_db group and all are local admins.

Re: Instlling Oracle on top of itself [message #611441 is a reply to message #611439] Wed, 02 April 2014 10:09 Go to previous messageGo to next message
papertiger
Messages: 22
Registered: March 2014
Location: MD
Junior Member
I'm assuming you are referring to the person that installed the software?
Re: Instlling Oracle on top of itself [message #611444 is a reply to message #611441] Wed, 02 April 2014 11:01 Go to previous messageGo to next message
ThomasG
Messages: 3101
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
There is a huge difference between
sqlplus / as sysdba

and
sqlplus "/ as sysdba"

of course.

Copy and paste the exact result of the following:
set ORACLE_SID=[Your SID]
sqlplus "/ as sysdba"

[Updated on: Wed, 02 April 2014 11:01]

Report message to a moderator

Re: Instlling Oracle on top of itself [message #611448 is a reply to message #611444] Wed, 02 April 2014 12:21 Go to previous messageGo to next message
papertiger
Messages: 22
Registered: March 2014
Location: MD
Junior Member
I'm unable to copy and paste due to security reasons, but here's what I get:

C:\documents and settings\<mydomainid>\ splplus "/as sysdba"
enter password: <I enter my domain password>

ORA-01031: insufficient privileges

FYI -- I'm a domain admin as well as a member of the ora_db group.
Re: Instlling Oracle on top of itself [message #611450 is a reply to message #611448] Wed, 02 April 2014 12:23 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I'm a domain admin


Use a local account.

Re: Instlling Oracle on top of itself [message #611456 is a reply to message #611450] Wed, 02 April 2014 12:48 Go to previous messageGo to next message
papertiger
Messages: 22
Registered: March 2014
Location: MD
Junior Member
I tried that as well -- same ORA-01031 error.

This is a local account by the name of sys and the account is a local admin and part of the ora_db group.
Re: Instlling Oracle on top of itself [message #611457 is a reply to message #611456] Wed, 02 April 2014 12:54 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I'm a domain admin

Quote:
This is a local account


What is true? Both can't.
No one can help you with false information.
I give up.
Good luck.

Re: Instlling Oracle on top of itself [message #611462 is a reply to message #611457] Wed, 02 April 2014 13:58 Go to previous messageGo to next message
papertiger
Messages: 22
Registered: March 2014
Location: MD
Junior Member
Please re-read the post -- one is a domain id and the other is a local account. I've tried both.
Re: Instlling Oracle on top of itself [message #611464 is a reply to message #611462] Wed, 02 April 2014 14:07 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It works for me.

Re: Instlling Oracle on top of itself [message #611467 is a reply to message #611464] Wed, 02 April 2014 15:08 Go to previous messageGo to next message
ThomasG
Messages: 3101
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
For me, too.

IF you are doing it with the User that has installed Oracle, and who is in the local ORA_DBA group that was created when Oracle was installed, then it will work.

Is there a local ORA_DBA group on the machine?
Do the Oracle files belong to a member of that group?
Have you tried all that with that member of that group?



Re: Instlling Oracle on top of itself [message #611559 is a reply to message #611467] Thu, 03 April 2014 10:36 Go to previous messageGo to next message
papertiger
Messages: 22
Registered: March 2014
Location: MD
Junior Member
Resolution: switched the sql_authentication_services= backt to (NTS) from (NONE) in sqlnet.ora
added multiple admin groups to the Oracle Administrators Assistant for Windows snap-in
restarted listener and db service and we were able to login "/as sysdab"

thanks for the help
Re: Instlling Oracle on top of itself [message #611561 is a reply to message #611559] Thu, 03 April 2014 10:55 Go to previous messageGo to next message
ThomasG
Messages: 3101
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Great it worked in the end! Thanks for the feedback!
Re: Instlling Oracle on top of itself [message #611572 is a reply to message #611437] Thu, 03 April 2014 13:34 Go to previous message
EdStevens
Messages: 304
Registered: September 2013
Senior Member
I thought I was seeng double.

Why were you running people ragged by double posting?


http://www.orafaq.com/forum/t/192247/

http://www.orafaq.com/forum/t/192229/
Previous Topic: how to put current date and time in dump file using expdp utility in windows
Next Topic: Installing 11gR2 on Windows 7 Pro 64-bit dies...
Goto Forum:
  


Current Time: Tue Oct 21 17:19:05 CDT 2014

Total time taken to generate the page: 0.12690 seconds