VERY URGENT

[cravi]

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

[sambavan]

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]

[cravi]

Hi Guys

I solved the problem by deleting and recreating the services.

Ravi

[cravi]

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

[sambavan]

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

[sreddy]

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..