|
|
| Re: How to Recreate Password File [message #301272 is a reply to message #301271] |
Tue, 19 February 2008 22:54   |
trantuananh24hg
Messages: 744
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 #301307 is a reply to message #301273] |
Wed, 20 February 2008 00:39 |
trantuananh24hg
Messages: 744
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
