[Spacewalk-list] ORA-12514: TNS:listener does not currently know of service requested in connect

[Michael Mraka]

kshitij mali wrote:
% Hi All,
% 
% I am installing the spacewalk on rhel6.1 i got stuck in the middle of the
% below link procedure
% https://fedorahosted.org/spacewalk/wiki/OracleXeSetup
% where we have to test the connectivity to the XE
% 
% Below is the error and details of config
% 
% ===========================================
% 
% [root at rhel6 ~]# sqlplus 'sys/redhat@//localhost/XE as sysdba'
...
% ERROR: ORA-12514: TNS:listener does not currently know of service
% requested in connect descriptor
% [root at rhel6 ~]# /etc/init.d/oracle-xe status
...
% Listening Endpoints Summary...
%   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
%   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel6.1)(PORT=1521)))
% [root at rhel6 ~]# tail
% /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
...
% 29-NOV-2011 01:25:44 *
% (CONNECT_DATA=(CID=(PROGRAM=)(HOST=rhel6.1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568))
% * status * 0
% 29-NOV-2011 01:49:42 *
% (CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=sqlplus at rhel6.1)(HOST=rhel6.1)(USER=root)))
% * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=35352)) * establish * XE *
% 12514
% TNS-12514: TNS:listener does not currently know of service requested in
% connect descriptor

Hi Kshitij,

is your server's hostname really 'rhel6.1'? I guess it isn't a proper
FQDN, maybe it's written manually into /etc/hosts, and this is likely
what confuses oracle client. We always suggest using FQDN whenever it's
possible.

Does
  sqlplus 'sys/redhat@//rhel6.1/XE as sysdba'
work for you?

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat