Database Administration (MOSC)

MOSC Banner

ora-27102 error occurring in the middle of the tests

edited Jun 13, 2018 4:46PM in Database Administration (MOSC) 6 comments
Hi we are using oracle 11gR1 (11.1.0.7) on SuSE Linux. We have 4GB memory and 2GB allocated to oracle. The swap space available is 4GB. When we are running tests in the middle of the tests the ORA-27102 error is occurring. I cannot find this error in the alert log but the application people can see this error in their serverlog.
Total System Global Area 2071076864 bytes
Fixed Size                  2161232 bytes
Variable Size            1375733168 bytes
Database Buffers          687865856 bytes
Redo Buffers                5316608 bytes

oracle@perf:~> swapon -s
Filename                                Type            Size    Used    Priority
/dev/sda5                               partition       4200956 976196  -1

cat /proc/meminfo
MemTotal:      4048976 kB
MemFree:        126176 kB
Buffers:         20212 kB
Cached:        1871208 kB

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center