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.]
installing space walk: oracle starting issues.
Re: installing space walk: oracle starting issues.
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
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
Re: installing space walk: oracle starting issues.
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.
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.
Re: installing space walk: oracle starting issues.
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.
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.
Re: installing space walk: oracle starting issues.
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.
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.
Re: installing space walk: oracle starting issues.
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
-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