when i try to import the oracle's dump :<br><br>PGPASSWORD=spacepw psql -h localhost -U spaceuser spaceschema < /var/spacewalk/spacewalk-oracle.dump <br> setval <br>--------<br> 10926<br>(1 row)<br><br> setval <br>
--------<br> 1<br>(1 row)<br><br> setval <br>--------<br> 1<br>(1 row)<br><br> setval <br>--------<br> 1<br>(1 row)<br><br> setval <br>--------<br> 1<br>(1 row)<br><br> setval <br>--------<br> 1<br>
(1 row)<br><br>ERROR: relation "rhn_appinst_instance_id_seq" does not exist<br>LINE 1: select pg_catalog.setval('rhn_appinst_instance_id_seq', 1, f...<br> ^<br><br><br><div class="gmail_quote">
On Fri, May 25, 2012 at 11:57 AM, stefano ciavarella <span dir="ltr"><<a href="mailto:stefano.ciavarella@gmail.com" target="_blank">stefano.ciavarella@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Thanks 1000 Jan , now it works !!!!<br><br>Yeah i didn't configured tnsnames.ora....... my fault .<div class="HOEnZb"><div class="h5"><br><br><br><br><br><div class="gmail_quote">On Fri, May 25, 2012 at 11:42 AM, Jan Pazdziora <span dir="ltr"><<a href="mailto:jpazdziora@redhat.com" target="_blank">jpazdziora@redhat.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>On Fri, May 25, 2012 at 10:45:06AM +0200, stefano ciavarella wrote:<br>
> Hello,<br>
> another day , another problem..... :)<br>
><br>
> spacewalk-dump-schema --db=XE --user=spacewalk --password=password ><br>
> spacewalk-oracle.dump<br>
> DBI connect('XE','spacewalk',...) failed: ORA-24327: need explicit attach<br>
> before authenticating a user (DBD ERROR: OCISessionBegin) at<br>
> /usr/bin/spacewalk-dump-schema line 41<br>
><br>
><br>
> While I'm trying to migrate to postgresql , --db=xe lowercase didn't help.<br>
<br>
</div>I assume you do not have XE defined in tnsnames.ora or via similar<br>
mechanism so you need to use something like<br>
<br>
--db=//localhost:1521/XE<br>
<br>
Hope this helps,<br>
<span><font color="#888888"><br>
--<br>
Jan Pazdziora<br>
Principal Software Engineer, Satellite Engineering, Red Hat<br>
</font></span><div><div><br>
_______________________________________________<br>
Spacewalk-list mailing list<br>
<a href="mailto:Spacewalk-list@redhat.com" target="_blank">Spacewalk-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><br>
</div></div></blockquote></div><br><br clear="all"><br></div></div><span class="HOEnZb"><font color="#888888">-- <br>Stefano Ciavarella<br>
</font></span></blockquote></div><br><br clear="all"><br>-- <br>Stefano Ciavarella<br>