Home » RDBMS Server » Security » password creation in oracle 10g (xp)
password creation in oracle 10g [message #364861] Wed, 10 December 2008 05:20 Go to next message
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
Re: password creation in oracle 10g [message #364862 is a reply to message #364861] Wed, 10 December 2008 05:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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
Re: password creation in oracle 10g [message #364865 is a reply to message #364862] Wed, 10 December 2008 05:29 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: password creation in oracle 10g [message #364876 is a reply to message #364865] Wed, 10 December 2008 05:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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


Re: password creation in oracle 10g [message #364883 is a reply to message #364876] Wed, 10 December 2008 06:01 Go to previous messageGo to next message
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
Re: password creation in oracle 10g [message #364887 is a reply to message #364883] Wed, 10 December 2008 06:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you want to use these new ones, yes.

Regards
Michel
Re: password creation in oracle 10g [message #364907 is a reply to message #364887] Wed, 10 December 2008 07:38 Go to previous messageGo to next message
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.........
Re: password creation in oracle 10g [message #364909 is a reply to message #364907] Wed, 10 December 2008 07:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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
Re: password creation in oracle 10g [message #364914 is a reply to message #364909] Wed, 10 December 2008 07:59 Go to previous messageGo to next message
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 1725 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 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I suggest you to read Administrator's Guide.

Regards
Michel
Previous Topic: Active Directory Password change
Next Topic: auditing is not working (merged)
Goto Forum:
  


Current Time: Thu Mar 28 18:24:00 CDT 2024