Zara,
Giving credit where credit is due, yesterday' answers where from John
Nadvornik, a CP Consulting team member on a project where, at the time,
it was easier for him to respond from my computer.
Thanks though,
____________________________________________
STEPHEN CRAIG
CP Consulting
Office: (410) 626-8454
Mobile: (443) 994-0303
www.cpco.biz
This message is confidential and may be legally privileged. It is
intended
only for its addressees. Its use in any way by anyone else is
prohibited.
-----Original Message-----
From: owner-otmsig (AT) solutionbeacon (DOT) net
[mailto
wner-otmsig (AT) solutionbeacon (DOT) net] On Behalf Of idqpbi
Sent: Thursday, December 14, 2006 12:23 AM
To: otmsig (AT) solutionbeacon (DOT) net
Subject: Re: IMP-00017: following statement failed with ORACLE error
1658; create index ....
Stephen,
You and Alan really saved my day!!!
I am having a 2 tier RHEL AS 4 setup of OTM 5.5.1. Oh boy, it is lots of
hassle to set it up. However I tried your suggestion and then it worked
perfectly.
Was able to import the data finally with only one ignorable warning
(IMP-00041). I think I could have a good sleep tonight.
Again thank you guys for the GREAT HELP!!!
Zara
P.S. Is *JAccelerator* really necessary? I just realized that I
did not have it installed when I installed Oracle 10g, it is not in the
10.2.0.2 patch either.
Stephen Craig wrote:
> Zara,
>
> I'm pretty confident there's a bug in the create_gc3_tablespaces.sql
> script.
>
> If you alter the INDX table as stated, then rerun the
> create_glog_users.sql
> And then re-import and follow the rest of the document you should be
all
> set.
>
> We just did that and had a successful install.
>
> Thanks,
> John
>
>
> ____________________________________________
>
> STEPHEN CRAIG
> CP Consulting
> Office: (410) 626-8454
> Mobile: (443) 994-0303
> www.cpco.biz
>
> This message is confidential and may be legally privileged. It is
> intended
> only for its addressees. Its use in any way by anyone else is
> prohibited.
> -----Original Message-----
> From: owner-otmsig (AT) solutionbeacon (DOT) net
> [mailtowner-otmsig (AT) solutionbeacon (DOT) net] On Behalf Of Stephen Craig
> Sent: Wednesday, December 13, 2006 9:26 PM
> To: otmsig (AT) solutionbeacon (DOT) net
> Subject: RE: IMP-00017: following statement failed with ORACLE error
> 1658; create index ....
>
> Zara,
>
> Since the table already exists you may want to try this command. I'm
> having the exact same problem on an install
>
> Alter database datafile 'c:\otm\data\indx001.dbf' autoextend on
maxsize
> 4000M
>
> Make sure c:\otm\data\indx001.dbf - is the path to your data file
>
> I think you then need to drop all the stuff running:
>
> @create_glog_users.sql
>
> I'm trying all this right now so I'll let you know if it works.
>
> I think there is a bug in the create_gc3_tablespaces.sql
>
> John
>
> ____________________________________________
>
> STEPHEN CRAIG
> CP Consulting
>
> This message is confidential and may be legally privileged. It is
> intended
> only for its addressees. Its use in any way by anyone else is
> prohibited.
>
>
> -----Original Message-----
> From: owner-otmsig (AT) solutionbeacon (DOT) net
> [mailtowner-otmsig (AT) solutionbeacon (DOT) net] On Behalf Of idqpbi
> Sent: Wednesday, December 13, 2006 8:45 PM
> To: otmsig (AT) solutionbeacon (DOT) net
> Subject: Re: IMP-00017: following statement failed with ORACLE error
> 1658; create index ....
>
> Alan,
>
> It is you again haha. : -) Thanks!
> I tried your suggestion and it complained that the tablespace "INDX"
> already existed. So should I drop it first? How do I drop it? Do I
need
> to drop all the tablespaces and then recreate?
>
> I also run this:
>
> SQL> show parameter cache;
>
> Name Type
> Value
>
> db_16k_cache_size big integer
>
> 36M
> db_cache_advice string
> ON
> object_cache_optimal_size integer
> 102400
>
> All of the rest has a value of "0".
>
> I tried to change the "db_16k_cache_size" to 100M, however I got
> "ORA_02097: parameter cannot be modified because specified value is
> invalid ORA-00384 : Insufficient memory to grow cache"
error.
>
> Please excuse me if I asked really rudimentary questions. I am kind of
> new to the Oracle stacks as I said.
>
> Thanks again!!
>
> Zara
>
> Alan Cuartero wrote:
>
>> Zara,
>>
>> You may have run out of space. Its been my experience that the
default
>> tablespace data files are a little undersized for the import. Check
>>
> your log
>
>> for the first occurrence of an ORA-01658 error all the subsequent
>>
> errors
>
>> would be a result of that initial one. If you have it try adding a
>>
> datafile
>
>> to the tablespace in question. Another possible solution is to
>>
> increase the
>
>> MAXSIZE value for the datafile and turn on AUTOEXTEND if its not on
>>
> already.
>
>> Something like this for the initial create.
>>
>> CREATE TABLESPACE INDX
>> DATAFILE '/opt/whaterver/path/youre/using/INDX01.dbf'
>> SIZE 1024000K REUSE
>> AUTOEXTEND ON NEXT 256000K MAXSIZE 4096000K
>> SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
>> /
>>
>> Then rerun the create_glog_users.sql in order to drop and recreate
the
>>
> users
>
>> (which will drop cascade all their objects and data). Then retry the
>>
> import.
>
>> Hope this helps.
>>
>> -Alan
>>
>>
>> On 12/13/06 6:27 PM, "idqpbi" <idqpbi (AT) gmail (DOT) com> wrote:
>>
>>
>>
>>> Hi,
>>>
>>> During my configuring the oracle database for the OTM 5.5.1 server
>>>
>>> I ran the following according to OTM 5.5.1 Admin Guide page 3-19:
>>>
>>> /imp parfile=imp_otmv55_partition.par
>>> userid=system/<SYSTEM_PWD>@<CON_STR>
>>>
>>> (using my own pwd of course)
>>> /
>>> and it seemed that the list of tables were imported, then it failed
>>>
> with
>
>>> *IMP-00017: following statement failed with ORACLE error 1658;
create
>>> index......*
>>>
>>> later on it also failed on "alter table....." since there is no
>>>
> primary
>
>>> key for some tables, so there is no way to set up foreign key
>>> relationships....
>>>
>>> It seems that the export was done by using the SYS user.
>>>
>>> So my import log file was full of those similar errors. What
>>>
> happened?
>
>>> Please help!!!
>>>
>>> I don't understand that I am using the .dmp and .par file provided
by
>>> OTM installer, and why it should fail
>>> Was this related to the previous error that I could use the SYSTEM
>>>
> user
>
>>> to grant execute on some objects owned by glogdba and glogowner??
>>>
>>> I will try to generate a log file using "imp" options to see what
>>>
> those
>
>>> commands are.........Kind of lost, how can I get the data into the
>>>
> OTM
>
>>> database??
>>>
>>> Zara
>>>
>>> You are receiving this mail as a subscriber of the Oracle
>>>
> Transportation
>
>>> Management SIG List Server. This list is provided by Solution
Beacon,
>>> LLC for the Oracle Transportation Management SIG to facilitate
>>>
> distribution
>
>>> of issues and topics related to Oracle Transportation Management. If
>>>
> you
>
>>> do not want to receive future mail from the list, send email to
>>> majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig"
>>>
> (without
>
>>> quotes) in the body of the email.
>>> If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
>>> Thank you!
>>>
>>>
>>
>> You are receiving this mail as a subscriber of the Oracle
>>
> Transportation
>
>> Management SIG List Server. This list is provided by Solution Beacon,
>> LLC for the Oracle Transportation Management SIG to facilitate
>>
> distribution
>
>> of issues and topics related to Oracle Transportation Management. If
>>
> you
>
>> do not want to receive future mail from the list, send email to
>> majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig"
>>
> (without
>
>> quotes) in the body of the email.
>> If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
>> Thank you!
>>
>>
>>
>
>
> You are receiving this mail as a subscriber of the Oracle
Transportation
> Management SIG List Server. This list is provided by Solution Beacon,
> LLC for the Oracle Transportation Management SIG to facilitate
> distribution
> of issues and topics related to Oracle Transportation Management. If
you
> do not want to receive future mail from the list, send email to
> majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig"
> (without
> quotes) in the body of the email.
> If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
> Thank you!
>
>
>
>
> You are receiving this mail as a subscriber of the Oracle
Transportation
> Management SIG List Server. This list is provided by Solution Beacon,
> LLC for the Oracle Transportation Management SIG to facilitate
> distribution
> of issues and topics related to Oracle Transportation Management. If
you
> do not want to receive future mail from the list, send email to
> majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig"
> (without
> quotes) in the body of the email.
> If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
> Thank you!
>
>
>
>
> You are receiving this mail as a subscriber of the Oracle
Transportation
> Management SIG List Server. This list is provided by Solution Beacon,
> LLC for the Oracle Transportation Management SIG to facilitate
distribution
> of issues and topics related to Oracle Transportation Management. If
you
> do not want to receive future mail from the list, send email to
> majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig"
(without
> quotes) in the body of the email.
> If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
> Thank you!
>
>
You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate
distribution
of issues and topics related to Oracle Transportation Management. If you
do not want to receive future mail from the list, send email to
majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig"
(without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!
You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate distribution
of issues and topics related to Oracle Transportation Management. If you
do not want to receive future mail from the list, send email to
majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!
Linear Mode
