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

[kshitij mali]

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'

SQL*Plus: Release 11.2.0.2.0 Production on Tue Nov 29 01:59:09 2011

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

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in
connect
descriptor
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[root at rhel6 ~]# /etc/init.d/oracle-xe status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-NOV-2011 01:52:41

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                29-NOV-2011 01:25:35
Uptime                    0 days 0 hr. 27 min. 5 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel6.1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
service...
The command completed successfully
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[root at rhel6 ~]# tail
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
29-NOV-2011 01:25:35 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=rhel6.1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568))
* status * 0
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
29-NOV-2011 01:50:32 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=rhel6.1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568))
* status * 0
29-NOV-2011 01:52:09 *
(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=43619)) * establish * XE *
12514
TNS-12514: TNS:listener does not currently know of service requested in
connect descriptor
29-NOV-2011 01:52:41 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=rhel6.1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568))
* status * 0
29-NOV-2011 01:59:09 *
(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=54635)) * establish * XE *
12514
*TNS-12514: TNS:listener does not currently know of service requested in
connect descriptor*
===============================================================================


Please help me to setup the oracle XE for spacewalk


Regards & thanks in advance,

Kshitij Mali
kshitij.mali at orange.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20111129/284e154b/attachment.htm>