OraFAQ Forum: Server Administration » password file "pwd<sid> got corrupted"

Home » RDBMS Server » Server Administration » password file "pwd got corrupted"

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

password file "pwd got corrupted" [message #54085]

Mon, 28 October 2002 23:30

srikanth
Messages: 40
Registered: July 2001

Member

HI,
My database password file "pwd<sid>.ora" got corrupted and hance was accidently deleted meddling it.How do i recover my database now.

I get "error opening password file".Little bit utgent

Thanx in advance,
Srikanth

Report message to a moderator

Re: password file "pwd got corrupted" [message #54087 is a reply to message #54085]

Tue, 29 October 2002 01:28

B
Messages: 327
Registered: August 1999

Senior Member

use orapwd to recreate it ... don't worry no need to recover.

type orapwd for help.

Report message to a moderator

Re: password file "pwd got corrupted" [message #54089 is a reply to message #54085]

Tue, 29 October 2002 05:03

srikanth
Messages: 40
Registered: July 2001

Member

HI,
orapwd just has the syntax "orapwd file password(sys/internal) entries(users)".Where do i specify my database <sid>.The file it creates also doesn't contain the sid in it(i compared this with other databases' password files).So when i configure my net service name and test it,it says "could not resolve service_name in connect descriptor".i guezz the problem should be becoz of the password file.Just elaborate on what u mentioned.tell me the complete steps to recreate a password file for a database assuming i have all the other required files everythin'

Thanx in advance,
Srikanth

Report message to a moderator

Re: password file "pwd got corrupted" [message #54091 is a reply to message #54085]

Tue, 29 October 2002 05:51

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1.  no need to specify the database.
    the file nameshouldbe be orapw(sid)
    it must created only in $ORACLE_HOME/dbs directory.
    syntax is ( assuming sid=prod)
    orapwd file=orapwprod password=yourpassword entries=10
    make sure u shutdown the database before recreating the passwordfile.
2.  [i]could not resolve service_name in connect descriptor[/i]
    for this, you need to lookin into tnsnames.ora

Report message to a moderator

Re: password file "pwd got corrupted" [message #54093 is a reply to message #54091]

Tue, 29 October 2002 06:50

srikanth
Messages: 40
Registered: July 2001

Member

HI,
But when u compare a password file generated during the database creation and a password created using orapwd,the "database sid" is missing in the newly created one.Do u mean to say orapwd determines whatever succeeds PWD as the database sid.Even if it does that,the file doesn't contain the database sid.I fear this could cause problems.I am trying out one and would mail u if i encounter any problems.

What now i am working on is backing up the database files on one node and trying to mount the database on another node without the password file.for this i am using orapwd to generate the paswd file.

Thanx,
Srikanth

Report message to a moderator

Previous Topic:	TNS could not resolve service name on Mac OS X
Next Topic:	Getting Ora-03113 if we specify the SID

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 13:53:17 CST 2024