[Spacewalk-list] Spacewalk installation woes
Chris Stevens
cstevens at taser.com
Tue Jan 4 20:18:07 UTC 2011
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!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110104/1d1a00d4/attachment.htm>
More information about the Spacewalk-list
mailing list