OraFAQ Forum: Security » password creation in oracle 10g

Home » RDBMS Server » Security » password creation in oracle 10g (xp)

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

password creation in oracle 10g [message #364861]

Wed, 10 December 2008 05:20

sekharsomu
Messages: 72
Registered: December 2008

Member

I have three databases like eam,eai,s2px
so i wanted to authenticate them with separate password file using orapwd utilities
so i have made 3 entries like this in command prompt (one after another)
c:\orapwd file=oraeai password=eai ENTRIES=10
c:\orapwd file=oraEAM password=EAM ENTRIES=10
c:\orapwd file=oras2px password=s2px ENTRIES=10
but i could not find any entries in my( D:\oracle\product\10.2.0\db_1\dbs )dbs folder
now how should i proceed
are my password files created successfully (i didn't receive any such message in the command prompt)
please guide me with this issues i know how to proceed with futher steps
like
set the value of REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE in INIT.ORA
MY DATABASE :ORACLE 10G
THANKS IN Advance

Report message to a moderator

Re: password creation in oracle 10g [message #364862 is a reply to message #364861]

Wed, 10 December 2008 05:25

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

Senior Member
Account Moderator

Quote:

but i could not find any entries in my( D:\oracle\product\10.2.0\db_1\dbs )dbs folder

They are created where you tell Oracle to create it. If you don't give a path it is current directory.

C:\>orapwd file=x password=x entries=10

C:\>dir x
 Directory of C:\

10/12/08  12:23 PM             2,560 x
               1 File(s)          2,560 bytes
               0 Dir(s)  18,772,480,000 bytes free

Quote:

are my password files created successfully (i didn't receive any such message in the command prompt)

If they didn't you'd receive either an error message either the usage message.

Regards
Michel

Report message to a moderator

Re: password creation in oracle 10g [message #364865 is a reply to message #364862]

Wed, 10 December 2008 05:29

sekharsomu
Messages: 72
Registered: December 2008

Member

thank u thank x for the giffy reply(i see them in that location)
can u suggest me in what location its better to create this password files

[Updated on: Wed, 10 December 2008 05:30]

Report message to a moderator

Re: password creation in oracle 10g [message #364868 is a reply to message #364861]

Wed, 10 December 2008 05:32

sekharsomu
Messages: 72
Registered: December 2008

Member

now can i copy this password files manually to the location i require or i have to create them once again

Report message to a moderator

Re: password creation in oracle 10g [message #364876 is a reply to message #364865]

Wed, 10 December 2008 05:50

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

Senior Member
Account Moderator

The target location is %ORACLE_HOME%\database.
You can move them there.
But you have to rename them, correct name on Windows is PWD<SID>.ORA

Regards
Michel

Report message to a moderator

Re: password creation in oracle 10g [message #364883 is a reply to message #364876]

Wed, 10 December 2008 06:01

sekharsomu
Messages: 72
Registered: December 2008

Member

i see that they are already present in the database folder
now can i proceed with further steps

Report message to a moderator

Re: password creation in oracle 10g [message #364887 is a reply to message #364883]

Wed, 10 December 2008 06:12

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

Senior Member
Account Moderator

If you want to use these new ones, yes.

Regards
Michel

Report message to a moderator

Re: password creation in oracle 10g [message #364907 is a reply to message #364887]

Wed, 10 December 2008 07:38

sekharsomu
Messages: 72
Registered: December 2008

Member

now when i tried to change the parameter REMOTE_LOGIN_PASSWORDFILE in my respective init.ora files for each database all the files are already set to exclusive mode what shuld i do now?
NOTE:thepath for my init files are as follows
D:\oracle\product\10.2.0\admin\EAM\pfile
D:\oracle\product\10.2.0\admin\EAI\pfile
D:\oracle\product\10.2.0\admin.........

Report message to a moderator

Re: password creation in oracle 10g [message #364909 is a reply to message #364907]

Wed, 10 December 2008 07:41

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

Senior Member
Account Moderator

Quote:

now when i tried to change the parameter REMOTE_LOGIN_PASSWORDFILE in my respective init.ora files for each database all the files are already set to exclusive mode what shuld i do now?

Restart the instances.

Regards
Michel

Report message to a moderator

Re: password creation in oracle 10g [message #364914 is a reply to message #364909]

Wed, 10 December 2008 07:59

sekharsomu
Messages: 72
Registered: December 2008

Member

i have tried it came to no use
can u have look at my init.ora file
just i am sending one that of eam
please suggest me a method so that i can authenticate these three databases with different password files;

Attachment: init.ora.txt
(Size: 2.55KB, Downloaded 741 times)

[Updated on: Wed, 10 December 2008 08:02]

Report message to a moderator

Re: password creation in oracle 10g [message #364934 is a reply to message #364914]

Wed, 10 December 2008 08:55

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

Senior Member
Account Moderator

I suggest you to read Administrator's Guide.

Regards
Michel

Report message to a moderator

Previous Topic:	Active Directory Password change
Next Topic:	auditing is not working (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 22 17:44:04 CDT 2023