<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">the following /etc/tnsnames.ora worked fine for me:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">[bash ~]# cat /etc/tnsnames.ora<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">XE =<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> (DESCRIPTION =<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> (ADDRESS_LIST =<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> )<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> (CONNECT_DATA =<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> (SID = XE)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> )<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> )<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">[bash ~]# sqlplus system@xe<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jan 5 08:29:13 2011<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Copyright (c) 1982, 2007, Oracle. All Rights Reserved.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Enter password:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Connected to:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">SQL><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Neither ORACLE_HOME nor ORACLE_SID is set in my environment.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> Silvio<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> spacewalk-list-bounces@redhat.com [mailto:spacewalk-list-bounces@redhat.com]
<b>On Behalf Of </b>Chris Stevens<br>
<b>Sent:</b> Dienstag, 4. Januar 2011 21:18<br>
<b>To:</b> spacewalk-list@redhat.com<br>
<b>Subject:</b> [Spacewalk-list] Spacewalk installation woes<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US">I’m following this guide to install a spacewalk server:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><a href="http://wiki.centos.org/HowTos/PackageManagement/Spacewalk">http://wiki.centos.org/HowTos/PackageManagement/Spacewalk</a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">But I am running into a problem at step 5.2. Instead of getting to a SQL> prompt I am receiving the following error message:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">[root@spacewalk ~]# sqlplus system@xe<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">SQL*Plus: Release 10.2.0.4.0 - Production on Thu Dec 30 13:10:37 2010<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Copyright (c) 1982, 2007, Oracle. All Rights Reserved.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Enter password:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ORA-12154: TNS:could not resolve the connect identifier specified<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I’ve googled the error message but I haven’t been able to find a “fix” that applied to my specific situation.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I’ve tried disabling selinux, thinking that might have been the problem, but it didn’t seem to help. (Note: permissive)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">[root@spacewalk ~]# sestatus<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">SELinux status: enabled<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">SELinuxfs mount: /selinux<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Current mode: permissive<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Mode from config file: enforcing<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Policy version: 21<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Policy from config file: targeted<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I’m thinking perhaps it’s my tnsnames.ora file, but I copied the contents right from the guide:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">[root@spacewalk ~]# cat /etc/tnsnames.ora<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">XE =<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> (DESCRIPTION =<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> (ADDRESS_LIST =<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> )<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> (CONNECT_DATA =<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> (SERVICE_NAME = xe)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> )<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> )<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Then when I googled I saw documentation pointing to $ORACLE_HOME/network/admin/tnsnames.ora The config was a little different, but still should have worked either way: (Both hostnames point to 127.0.0.1):<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">XE =<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> (DESCRIPTION =<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> (ADDRESS = (PROTOCOL = TCP)(HOST = spacewalk.taservs.net)(PORT = 1521))<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> (CONNECT_DATA =<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> (SERVER = DEDICATED)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> (SERVICE_NAME = XE)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> )<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> )<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I noticed ORACLE_HOME wasn’t set, so I defined it:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">[root@spacewalk admin]# export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">But that didn’t help either.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I’ve verified that the oracle processes are running, and listening:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">[root@spacewalk ~]# netstat -an | grep 1521<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">And I am able to ping the database using ‘tnsping’:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">[root@spacewalk ~]# /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnsping xe<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 04-JAN-2011 12:07:17<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Copyright (c) 1997, 2005, Oracle. All rights reserved.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Used parameter files:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Used TNSNAMES adapter to resolve the alias<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xe)))<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">OK (0 msec)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I’m kind of stumped here. I could use a point in the right direction.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thanks!<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
<pre>
----------------------------------------------------------------
Please note: This e-mail may contain confidential information
intended solely for the addressee. If you have received this
e-mail in error, please do not disclose it to anyone, notify
the sender promptly, and delete the message from your system.
Thank you.
</pre>
</body>
</html>