OraFAQ Forum: Server Administration » Password File (oracle)

Home » RDBMS Server » Server Administration » Password File (oracle) (RHEL)

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

Password File (oracle) [message #340146]

Mon, 11 August 2008 11:48

smunir362
Messages: 310
Registered: September 2007

Senior Member

How to change the path of oracle database password file from '/oracle/software/dbms/dbs/orapwdSID" to "/database/conf/"

Report message to a moderator

Re: Password File (oracle) [message #340147 is a reply to message #340146]

Mon, 11 August 2008 11:52

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

Senior Member
Account Moderator

It should reside in $ORACLE_HOME/dbs, where ever it is.

Report message to a moderator

Re: Password File (oracle) [message #340150 is a reply to message #340146]

Mon, 11 August 2008 12:05

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Create a link or use a pfile with the statement "spfile=<your spfile>".

Regards
Michel

Report message to a moderator

Re: Password File (oracle) [message #340151 is a reply to message #340150]

Mon, 11 August 2008 12:24

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

Senior Member
Account Moderator

Michel,
Seems the OP is asking for password file?

Report message to a moderator

Re: Password File (oracle) [message #340152 is a reply to message #340146]

Mon, 11 August 2008 12:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

smunir362 wrote on Mon, 11 August 2008 09:48

How to change the path of oracle database password file from '/oracle/software/dbms/dbs/orapwdSID" to "/database/conf/"

by using a softlink?

ln -s /oracle/software/dbms/dbs/orapwdSID /database/conf/

Report message to a moderator

Re: Password File (oracle) [message #340153 is a reply to message #340151]

Mon, 11 August 2008 12:42

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Ooops!

I wonder why I thought about spfile!
Link is still an answer.

Regads
Michel

Report message to a moderator

Re: Password File (oracle) [message #340154 is a reply to message #340152]

Mon, 11 August 2008 12:44

smunir362
Messages: 310
Registered: September 2007

Senior Member

Create a link or use a pfile with the statement "spfile=<your spfile>".

Soft link is ok. I understand.....
But what you mean "Use a pfile with the statement "spfile=<spfile>.

Report message to a moderator

Re: Password File (oracle) [message #340163 is a reply to message #340154]

Mon, 11 August 2008 13:13

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Read my previous answer.

Regards
Michel

Report message to a moderator

Previous Topic:	Table size doen not reduce
Next Topic:	database archival policy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 15:59:07 CDT 2024