| pikun |
Posted: Jun 16, 2008 01:54:15 AM |
Total Post: 17
Joined: Jan, 2008
|
I AM getting following error while running the statspack procedure.
When i run EXEC STATSPACK.SNAP thn I got this error
ERROR at line 1:
ORA-01116: error in opening database file 2
ORA-01110: data file 2: '/russellStreet/dbs/dbf/acestr/undotbs01.dbf'
ORA-27092: skgfofi: size of file exceeds file size limit of the process
Additional information: 132104
Additional information: 187393
ORA-06512: at "PERFSTAT.STATSPACK", line 1748
ORA-06512: at "PERFSTAT.STATSPACK", line 91
ORA-06512: at line 1
Please suggest. |
|
|
 Murtuja |
| Posted: Jun 16, 2008 02:25:04 AM |  |
|
Total Post: 843
Joined: Jan, 2006
|
Verify the ulimit setting
# ulimit
unlimited
After increasing ulimit setting restart database.
For more informaion read this section from below site.
Setting Shell Limits for the Oracle User
http://www.akadia.com/services/ora_linux_install_10g.html
|
|
|
|
|
| pikun |
| Posted: Jun 16, 2008 02:50:07 AM | |
|
Total Post: 17
Joined: Jan, 2008
|
ok let me check it. sorry for duplicate posting. actually N/W connectivity lost. thts y it happened
|
|
|
|
|
| Murtuja |
| Posted: Jun 17, 2008 01:01:22 AM | |
|
Total Post: 843
Joined: Jan, 2006
|
Hi,
Do you have any updates regarding this issue ? Please post it here if you have any more doubts or findings.
Thanks and Regards
Murtuja
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
