RE: Why it picks the same PFile for both the DBs

Lewis,

Ya that is the only logical thing left to do. Haven't done it as yet because all the registry parameters seemed fine and ORADIM does nothing more than creating a few registry entries.

But ORADIM knows more than me what registry parameters to set, so i'll give it a shot.

Regards,
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 - lewis.bishop_at_woolwich.co.uk


-----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:v.schoen_at_inplan.de
http://www.inplan.de



-----Ursprüngliche Nachricht-----
Von: Naveen Nahata [mailto:naveen_nahata_at_mindtree.com] 
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: naveen_nahata_at_mindtree.com
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: naveen_nahata_at_mindtree.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: 
  INET: v.schoen_at_inplan.de

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: Naveen Nahata
  INET: naveen_nahata_at_mindtree.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).


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 ADMINISTRATOR_at_WOOLWICH.CO.UK

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: Lewis.Bishop_at_woolwich.co.uk

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: Naveen Nahata
  INET: naveen_nahata_at_mindtree.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).