Rick,
Great point, I looked in the 9ihome\database directory and the ifile is
there. It just must me a bug I guess. Thanks Rick, I really didn't know
that, but I did know about that directory for when i was doing cold
backups:)
KK
-----Original Message-----
T (Richard)
Sent: Friday, August 31, 2001 11:37 AM
To: Multiple recipients of list ORACLE-L
Kevin,
As you are probably aware by default when attempt to start an instance when
starting the services, Oracle
looks only in oracle_home\database for init file and parameter file(I cannot
speak for 9i).
Rick
-----Original Message-----
Sent: Friday, August 31, 2001 11:02 AM
To: Multiple recipients of list ORACLE-L
Tom,
Not that I can remember. It only happened, like you said, if
something was
physically wrong or something was wrong with the init file. The only time
where nothing was wrong with anything and it didn't come up that I can
remember is the 9i. Nothing wrong anywhere, just didn't come up.
Kev
-----Original Message-----
Thomas F
Sent: Friday, August 31, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L
Kevin,
of course, if there is an error in the init.ora file, the db won't start, or
if there is something wrong with the physical database, it will not start.
are you saying you've seen other problems where the db doesn't come up?
and as for the recently reported problem of the db on 9i not coming up, I
know this was a bug with 816 on w2k. I forget the resolution of that one...
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Friday, August 31, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L
Tom,
Usually I would agree with you on that one, most of the time it does
start.
But there are those occasions where the "service" will start, but then when
you go to connect to the db it says "Oracle not available" because of some
stupid error. So then you go with svrmgrl to find what in the hay is goin
on:)
Sincerely,
Kev
-----Original Message-----
Thomas F
Sent: Friday, August 31, 2001 9:17 AM
To: Multiple recipients of list ORACLE-L
Scott,
you are absolutely wrong on this one. every database I am working with on
NT starts when the service starts. even without setting the AUTOSTART
param.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Thursday, August 30, 2001 6:16 PM
To: Multiple recipients of list ORACLE-L
Kevin, Starting the NT service for the oracle instance
has never started the database in any version of
Oracle on NT by default. I think what you have seen
before is the use of the auto start service of the DB.
This service has a dependency to the SID service, so
when you start the SID service it would start the
database as well. This auto start and shutdown feature
can be configured through the oradim.exe command.
If you already have the SID service create then:
oradim -edit -sid test -startmode a -pfile
d:\ora901\database\init.ora
There is also a -startup option that will allow you to
specify the password.
Good Luck,
Scott
--- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote:
> Just thought I would mention this interesting little
> feature. Now I don't
> know if I am an idiot or if something went wrong
> (probably both), but
> apparently NT services will not start the instance.
> I had to manually start
> it to get it to go? I guess in a way that's good,
> move little nt people
> like me away from the GUI tools:)
>
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Kevin Kostyszyn
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).