| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: REPOST: URGENT!!! Oracle 8.0.6 password recovery
Hello Chris,
Since you have admin access to the box, put your NT account in a local group named ORA_DBA. Then locate a file named sqlnet.ora on the server (it should be inside a folder with a name like \ORA80\NETWORK\ADMIN). Make sure the following line appears inside this sqlnet.ora file:
SQLNET.AUTHENTICATION_SERVICES= (NTS) I can't remember if the preceding step is required; it can't hurt. I don't have an 8.0 server around to check on (I am writing from what seems like a distant 8.0.x memory...).
Then, assuming this is the only Oracle instance on the box, you should be able to start SQL*Plus from the command prompt on the server by using the following syntax:
SQLPLUS / Once inside SQL*Plus, you should be connected as a DBA, so you can change any user's password. For example, to change the password for the user SYS, issue the following command in SQL*Plus:
ALTER USER SYS IDENTIFIED BY new_password;
In the 8.0.x documentation, you can read about these topics in the Oracle8 Getting Started manual (Release 8.0.6 for Windows NT) in Chapter 11, Authenticating Database Users with Windows NT.
Hope this helps!
Chris
"Chris" <nothanks_at_home.com> wrote in message
news:2$--$$-$-%$$$-%%_$@news.noc.cabal.int...
> I am the network manager for a company where we recently had to let our
> DBA go. The problem is he never gave us the dba passwords to the DB. Now
> we are having some issues. Can anyone please assist me in this process.
> I have full physical as well as admin access to the machine.
> It is running NT 4.0. I do however have limited user access to the DB.
> I am NOT a DBA so keep that in mind when answering.
>
> thanks in advance.
>
> ========= WAS CANCELLED BY =======:
> Path:
news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed0
0.sul.t-online.de!t-online.de!newsfeed.freenet.de!news2.euro.net!uunet!ash.u
u.net!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r
> From: Chris <nothanks_at_home.com>
> Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.server
> Subject: cmsg cancel <3C30B239.8060809_at_home.com>
> Control: cancel <3C30B239.8060809_at_home.com>
> Date: Wed, 2 Jan 2002 03:43:31 GMT
> Organization: Navix Internet Subscribers
> Lines: 2
> Message-ID: <cancel.3C30B239.8060809_at_home.com>
> NNTP-Posting-Host: 166.102.15.34
> X-Trace: iac5.navix.net 1009944990 21023 166.102.15.34 (2 Jan 2002
04:16:30 GMT)
> X-Complaints-To: abuse_at_navix.net
> NNTP-Posting-Date: 2 Jan 2002 04:16:30 GMT
> X-No-Archive: yes
> Comment: Dude, where's my NewsAgent?
> Xref: news.uni-stuttgart.de control:40280091
>
> autocancel
>
Received on Mon Jan 07 2002 - 10:39:53 CST
 |
 |