Xref: alice comp.databases.oracle.server:73550
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newspeer.clara.net!news.clara.net!remarQ-uK!rQdQ!supernews.com!remarQ.com!remarQ69!WReNclone!WReNphoon1.POSTED!WReN!not-for-mail
From: Boogie <peter.finnNOpeSPAM@rsa12.royalsun.com.invalid>
Subject: Re: how to start oracle services without password file
Newsgroups: comp.databases.oracle.server
Message-ID: <0a0133f8.8fb69f0b@usw-ex0101-005.remarq.com>
Lines: 37
Bytes: 856
X-Originating-Host: 193.133.190.51
Organization: http://www.remarq.com: The World's Usenet/Discussions Start Here
References: <80d3l8$pd8$1@nnrp1.deja.com>
X-Wren-Trace: eCMGLi82cTtwczI/I3FsLDg+PQY0NGJkdGE+LzM2NnA5Ky0hIm52fHZxaXd+MH5le39heWU=
Date: Thu, 11 Nov 1999 07:50:50 -0800
X-Complaints-To: wrenabuse@remarq.com
X-Trace: WReNphoon1 942335821 10.0.2.5 (Thu, 11 Nov 1999 07:57:01 PST)
NNTP-Posting-Date: Thu, 11 Nov 1999 07:57:01 PST

Hello,

The process depends on the Oracle version;

For Oracle 7,

Execute NT Instance Manager located in the Oracle For Windows NT Group
and edit the instance, there are options to set the passsword and start
the database automatically.

for Oracle 8

- Stop the database

- Delete the instance

oradim80 -delete -sid SID

- Recreate the instance

oradim80 -new -sid SID -intpwd <password> -startmode <auto> -pfile
<path\initSID.ora>

- Check oracle_home\database\strt<sid>.cmd,

The above script is used by the service to start the database, you may
just have to examine the script and the log

oracle_home\rdbmsxx\oradimxx.log

to determine what your problem is !

Boo


* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!