Home » RDBMS Server » Server Administration » Password File (oracle) (RHEL)
Password File (oracle) [message #340146] Mon, 11 August 2008 11:48 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Ooops! Embarassed 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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 22:37:39 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.