[Spacewalk-list] spacewalk-dobby problem

[stefano ciavarella]

when i try to import the oracle's dump :

PGPASSWORD=spacepw psql -h localhost -U spaceuser spaceschema <
/var/spacewalk/spacewalk-oracle.dump
 setval
--------
  10926
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

ERROR:  relation "rhn_appinst_instance_id_seq" does not exist
LINE 1: select pg_catalog.setval('rhn_appinst_instance_id_seq', 1, f...
                                 ^


On Fri, May 25, 2012 at 11:57 AM, stefano ciavarella <
stefano.ciavarella at gmail.com> wrote:

> Thanks 1000 Jan , now it works !!!!
>
> Yeah i didn't configured tnsnames.ora....... my fault .
>
>
>
>
>
> On Fri, May 25, 2012 at 11:42 AM, Jan Pazdziora <jpazdziora at redhat.com>wrote:
>
>> On Fri, May 25, 2012 at 10:45:06AM +0200, stefano ciavarella wrote:
>> > Hello,
>> > another day , another problem..... :)
>> >
>> > spacewalk-dump-schema --db=XE --user=spacewalk --password=password >
>> > spacewalk-oracle.dump
>> > DBI connect('XE','spacewalk',...) failed: ORA-24327: need explicit
>> attach
>> > before authenticating a user (DBD ERROR: OCISessionBegin) at
>> > /usr/bin/spacewalk-dump-schema line 41
>> >
>> >
>> > While I'm trying to migrate to postgresql , --db=xe lowercase didn't
>> help.
>>
>> I assume you do not have XE defined in tnsnames.ora or via similar
>> mechanism so you need to use something like
>>
>>        --db=//localhost:1521/XE
>>
>> Hope this helps,
>>
>> --
>> Jan Pazdziora
>> Principal Software Engineer, Satellite Engineering, Red Hat
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>
>
>
>
> --
> Stefano Ciavarella
>



-- 
Stefano Ciavarella
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120525/cead64b5/attachment.htm>