[Spacewalk-list] Error after upgrade to 1.3

[Kobus Bensch]

Tomas Lestach wrote:
> 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:
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
Yes that worked

sqlplus spacewalk/spacewalk@//localhost/XE

SQL*Plus: Release 11.2.0.2.0 Production on Mon Feb 7 13:20:23 2011

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


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

-----------------------------------------------------------------------------------------------------------------------------------------
LOVEFiLM UK Limited is a company registered in England and Wales. 
Registered Number: 06528297. 
Registered Office: No.9, 6 Portal Way, London W3 6RU, United Kingdom.

This e-mail is confidential to the ordinary user of the e-mail address to which it was addressed. If you have received it in error, 
please delete it from your system and notify the sender immediately.

This email message has been delivered safely and archived online by Mimecast.
For more information please visit http://www.mimecast.co.uk 
-----------------------------------------------------------------------------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110207/529be804/attachment.htm>