Home » Other » General » Password file creation (Oracle 10g R2, Windows 2003 Server)
Password file creation [message #489957] Thu, 20 January 2011 04:23 Go to next message
gxeon
Messages: 53
Registered: January 2011
Location: Mumbai
Member
Hi

got stuck in a problem...i want to create a new password file for my database but when i create new password file with the orapwd...i am not sure whether its takeing the new password file which i created OR its takeing the earlier one.......

please help in this....i want Database shuld take the password file which i create not the default....

its bit urgent...
Re: Password file creation [message #489959 is a reply to message #489957] Thu, 20 January 2011 04:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i create new password file with the orapwd...i am not sure whether its takeing the new password file which i created OR its takeing the earlier one

If you don't trust Oracle it takes what you give it better leave Oracle and try to work for something else you can trust.

Can you tell me what is the purpose of writing multiple dots? Are you writing a telegram?
Please refrain this way of writing, use proper and plain english.

And note that nothing is urgent in a forum. You should better properly write your question with all relevant information.

Regards
Michel

[Updated on: Thu, 20 January 2011 04:47]

Report message to a moderator

Re: Password file creation [message #489961 is a reply to message #489959] Thu, 20 January 2011 04:54 Go to previous messageGo to next message
gxeon
Messages: 53
Registered: January 2011
Location: Mumbai
Member
m sorry,i only wanted to know that how can i verify that the database is opening with the password file which i created.
Re: Password file creation [message #489962 is a reply to message #489961] Thu, 20 January 2011 05:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try to use a different password and you will see.

Regards
Michel
Re: Password file creation [message #500045 is a reply to message #489962] Thu, 17 March 2011 06:35 Go to previous messageGo to next message
Scarlet87
Messages: 2
Registered: March 2011
Location: Mumbai
Junior Member
Hi,
I have created a database with 11gR2 on suse 11. I want to create a passwordfile to define password for sys and system. Can anyone confirm the steps for the same and suggest if any additional step is required:

1- shut down database
2-orapwd file=$ORACLE_HOME/dbs/orapwd password=password_for_sys
3- startup
4- use specified password

If I want to specify system password too, what wud be the steps?
Re: Password file creation [message #500051 is a reply to message #500045] Thu, 17 March 2011 07:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what wud be the steps?

Change it in the instance that uses this spfile.

Regards
Michel
Re: Password file creation [message #500191 is a reply to message #500051] Thu, 17 March 2011 23:58 Go to previous messageGo to next message
Scarlet87
Messages: 2
Registered: March 2011
Location: Mumbai
Junior Member
Quote:
Change it in the instance that uses this spfile.


HOW?


Thnks & Rgds
Scarlet
Re: Password file creation [message #500195 is a reply to message #500191] Fri, 18 March 2011 00:27 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALTER USER system IDENITIFIED BY ...;

Regards
Michel
Previous Topic: where to download 9.2.0.8 Oracle client
Next Topic: Payment Terms
Goto Forum:
  


Current Time: Thu Mar 28 04:14:48 CDT 2024