installing space walk: oracle starting issues.

[unix1adm]

I know noting about oracle so I am learning this as I go.
I goolged the heck out of these errors and found several things to try and I did try them. Checked
ORACLE_HOME and PATH environment variables
Check the /etc/tnsnames.ora file

As per the instruction on the CentOS site for installing spacewalk...


5.2. Client configuration

We need to configure the tns names entry for our database. Edit /etc/tnsnames.ora:
[code]
XE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xe)
)
)
[/code]

su - oracle
-bash-3.2$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-SEP-2010 13:29:33

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Message 1053 not found; No message file for product=network, facility=TNSMessage 1020 not found; No message file for product=network, facility=TNSMessage 1021 not found; No message file for product=network, facility=TNSMessage 1022 not found; No message file for product=network, facility=TNSMessage 1023 not found; No message file for product=network, facility=TNSMessage 1026 not found; No message file for product=network, facility=TNSMessage 1034 not found; No message file for product=network, facility=TNSMessage 1024 not found; No message file for product=network, facility=TNSMessage 1025 not found; No message file for product=network, facility=TNSMessage 1040 not found; No message file for product=network, facility=TNSMessage 1422 not found; No message file for product=network, facility=TNSMessage 1033 not found; No message file for product=network, facility=TNSMessage 1028 not found; No message file for product=network, facility=TNSMessage 1415 not found; No message file for product=network, facility=TNS Message 1050 not found; No message file for product=network, facility=TNS
Message 1050 not found; No message file for product=network, facility=TNS
Message 1050 not found; No message file for product=network, facility=TNS
Message 1029 not found; No message file for product=network, facility=TNSMessage 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1052 not found; No message file for product=network, facility=TNS-bash-3.2$


If I run it as root I get the following errors:

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-SEP-2010 13:32:53

Copyright (c) 1991, 2005, Oracle. All rights reserved.

TNS-01106: Message 1106 not found; No message file for product=network, facility=TNS [LISTENER]

[Moderator edit: Added [i]code[/i] tags to preserve formatting.]

[unix1adm]

I tried the sqlplus system@xe command and this it seemed to work?
But I still see the other errors.

-bash-3.2$ sqlplus system@xe

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Sep 6 13:53:36 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Enter password:

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

[unix1adm]

So I tried to continue on with the document ... Something is still messed up with sql/oracle

sqlplus 'sys@xe as sysdba'

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Sep 6 14:01:31 2010

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> create user spacewalk identified by spacewalk default tablespace users;

User created.

SQL> grant dba to spacewalk;

Grant succeeded.

SQL> PASSWORD spacewalk;
Changing password for spacewalk
New password:
Retype new password:
Password changed
SQL> quit
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
-bash-3.2$ sqlplus spacewalk/spacewalk@xe

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Sep 6 14:04:20 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:
Enter password:
-bash-3.2$ sqlplus spacewalk/spacewalk@xe

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Sep 6 14:05:01 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: spacewalk
Enter password:
ERROR:
ORA-12545: Connect failed because target host or object does not exist


Everything I googled said to change the /etc/tnsnames.ora file from a hostname to an ip addr. See below. This did not help.
I stopped the DB and restarted it. Same errors.

Symptom:

When trying to connect to Oracle the following error is generated:

ORA-12545: Connect failed because target host or object does not exist

Cause:

Oracle suggest that this error indicates that the address specified (in the alias definition) is not valid.
Possible Remedies:

* Oracle suggest ensuring that the ADDRESS parameters (in the TNSNAMES.ORA file) have been entered correctly; the most likely incorrect parameter is the node name.
* Ensure that the executable for the server exists (perhaps "oracle" is missing.)
* If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the host name to a numeric IP address and try again.
* It could be a network connectivity problem. Try pinging the host. This error has been observed on a laptop when the database was local, TCP/IP protocol used but the network card had been removed.


/etc/init.d/oracle-xe restart
Shutting down Oracle Database 10g Express Edition Instance.
Stopping Oracle Net Listener.

Starting Oracle Net Listener.
Starting Oracle Database 10g Express Edition Instance.

[unix1adm]

So on page section 7.2 it said to update/install some code.

yum install spacewalk-oracle
yum update

edited to save space, I can post full msg if needed.
many messages like this. Ran yum clean and package-cleanup etc like it said. Did nto resolve the issues.

spacewalk-certs-tools-1.0.1-1.el5.noarch from spacewalk has depsolving problems
--> Missing Dependency: rhn-client-tools is needed by package spacewalk-certs-tools-1.0.1-1.el5.noarch (spacewalk)
You could try using --skip-broken to work around the problem
You could try running: package-cleanup --problems
package-cleanup --dupes
rpm -Va --nofiles --nodigest


I am beginning to think I should blow this away and start over.

[unix1adm]

I tried again this morning from the beginning with the same results.
So if anyone has any ideas I'd appreciate it.

I still cannot do yum install spacewalk-oracle. Or login to oracle using the command
sqlplus spacewalk/spacewalk.xe

I removed everything and reconfigured from scratch following word for worked and copy/pasting as required to avoid typos.

Talking to one of our DBA for help too.

[unix1adm]

This seems promising but still not able to login with the spacewalk user

-bash-3.2$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-SEP-2010 07:19:21

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 08-SEP-2010 07:08:12
Uptime 0 days 0 hr. 11 min. 8 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=server1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=9055))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully