-
HI guys
I exported the full data from Oracle 734 WinNT4.0 (production) server5
to another server4 (Oracle734 WinNt4.o).But after importing the data i couldn't able to connect either by sqlplus or through server manager.The error message is
svrmgr>connect internal
password:******
ora-01031:Insufficient privileges
svrmgr>!sqlplus system/manager
error: ora-01034:oracle not available
ora-09243:smsget:error attaching to sga
osd-04101:invalid sga:sga not initialized
0/s-error <os 203> the system couldn't find the environment option that was entered.
please come back to me Immediately.I need to accomplish this task today.
Thanks
Ravi
ravi
-
1. Did you set the ORACLE_SID before loging into server manager.
2. If it was a full database import, then you would have to use the old sys or system password and you will not be able to use the new one untill you do alter user sys identified by ...
BTW, I forgot to notice that the problem on shared memory segment and the sga. It could be the case that your new system is out of memory resource to accomodate the new sga.
Either try ajusting the SGA
SGA = shared_pool_size + large_pool_size + log_buffers + (db_block_size * db_block_buffers) + java_pool_size.
Ajust it to fit your memory size. either shared_pool or db_block_buffers
Good luck
Sam
[Edited by sambavan on 02-19-2001 at 07:44 PM]
Thanx
Sam
Life is a journey, not a destination!
-
Hi Guys
I solved the problem by deleting and recreating the services.
Ravi
ravi
-
Hi Sam
Thanks Alot for your Advice and help.
I end up with one more problem i.e.,
..importing table "ATTACHMENT_BLOB"
IMP-00020: long column too large for column buffer size (9999886)
IMP-00028: partial import of previous table rolled back: 59 rows rolled back.
I used the command:
imp73 system/***** file='d:\export\exp.dmp log='d:\export\exp.log' buffer=10000000 full=y.
Please let me know ASAP.
Thanks
Ravi
ravi
-
Here is what I get when I do
oerr imp 20
00020, 00000, "long column too large for column buffer size (%lu)"
// *Cause: The column buffer is too small. This usually occurs when importing
// LONG data.
// *Action: Increase the insert buffer size 10,000 bytes at a time (for
// example). Use this step-by-step approach
// because a buffer size that is too large may cause a similar
// problem.
Good luck,
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Buffer size mentioned is too big to support by OS. Try finding some doc on max buffer size on NT. Anybody know it ? Help us to deal with NT please..
Reddy,Sam
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
|