Today i got an error ORA-00064 in Oracle 10g Express Edition on Windows platform.
When the Oracle starts then it read the Initialization file and allocates the memory of all parameters say for session , process and all . And if anyone don't have sufficient resource to allocate them then this issue persists.
According to my environment one of my friend increased the sessions to 5000, when Oracle is restarted, it throws error.
Following steps are performed to resolve this issue.
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\navneet>sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 27 13:15:32 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to an idle instance.
SQL> startup
ORA-00064: object is too large to allocate on this O/S (1,9080000)
SQL> create pfile='c:\pfile.ora' from spfile;
File created.
Then i edited the pfile.ora and reduced the session to 100 from 5000.
SQL> startup pfile='c:\pfile.ora';
ORACLE instance started.
Total System Global Area 599785472 bytes
Fixed Size 1288820 bytes
Variable Size 180356492 bytes
Database Buffers 415236096 bytes
Redo Buffers 2904064 bytes
Database mounted.
Database opened.
Now our pfile.ora is perfect, no need anymore edition. We are going to create spfile from this pfile.
SQL> create spfile from pfile='c:\pfile.ora';
File created.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 599785472 bytes
Fixed Size 1288820 bytes
Variable Size 180356492 bytes
Database Buffers 415236096 bytes
Redo Buffers 2904064 bytes
Database mounted.
Database opened.
Your suggestions and queries are always warm welcomed.
