| ORA-27101 problem [message #139619] |
Wed, 28 September 2005 17:43  |
vadim_se
Messages: 2
Registered: September 2005
Location: NY
|
Junior Member |
|
|
Hello,
I'm running ORACLE 8.1.7.4 on HP-UX
I build a database and was able to bring it up without any problems. The first db on this server is running just fine. I am able to access db via sqlplus.
However, when I'm trying to do imp from another server I'm getting the following error message:
IMP-00058: ORACLE error 1034 encountered
ORA-010134: ORACLE not available
ORA-27101: shared memory realm does not exist
Any ideas?
Thank you in advance.
|
|
|
|
| Re: ORA-27101 problem [message #139635 is a reply to message #139619] |
Wed, 28 September 2005 23:01  |
rockwell
Messages: 8
Registered: September 2005
|
Junior Member |
|
|
i think i had the same problems a few days ago and i solved it by assigning the proper db_cache_size value and sharedpool_size, they should not exceed your RAM value. U even got to check one more thing, check the semaphores values in the /etc/system file.
Hope this works for you .........
|
|
|
|
|
|
| Re: ORA-27101 problem [message #139783 is a reply to message #139619] |
Thu, 29 September 2005 10:00 |
vadim_se
Messages: 2
Registered: September 2005
Location: NY
|
Junior Member |
|
|
Girish,
Yes, the db that I'm importing to is running. But it is blank. Only oracle db space is running.
Rockwell,
I reduced the amount of tablespaces, but left much bigger than the usage size anyway. Do you think it make a difference during import?
If I don't have enough memory/disk space on the server to match original server settings what should I do in terms of shared_pool_memory and etc.?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
