Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Why it picks the same PFile for both the DBs

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

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Tue, 03 Sep 2002 07:28:21 -0800
Message-ID: <F001.004C6067.20020903072821@fatcity.com> 





Naveen,



Ther password file has nothing to do with ORADIM.  ORADIM is used to create,
modify or delete NT services for maintaining the Oracle instance on the NT
box.



I'm not sure what you mean by "register the password file...using ORADIM".



ORADIM can be used to create the service using a specific password, but it
is not needed at all.



Tom Mercadante


Oracle Certified Professional




-----Original Message-----


Sent: Tuesday, September 03, 2002 10:58 AM
To: Multiple recipients of list ORACLE-L




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 - 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).


-- 

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: 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: 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).


Received on Tue Sep 03 2002 - 10:28:21 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US