Home » RDBMS Server » Server Administration » How to Recreate Password File
How to Recreate Password File [message #301271] Tue, 19 February 2008 22:46 Go to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear Friends,

I need to recreate the password file. Can any one please tell me the syntax. I can't remember it Embarassed

I have one more problem when my PC is started and I login to windows it shows me ORADIM.exe generated an error. What seems to be the problem. And also the database is not allowing me to connect with my user like scott/tiger

When I do so after few seconds it give me following errors:

1- ORA-01034: ORACLE not available
2- ORA-27101: shared memory realm does not exist.

I have checked the database and the listener services just in case they are running.

Regards,
Azam Khan
Re: How to Recreate Password File [message #301272 is a reply to message #301271] Tue, 19 February 2008 22:54 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
What's your OS?

Example
Windows:
--Remove/Rename the old password file and
C:\>orapwd file='C:\oracle\product\10.2.0\prod1\Database\PWDProd1.ora password=Oracle entries=5


Unix
--Remove/Rename the old password file and
$orapwd file='/u01/oracle/product/10.2.0/Prod1/Database/PWDProd1.ora password=Oracle entries=5


Quote:

ORA-27101: shared memory realm does not exist



Some thing relates this error. One of them may be the SGA_MAX_SIZE/SGA_TARGET is too big. Repaird the parameter in pfile.ora and create spfile from the repaired, startup by spfile.


[Updated on: Tue, 19 February 2008 22:56]

Report message to a moderator

Re: How to Recreate Password File [message #301273 is a reply to message #301272] Tue, 19 February 2008 22:59 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear Friend,

First of all thanks for the quick reply. About "ORA-27101: shared memory realm does not exist" error you said "Repaird the parameter in pfile.ora and create spfile from the repaired, startup by spfile."

Can you please tell me me how?

Regards,
Azam Khan
Re: How to Recreate Password File [message #301307 is a reply to message #301273] Wed, 20 February 2008 00:39 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Quote:

First of all thanks for the quick reply. About "ORA-27101: shared memory realm does not exist" error you said "Repaird the parameter in pfile.ora and create spfile from the repaired, startup by spfile."

Can you please tell me me how?



First time, you must define your physical memory in your machine. And then, you must define what's your OS which is 32 or 64 bit. There is one difference between them. And there is one difference between Windows and Unix.

Open your $ORACLE_HOME$\Database\pfileSID.ora by any text editor, find and re-edit the parameter SGA_MAX_SIZE or SGA_TARGET's value.


[Updated on: Wed, 20 February 2008 00:41]

Report message to a moderator

Re: How to Recreate Password File [message #301308 is a reply to message #301271] Wed, 20 February 2008 00:40 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The errors just say the database is not up, so start it.

Regards
Michel
Previous Topic: DML(s) related to transactions
Next Topic: list partition
Goto Forum:
  


Current Time: Wed Dec 07 02:40:48 CST 2016

Total time taken to generate the page: 0.15988 seconds