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