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