-
I got this error:
ERROR: ORA-01034: ORACLE not available
ORA-09243: smsget: error attaching to SGA
OSD-04101: invalid SGA: SGA not initialized
I restart the db but the same error
Please advise
-
Did you change any init.ora parameters since your db was last brought down? If so, you probably have an incompatibility with your init.ora and system configuration. If you're on unix, I would check your kernal params.
Jeff Hunter
-
It could be because of the SGA is set too large overload the
system RAM .
Boot you DB step by step ( before that count how much is your SGA :
share_pool + block size * db block buffer
My senior told me that it should not over 40% of the physical RAM .
-
I also once had this one cause the DB crashed, and the lkSID file was remaining in $ORACLE_HOME/dbs ... check that ...
also you can do :
ipcs -a | grep oracle
and see if you still have a semaphore and memory segment attached to your instance
-
Hello,
Check the following parameters in the init[SID].ora file :
db_block_size
db_block_buffers
log_buffers
shared_pool%%
if these parameters are OK, try to startup (nomout) you DB.
If you have the same problem, try : shutdown abort then startup nomount...
Hope this helps
-
Are you using Windows 2000/ NT ?
I had this problem on windows platform which I could'nt resolve and had to reinstall Oracle. Fortunately, it was only personal Oracle on Home Computer.
-
O/S is Windows NT
I was able to restart the oracle. But I have to start manually Oracle services.
And I still investigate what happened
Thanks
You are great
-
Please let us know how you could manage to restart, what line of action you took.
-
Check your trace files....
Sam
Thanx
Sam
Life is a journey, not a destination!
-
1. From Alert log
Tue Oct 30 18:30:18 2001
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
2.
2.1 What I did on Wed Oct 31 I shut down and restart the db but even than I got the err
ERROR: ORA-01034: ORACLE not available
ORA-09243: smsget: error attaching to SGA
OSD-04101: invalid SGA: SGA not initialized
2.2 I checked the services and Oracle Db did not started so I started manually
3.From Alert log
Wed Oct 31 09:41:41 2001
alter database “prod”mount exclusive
Wed Oct 31 09:41:43 2001
Successful mount of redo thread 1.
Wed Oct 31 09:41:43 2001
Completed: alter database “prod”mount exclusive
Wed Oct 31 09:41:44 2001
alter database “prod”open
ORA-1116 signalled during: alter database “prod”open...
I am not an expert as a DBA so could you have any idea what happened.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|