[Spacewalk-list] Spacewalk 0.1 to 0.2 upgrades available

[Jason Frisvold]

Ok, I'm at a total loss now..  I run the schema upgrade and I get this :

[friz at dev ~]$ /usr/bin/spacewalk-schema-upgrade
ERROR:
ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor


SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon>  ::= <username>[/<password>][@<connect_identifier>] | /
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon>  ::= <username>[/<password>][@<connect_identifier>] | /
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
Connect to [spacewalk/spacewalk at xe] was not successful.


I get an error connecting with SQL PLus too :

[friz at dev ~]$ sqlplus spacewalk/spacewalk at xe

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 19 15:07:03 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor


Enter user-name:


Any idea what I'm doing wrong here?  Oracle *is* running :

[friz at dev ~]$ sudo /sbin/service oracle-xe status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 19-SEP-2008 15:07:39

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                19-SEP-2008 14:35:57
Uptime                    0 days 0 hr. 31 min. 42 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dev.emcyber.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dev.emcyber.com)(PORT=9000))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully



-- 
Jason 'XenoPhage' Frisvold
XenoPhage0 at gmail.com
http://blog.godshell.com