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@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@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@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=([email protected])(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=([email protected])(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=([email protected])(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 [email protected]
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
