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

2002-09-03 Thread Naveen Nahata
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

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

2002-09-03 Thread Bishop Lewis
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

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

2002-09-03 Thread Naveen Nahata
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

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

2002-09-03 Thread Naveen Nahata
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

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

2002-09-03 Thread Bishop Lewis
Personally, I never bother with edit... oradim is pretty simplistic... that's just me though... 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

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

2002-09-03 Thread Mercadante, Thomas F
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:

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

2002-09-03 Thread Naveen Nahata
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

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

2002-09-03 Thread Mercadante, Thomas F
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

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

2002-09-02 Thread Sunny Verghese
Naven, On NT while creating the service (prior to creating the Database) using ORADIM (oradim SID= PFILE= INTPWD=...), one gets to specify which PFILE should be used while starting up (as the default). I am wondering if that is where the problem lies. The good news is that the you can easily