Home » RDBMS Server » Server Administration » Password file (10g, Solaris 10)
Password file [message #395037] Tue, 31 March 2009 02:49 Go to next message
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
Re: Password file [message #395063 is a reply to message #395037] Tue, 31 March 2009 04:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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 Go to previous messageGo to next message
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
Re: Password file [message #395075 is a reply to message #395068] Tue, 31 March 2009 04:31 Go to previous messageGo to next message
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
Re: Password file [message #395084 is a reply to message #395068] Tue, 31 March 2009 04:50 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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:
  


Current Time: Sun Dec 01 20:34:16 CST 2024