[Spacewalk-list] Spacewalk installation woes

[Silvio.Schanz at elektrobit.com]

Hi,

the following /etc/tnsnames.ora worked fine for me:

[bash  ~]# cat /etc/tnsnames.ora
XE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = XE)
    )
  )
[bash ~]# sqlplus system at xe
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jan 5 08:29:13 2011
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
Enter password:
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL>

Neither ORACLE_HOME nor ORACLE_SID is set in my environment.

Regards,
  Silvio

From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Chris Stevens
Sent: Dienstag, 4. Januar 2011 21:18
To: spacewalk-list at redhat.com
Subject: [Spacewalk-list] Spacewalk installation woes

I'm following this guide to install a spacewalk server:

http://wiki.centos.org/HowTos/PackageManagement/Spacewalk

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:

[root at spacewalk ~]# sqlplus system at xe
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Dec 30 13:10:37 2010
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

I've googled the error message but I haven't been able to find a "fix" that applied to my specific situation.

I've tried disabling selinux, thinking that might have been the problem, but it didn't seem to help. (Note: permissive)

[root at spacewalk ~]# sestatus
SELinux status:                 enabled
SELinuxfs mount:                /selinux
Current mode:                   permissive
Mode from config file:          enforcing
Policy version:                 21
Policy from config file:        targeted

I'm thinking perhaps it's my tnsnames.ora file, but I copied the contents right from the guide:

[root at spacewalk ~]# cat /etc/tnsnames.ora
XE =
    (DESCRIPTION =
       (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
       )
       (CONNECT_DATA =
          (SERVICE_NAME = xe)
       )
    )

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):
XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = spacewalk.taservs.net)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

I noticed ORACLE_HOME wasn't set, so I defined it:

[root at spacewalk admin]# export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

But that didn't help either.

I've verified that the oracle processes are running, and listening:

[root at spacewalk ~]# netstat -an | grep 1521
tcp        0      0 0.0.0.0:1521                0.0.0.0:*                   LISTEN

And I am able to ping the database using 'tnsping':

[root at spacewalk ~]# /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnsping xe
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 04-JAN-2011 12:07:17
Copyright (c) 1997, 2005, Oracle.  All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xe)))
OK (0 msec)

I'm kind of stumped here.  I could use a point in the right direction.

Thanks!



----------------------------------------------------------------
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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110105/199e0da8/attachment.htm>