OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Password file (10g, Solaris 10)

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

Password file [message #395037]

Tue, 31 March 2009 02:49

pokhraj_d
Messages: 117
Registered: December 2007

Senior Member

Hi,

At my dev server there are 5 instances are running.
Now I want to create password file for each instance.
How oracle instances knows which password files created for that instance only.

For example:

If there are two instances are running

a) TST1
b) TST2

And there are two password files orapwTST1 and orapwTST2, how the instances knows that orapwTST1 is for TST1 instance and orapwTST2 is for TST2 instance.

Please help.

Pokhraj

Report message to a moderator

Re: Password file [message #395063 is a reply to message #395037]

Tue, 31 March 2009 04:05

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

Senior Member
Account Moderator

The instance knows its name.

Regards
Michel

[Updated on: Tue, 31 March 2009 04:06]

Report message to a moderator

Re: Password file [message #395068 is a reply to message #395037]

Tue, 31 March 2009 04:14

pokhraj_d
Messages: 117
Registered: December 2007

Senior Member

Hi,

Thanx for your comments.
My confusion is , if I change the password file name orapwTEST1, still the TST1 is able to use this file ?

Pokhraj

Report message to a moderator

Re: Password file [message #395075 is a reply to message #395068]

Tue, 31 March 2009 04:31

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>> I change the password file name orapwTEST1, still the TST1 is able to use this file ?

First of all try to understand what is password file.

1/ delete/remove all password files

2/ creat new password files as per your requirement.

Babu

Report message to a moderator

Re: Password file [message #395084 is a reply to message #395068]

Tue, 31 March 2009 04:50

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

Senior Member
Account Moderator

pokhraj_d wrote on Tue, 31 March 2009 11:14

Hi,

Thanx for your comments.
My confusion is , if I change the password file name orapwTEST1, still the TST1 is able to use this file ?

Pokhraj

No.
An instance knows its password file from its own name.

Regards
Michel

[Updated on: Tue, 31 March 2009 04:50]

Report message to a moderator

Previous Topic:	10.1.0.4 listener spawns a child listener and DB is hung
Next Topic:	oracle DB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 23:57:48 CDT 2024