OraFAQ Forum: Windows » Instlling Oracle on top of itself

Home » Infrastructure » Windows » Instlling Oracle on top of itself (10g; Windows 2003)

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

Instlling Oracle on top of itself [message #611437]

Wed, 02 April 2014 09:46

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?

Report message to a moderator

Re: Instlling Oracle on top of itself [message #611438 is a reply to message #611437]

Wed, 02 April 2014 09:57

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

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

Report message to a moderator

Re: Instlling Oracle on top of itself [message #611439 is a reply to message #611437]

Wed, 02 April 2014 09:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

which OS user owns the Oracle software folder & files?

Report message to a moderator

Re: Instlling Oracle on top of itself [message #611440 is a reply to message #611438]

Wed, 02 April 2014 10:08

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.

Report message to a moderator

Re: Instlling Oracle on top of itself [message #611441 is a reply to message #611439]

Wed, 02 April 2014 10:09

papertiger
Messages: 22
Registered: March 2014
Location: MD

Junior Member

I'm assuming you are referring to the person that installed the software?

Report message to a moderator

Re: Instlling Oracle on top of itself [message #611444 is a reply to message #611441]

Wed, 02 April 2014 11:01

ThomasG
Messages: 3211
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

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.

Report message to a moderator

Re: Instlling Oracle on top of itself [message #611450 is a reply to message #611448]

Wed, 02 April 2014 12:23

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I'm a domain admin

Use a local account.

Report message to a moderator

Re: Instlling Oracle on top of itself [message #611456 is a reply to message #611450]

Wed, 02 April 2014 12:48

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.

Report message to a moderator

Re: Instlling Oracle on top of itself [message #611457 is a reply to message #611456]

Wed, 02 April 2014 12:54

Michel Cadot
Messages: 68417
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.

Report message to a moderator

Re: Instlling Oracle on top of itself [message #611462 is a reply to message #611457]

Wed, 02 April 2014 13:58

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.

Report message to a moderator

Re: Instlling Oracle on top of itself [message #611464 is a reply to message #611462]

Wed, 02 April 2014 14:07

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It works for me.

Report message to a moderator

Re: Instlling Oracle on top of itself [message #611467 is a reply to message #611464]

Wed, 02 April 2014 15:08

ThomasG
Messages: 3211
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?

Report message to a moderator

Re: Instlling Oracle on top of itself [message #611559 is a reply to message #611467]

Thu, 03 April 2014 10:36

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

Report message to a moderator

Re: Instlling Oracle on top of itself [message #611561 is a reply to message #611559]

Thu, 03 April 2014 10:55

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Great it worked in the end! Thanks for the feedback!

Report message to a moderator

Re: Instlling Oracle on top of itself [message #611572 is a reply to message #611437]

Thu, 03 April 2014 13:34

EdStevens
Messages: 1375
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/

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 22 16:36:49 CDT 2023