| help for getting error ORA-01304 [message #53364] |
Mon, 16 September 2002 06:21  |
chintan
Messages: 7
Registered: September 2002
|
Junior Member |
|
|
when i connect to database by supplying user and password i got follwing error
ERROR:
ORA-01304: ORACLE not available
ORA-09234:smget: error attaching to SGA
ORA-04104:invalied SGA: SGA not available
so what should i do to overcome this error
please help me soon
|
|
|
|
| Re: help for getting error ORA-01304 [message #53370 is a reply to message #53364] |
Mon, 16 September 2002 11:38  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
You are having problems attaching SGA to the shared memory. Very detailed explanation of this problem and the parameters in /etc/system (for Solaris) could be found Here.
The remedies include to setup SHMMAX, SHMMIN, SHMMNI and the swap space according to your environment.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
