and lastly yhe catalina.out logfile again.
Kobus Bensch wrote:
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@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@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@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@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
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
--
Kobus Bensch
Linux Administrator
kobus.ben...@lovefilm.com
No.9 | 6 Portal Way | London | W3 6RU |
T: +44 (0)20 8896 8014 | F: +44 (0)20 8896 8111
|
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list