[Spacewalk-list] Error after upgrade to 1.3

[Tomas Lestach]

On 02/07/2011 01:09 PM, Kobus Bensch wrote:
> Thank you for the reply.
> Yes installed yum localinstall
> oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm
> oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64.rpm
>
> yes can connect using sqlplus
> sqlplus
>
> SQL*Plus: Release 11.2.0.2.0 Production on Mon Feb 7 12:05:35 2011
>
> Copyright (c) 1982, 2010, Oracle.  All rights reserved.
>
> Enter user-name: spacewalk at xe
> Enter password:
>
> Connected to:
> Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
>
> SQL>
>
> Tried removing the tnsname.ora and trid sqlplus:
>
> mv /etc/tnsnames.ora /etc/tnsnames.ora.POST_UPGRADE
> [root at svr08]# sqlplus
>
> SQL*Plus: Release 11.2.0.2.0 Production on Mon Feb 7 12:07:14 2011
>
> Copyright (c) 1982, 2010, Oracle.  All rights reserved.
>
> Enter user-name: spacewalk at xe
> Enter password:
> ERROR:
> ORA-12154: TNS:could not resolve the connect identifier specified
>

When not using tnsnames.ora, you have to specify an extended connect string:

sqlplus spacewalk/spacewalk@//localhost/XE

https://fedorahosted.org/spacewalk/wiki/OracleXeSetup


Regards,
Tomas


--
Tomas Lestach
RHN Satellite Engineering, Red Hat


> Kobus
>
> Sander Grendelman wrote: