| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 9i NT
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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott INET: oraracdba_at_yahoo.com 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: ListGuru_at_fatcity.com (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: NDATFM_at_labor.state.ny.us 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: ListGuru_at_fatcity.com (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: kevin_at_dulcian.com 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: ListGuru_at_fatcity.com (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: NDATFM_at_labor.state.ny.us 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: ListGuru_at_fatcity.com (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: kevin_at_dulcian.com 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: ListGuru_at_fatcity.com (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: RICHARD.T.CALE_at_saic.com 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: ListGuru_at_fatcity.com (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: kevin_at_dulcian.com 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: ListGuru_at_fatcity.com (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).Received on Fri Aug 31 2001 - 10:04:57 CDT
 |
 |