Ya, Thanx everyone for the ideas.
I think the problem must be the creation of password files, because after
that you have to register the password file with the instance using ORADIM.
The problem was not big but what and why is more important to me now
Thanx
Naveen
-----Original Message-----
Sent: Tuesday, September 03, 2002 6:58 PM
To: Multiple recipients of list ORACLE-L
Naveen,
I would try edit first. If it doesn't work, then delete and create. It is
no big deal - delete does not touch the database files at all - just the
windows directory.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Tuesday, September 03, 2002 8:28 AM
To: Multiple recipients of list ORACLE-L
Forgot to mention in the previous post.
Rather DELETE and then CREATE, I think the best will be to edit the INSTANCE
using ORADIM, isn't it?
Naveen
-----Original Message-----
Sent: Tuesday, September 03, 2002 4:33 PM
To: Multiple recipients of list ORACLE-L
Have you tried to recreate your TEST service using :-
Oradim -delete
-sid TEST
Oradim -new
-sid TEST
-intpwd password
-startmode auto -pfile=d:\directory\testini.ora
Lewis Bishop
---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - [EMAIL PROTECTED]
-----Original Message-----
Sent: 03 September 2002 11:23
To: Multiple recipients of list ORACLE-L
This header confirms that this email message has been swept for the
presence of computer viruses.
Corporate IT
THE WOOLWICH
----------------------------------------------------------------------
Hi Volker,
That is OK. I can even start with STARTUP PFILE = 'appropriate_pfile';
But in this case I am unable to start it using NT Services. That is the
problem.
How do I get both the DBs to start by starting the services.
I don't know why suddenly the problem has started coming. All registry
parameters seem OK.
I'm clueless. I know I'm missing something very obvious, but what is it?
Regards
Naveen
-----Original Message-----
Sent: Tuesday, September 03, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L
Before starting svrmgr set the oracle_sid to test or prod
In command window:
SET ORACLE_SID=TEST
HTH
Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-----Ursprüngliche Nachricht-----
Von: Naveen Nahata [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 2. September 2002 19:08
An: Multiple recipients of list ORACLE-L
Betreff: Why it picks the same PFile for both the DBs
Hi All,
I know the problem is on NT machine, whereas most of the people in the list
are working on UNIX based systems. Still any pointers will be appreciated. I
have a system with 2 databases, both running on the same server.
DB - 8.0.5.
OS - Windows NT
When i connect thru server manager to TEST, and then issue STARTUP, it
starts up the PROD database using the initPROD.ora file. On querying
V$instance it shows INSTANCE_NAME = TEST On querying V$database it shows
NAME=PROD. So the TEST instance is mounting PROD DB using initPROD.ora When
i connect to PROD and STARTUP, it starts PROD using initPROD.ora On querying
V$instance it shows INSTANCE_NAME = PROD On querying V$database it shows
NAME=PROD. So the PROD instance is mounting the PROD DB using initPROD.ora
Why is it picking up only initPROD.ora? The following registry parameters
are set... ORA_TEST_PFILE - Pointing to initTEST.ora ORA_PROD_PFILE -
Pointing to initPROD.ora ORA_TEST_PWFILE - Pointing to PWDTEST.ora
ORA_PROD_PWFILE - Pointing to PWDPROD.ora ORACLE_SID - PROD Though I can
start the DBs easily using STARTUP pfile = 'respective_pfile', but that is
not the thing. The thing is that I'm missing something, and also that I
cannot start it directly through the services. What am i possibly missing??
Regards, Naveen
Naveen Nahata
Associate IS
Email: [EMAIL PROTECTED]
MindTree Consulting Pvt. Ltd.
#42, Block 'A', 27th Cross,
2nd Stage, Banashankari,
Bangalore - 560070
Ph: 91 (80) 6711777/6712777 Ext. 1614
Fax: 91 (80) 6714000
Web: <http://www.mindtree.com/>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
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:
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: Naveen Nahata
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).
The information, attachments and opinions contained in this message are
those
of its author only and do not necessarily represent those of The Woolwich
and
or any other members of the Barclays Group and are intended solely for the
use of the individual or entity to whom they are addressed. The sender may
not be authorised to give financial advice, and nothing in this message
should be construed as offering such advice.
The message may contain privileged and confidential information and you may
not copy, distribute or take any action in reliance on it. If you have
received this email in error please notify the Information Security Manager
at [EMAIL PROTECTED]
Replies to this email may be monitored for operational or business reasons.
Woolwich plc. Registered in England Number : 3295699.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bishop Lewis
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: Naveen Nahata
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: Naveen Nahata
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).
