Home » RDBMS Server » Server Administration » Admin user/password (Oracle 8)
icon7.gif  Admin user/password [message #354881] Tue, 21 October 2008 15:37 Go to next message
erickcm
Messages: 2
Registered: October 2008
Location: CR
Junior Member
Hello,

The other person who installed Oracle isn't in the company and we need to access like administrator but we don't have the ID or password. Is there some option to reset or obtain them???

The idea isn't reinstall the software!!!

Thanks everybody
Erick C.
Re: Admin user/password [message #354884 is a reply to message #354881] Tue, 21 October 2008 16:20 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You can "connect / as sysdba" without a password, once you are logged in as the Oracle OS user on the server.

You can reset the OS user password with a OS Administrator/root.

If you have lost the OS Admin/Root password the procedure to recover that would be dependent on the OS, which you didn't post like it is asked in the guidelines of the forum, so please read them first and post the required information.

Re: Admin user/password [message #355541 is a reply to message #354881] Fri, 24 October 2008 19:33 Go to previous messageGo to next message
erickcm
Messages: 2
Registered: October 2008
Location: CR
Junior Member
Hello,

The problem is that I don{t have the admin id and password to access Oracle 8 Management

We are running Oracle under Windows Server 2000 SP3


Any idea how recovery Oracle Adminitsrator ID and passwor¨d?

Thanks
Re: Admin user/password [message #355542 is a reply to message #355541] Fri, 24 October 2008 20:22 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You still haven't clarified if you need the Oracle database user or the Oracle operating system user.
Re: Admin user/password [message #355546 is a reply to message #355541] Sat, 25 October 2008 00:33 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Connect on the server as a Windows administrator
Open Computer Management box
Search in local groups who is in ORA_DBA group
Connect on the server as this user
Then you can connect to the database with "/ as sysdba" and change the password.

Regards
Michel
Previous Topic: failover over WAN
Next Topic: Ora 1031 during an import
Goto Forum:
  


Current Time: Thu Dec 08 20:09:23 CST 2016

Total time taken to generate the page: 0.13670 seconds