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@rhel6 ~]# sqlplus 'sys/redhat@//localhost/XE as sysdba' ... % ERROR: ORA-12514: TNS:listener does not currently know of service % requested in connect descriptor % [root@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@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=([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
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 _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
