URGENT: Database dont start

[ccastaneda]

Ppl:

Need urgent help.. Ppl waiting outside my door...

I cannot start the production database..
We have 2 DB in a box.. 1 production and 1 for dev.

When the database start i get the error..

ORA-01991: invalid password file 'c:\oracle\ora8\DATABASE\PWDSCOP.ORA'

I recreated the file with orapwd.. but when i try to connect to the Production DB it actually connect to the Development Database.

What i am doing wrong??..

[Mr.Hanky]

What version?
What OS?
did you specify the wrond SID?

[mike2000]

1. rename the password file
2. recreate the password file by using the ORAPWD and make sure that you use the right pfile for the database.

[ccastaneda]

Oracle 8.1.5
NT 4.0 SP 6

I am new i all this DBA stuff..

I don't know what SID actually is using orapwd for generate the file..
i know that DEV DB was the first installed in the box so maybe the Default SID is Dev's one..
How do i see the Defautl ORACLE_SID that is using orapwd for generate the file???

[DaPi]

"SET" in NT DOS box will show you the current ORACLE_SID

[Mr.Hanky]

Originally posted by DaPi
"SET" in NT DOS box will show you the current ORACLE_SID

Exactly!

SET will display the current SID.

To Change it type...

d:\set oracle_sid=Pxxx

I think you have the worng one setup.

MH

[sreddy]

Find out whats your Production SID? Comment out remote_login_passwordfile parameter in initSID.ora as QUICKET solution to be able to start your database.

[stecal]

Stand up from the computer and scream at the top of your lungs that the devil has possessed this workstation and it needs to be destroyed NOW before Satan can escape from the database. That should buy you about an hour. During that hour, go to the nearest bookstore that carries computer books and buy yourself a database administration handbook. Ideally, one that deals with Windows. You can also try reading Oracle documentation at tahiti.oracle.com.

How "new" are you to this job? One or two days? Okay. Three days or more? Why were you too lazy to read up on Oracle DBA? What is the name of your company so the rest of us can be on the lookout for the job ad seeking an Oracle DBA?

[stecal]

Right-click My Computer>Properties>Environment
Scroll down System and User variables. Look for ORACLE_SID entry.
If that is set, every time you open an MS-DOS window, ORACLE_SID will be set to that database.

To confirm which ORACLE_SID is in use in an MS-DOS window, enter
echo %ORACLE_SID%

If nothing is returned, or the wrong SID is returned, change it by
set ORACLE_SID=name_of_your_database

Once you have the correct SID, you can enter svrmgrl to start/stop/do other things

C:\>svrmgrl
(some verbage)
SVRMGR>connect internal
...then let us know what you get from that

[ccastaneda]

Now i get ORA-12560.. when i try to start up the instance