installing space walk: oracle starting issues.
Posted: 2010/09/06 21:38:21
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.]
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.]