[Spacewalk-list] spacewalk serious startup issue...
lee
funnyvoice at tlabs.ac.za
Wed Oct 12 06:08:07 UTC 2011
Hi...
I'm having serious issues with my spacewalk server. The network card on
the box that runs the spacewalk server failed/broke basically, and
needed to be replaced. I then had to do a fsck because the disks for
some reason didn't shutdown correctly.
The server runs:
CentOS release 5.6 (Final)
So I go through the fsck, cause u have to do it manually... but I didn't
really pay attention ( stupid me ) what files have been alter etc. Long
story short, is that when I restart spacewalk server I get alot of error
messages, but most of which is that oracle db listener is now not running.
I've searched google and went through all the 'help' sites I could
find. Im now completely lost ... :(
I'll post the errors I get from just starting spacewalk, and then post
the mail errors I receive. It seems that rhnSQL driver cant connect to
the oracle db because no listener is running. I've tried to get the
listener working again but I get alot of errors... which I will post
below...
1.) Errors from starting the spacewalk server
Starting spacewalk services...
Initializing jabberd processes ...
Starting router: [60G[[0;32m OK [0;39m]
Starting sm: [60G[[0;32m OK [0;39m]
Starting c2s: [60G[[0;32m OK [0;39m]
Starting s2s: [60G[[0;32m OK [0;39m]
Starting osa-dispatcher: RHN 13057 2011/10/12 07:56:57 +02:00:
('Connection attempt failed', 12541, 'ORA-12541: TNS:no listener\n')
RHN 13057 2011/10/12 07:56:57 +02:00: ('Error caught:',)
RHN 13057 2011/10/12 07:56:57 +02:00: ('Traceback (most recent call
last):\n File "/usr/share/rhn/osad/jabber_lib.py", line 118, in
main\n self.setup_config(config)\n File
"/usr/share/rhn/osad/osa_dispatcher.py", line 81, in setup_config\n
rhnSQL.initDB()\n File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/__init__.py",
line 121, in initDB\n __init__DB(backend, host, port, username,
password, database)\n File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/__init__.py",
line 52, in __init__DB\n __DB.connect()\n File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py",
line 404, in connect\n raise apply(sql_base.SQLConnectError,
err_args)\nSQLConnectError: (12541, \'ORA-12541: TNS:no listener\\n\',
\'//localhost/xe\', \'Connection_Connect(): server attach\')\n',)
[60G[[0;32m OK [0;39m] [60G[[0;32m OK [0;39m]
Starting tomcat5: [60G[ OK ]
Waiting for tomcat to be ready ...
Starting httpd: [60G[[0;32m OK [0;39m]
2011-10-12 07:58:07 InstallSoftwareConfig: !! RHN::Exception:
RHN::DB connect('//localhost/xe','spacewalk',...) failed: ORA-24327:
need explicit attach before authenticating a user (DBD ERROR:
OCISessionBegin)
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 224
RHN::Exception::DB::throw
DBI
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 636
RHN::DB::handle_error
DBI
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 689
DBI::__ANON__
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 215 DBI::connect
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 180
RHN::DB::direct_connect
NOCpulse::NOCpulseini
/usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/NOCpulseini.pm 45 RHN::DB::connect
InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 22
NOCpulse::NOCpulseini::connect
InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 21 (eval)
SysVStep /etc/rc.d/np.d/SysVStep.pm 287
InstallSoftwareConfig::startActions
SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 SysVStep::run
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 (eval)
Monitoring /etc/rc.d/np.d/Monitoring.pm 51 MacroSysVStep::startModule
SysVStep /etc/rc.d/np.d/SysVStep.pm 287 Monitoring::startActions
SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 30 SysVStep::run
main /usr/sbin/Monitoring 28 MacroSysVStep::run
main /usr/sbin/Monitoring 28 (eval)
2011-10-12 07:58:07 InstallSoftwareConfig: WARNING: STARTED BUT *NOT*
RUNNING
2011-10-12 07:58:07 InstallSoftwareConfig: ERRORS ENCOUNTERED DURING
LAST ACTION:
2011-10-12 07:58:07 InstallSoftwareConfig: !! RHN::Exception:
RHN::DB connect('//localhost/xe','spacewalk',...) failed: ORA-24327:
need explicit attach before authenticating a user (DBD ERROR:
OCISessionBegin)
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 224
RHN::Exception::DB::throw
DBI
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 636
RHN::DB::handle_error
DBI
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 689
DBI::__ANON__
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 215 DBI::connect
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 180
RHN::DB::direct_connect
NOCpulse::NOCpulseini
/usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/NOCpulseini.pm 45 RHN::DB::connect
InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 22
NOCpulse::NOCpulseini::connect
InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 21 (eval)
SysVStep /etc/rc.d/np.d/SysVStep.pm 287
InstallSoftwareConfig::startActions
SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 SysVStep::run
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 (eval)
Monitoring /etc/rc.d/np.d/Monitoring.pm 51 MacroSysVStep::startModule
SysVStep /etc/rc.d/np.d/SysVStep.pm 287 Monitoring::startActions
SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 30 SysVStep::run
main /usr/sbin/Monitoring 28 MacroSysVStep::run
main /usr/sbin/Monitoring 28 (eval)
2011-10-12 07:58:07 Monitoring: !! Monitoring configuration load failed
2011-10-12 07:58:07 Monitoring: !! Monitoring configuration not
loaded - not starting MOC functions!
2011-10-12 07:58:07 Monitoring: WARNING: STARTED BUT *NOT* RUNNING
2011-10-12 07:58:07 Monitoring: ERRORS ENCOUNTERED DURING LAST ACTION:
2011-10-12 07:58:07 Monitoring: !! Monitoring configuration load failed
2011-10-12 07:58:07 Monitoring: !! Monitoring configuration not
loaded - not starting MOC functions!
Starting Monitoring ...
Starting InstallSoftwareConfig ... [ FAIL ]
[ FAIL ]
2011-10-12 07:58:07 InstallSoftwareConfig: WARNING: STARTED BUT *NOT*
RUNNING
2011-10-12 07:58:07 InstallSoftwareConfig: ERRORS ENCOUNTERED DURING
LAST ACTION:
2011-10-12 07:58:07 InstallSoftwareConfig: !! RHN::Exception:
RHN::DB connect('//localhost/xe','spacewalk',...) failed: ORA-24327:
need explicit attach before authenticating a user (DBD ERROR:
OCISessionBegin)
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 224
RHN::Exception::DB::throw
DBI
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 636
RHN::DB::handle_error
DBI
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 689
DBI::__ANON__
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 215 DBI::connect
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 180
RHN::DB::direct_connect
NOCpulse::NOCpulseini
/usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/NOCpulseini.pm 45 RHN::DB::connect
InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 22
NOCpulse::NOCpulseini::connect
InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 21 (eval)
SysVStep /etc/rc.d/np.d/SysVStep.pm 287
InstallSoftwareConfig::startActions
SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 SysVStep::run
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 (eval)
Monitoring /etc/rc.d/np.d/Monitoring.pm 51 MacroSysVStep::startModule
SysVStep /etc/rc.d/np.d/SysVStep.pm 287 Monitoring::startActions
SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 30 SysVStep::run
main /usr/sbin/Monitoring 28 MacroSysVStep::run
main /usr/sbin/Monitoring 28 (eval)
2011-10-12 07:58:07 MonitoringScout: !! Monitoring configuration
load failed
2011-10-12 07:58:07 MonitoringScout: WARNING: STARTED BUT *NOT* RUNNING
2011-10-12 07:58:07 MonitoringScout: ERRORS ENCOUNTERED DURING LAST ACTION:
2011-10-12 07:58:07 MonitoringScout: !! Monitoring configuration
load failed
Starting MonitoringScout ...
[ FAIL ]
Starting rhn-search...
Starting cobbler daemon: [60G[[0;32m OK [0;39m]
Starting RHN Taskomatic...
Done.
2.) Tail from osa-dispatcher log ...
2011/10/12 08:00:48 +02:00 13057 0.0.0.0:
rhnSQL/driver_cx_Oracle.connect('Connecting to database', '//localhost/xe')
2011/10/12 08:00:48 +02:00 13057 0.0.0.0:
rhnSQL/driver_cx_Oracle.connect('ERROR', 'Connection attempt failed',
12541, 'ORA-12541: TNS:no listener\n')
2011/10/12 08:00:48 +02:00 13057 0.0.0.0: osad/jabber_lib.main('ERROR',
'Error caught:')
2011/10/12 08:00:48 +02:00 13057 0.0.0.0: osad/jabber_lib.main('ERROR',
'Traceback (most recent call last):\n File
"/usr/share/rhn/osad/jabber_lib.py", line 118, in main\n
self.setup_config(config)\n File
"/usr/share/rhn/osad/osa_dispatcher.py", line 81, in setup_config\n
rhnSQL.initDB()\n File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/__init__.py",
line 121, in initDB\n __init__DB(backend, host, port, username,
password, database)\n File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/__init__.py",
line 59, in __init__DB\n __DB.check_connection()\n File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py",
line 517, in check_connection\n self.connect() # only allow one
try\n File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py",
line 404, in connect\n raise apply(sql_base.SQLConnectError,
err_args)\nSQLConnectError: (12541, \'ORA-12541: TNS:no listener\\n\',
\'//localhost/xe\', \'Connection_Connect(): server attach\')\n')
3.) Email I get from my spacewalk server to say that there is an error...
Starting spacewalk services...
Initializing jabberd processes ...
Starting router: [60G[[0;32m OK [0;39m]
Starting sm: [60G[[0;32m OK [0;39m]
Starting c2s: [60G[[0;32m OK [0;39m]
Starting s2s: [60G[[0;32m OK [0;39m]
Starting osa-dispatcher: RHN 13057 2011/10/12 07:56:57 +02:00:
('Connection attempt failed', 12541, 'ORA-12541: TNS:no listener\n')
RHN 13057 2011/10/12 07:56:57 +02:00: ('Error caught:',)
RHN 13057 2011/10/12 07:56:57 +02:00: ('Traceback (most recent call
last):\n File "/usr/share/rhn/osad/jabber_lib.py", line 118, in
main\n self.setup_config(config)\n File
"/usr/share/rhn/osad/osa_dispatcher.py", line 81, in setup_config\n
rhnSQL.initDB()\n File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/__init__.py",
line 121, in initDB\n __init__DB(backend, host, port, username,
password, database)\n File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/__init__.py",
line 52, in __init__DB\n __DB.connect()\n File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py",
line 404, in connect\n raise apply(sql_base.SQLConnectError,
err_args)\nSQLConnectError: (12541, \'ORA-12541: TNS:no listener\\n\',
\'//localhost/xe\', \'Connection_Connect(): server attach\')\n',)
[60G[[0;32m OK [0;39m] [60G[[0;32m OK [0;39m]
Starting tomcat5: [60G[ OK ]
Waiting for tomcat to be ready ...
Starting httpd: [60G[[0;32m OK [0;39m]
2011-10-12 07:58:07 InstallSoftwareConfig: !! RHN::Exception:
RHN::DB connect('//localhost/xe','spacewalk',...) failed: ORA-24327:
need explicit attach before authenticating a user (DBD ERROR:
OCISessionBegin)
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 224
RHN::Exception::DB::throw
DBI
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 636
RHN::DB::handle_error
DBI
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 689
DBI::__ANON__
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 215 DBI::connect
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 180
RHN::DB::direct_connect
NOCpulse::NOCpulseini
/usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/NOCpulseini.pm 45 RHN::DB::connect
InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 22
NOCpulse::NOCpulseini::connect
InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 21 (eval)
SysVStep /etc/rc.d/np.d/SysVStep.pm 287
InstallSoftwareConfig::startActions
SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 SysVStep::run
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 (eval)
Monitoring /etc/rc.d/np.d/Monitoring.pm 51 MacroSysVStep::startModule
SysVStep /etc/rc.d/np.d/SysVStep.pm 287 Monitoring::startActions
SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 30 SysVStep::run
main /usr/sbin/Monitoring 28 MacroSysVStep::run
main /usr/sbin/Monitoring 28 (eval)
2011-10-12 07:58:07 InstallSoftwareConfig: WARNING: STARTED BUT *NOT*
RUNNING
2011-10-12 07:58:07 InstallSoftwareConfig: ERRORS ENCOUNTERED DURING
LAST ACTION:
2011-10-12 07:58:07 InstallSoftwareConfig: !! RHN::Exception:
RHN::DB connect('//localhost/xe','spacewalk',...) failed: ORA-24327:
need explicit attach before authenticating a user (DBD ERROR:
OCISessionBegin)
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 224
RHN::Exception::DB::throw
DBI
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 636
RHN::DB::handle_error
DBI
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 689
DBI::__ANON__
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 215 DBI::connect
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 180
RHN::DB::direct_connect
NOCpulse::NOCpulseini
/usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/NOCpulseini.pm 45 RHN::DB::connect
InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 22
NOCpulse::NOCpulseini::connect
InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 21 (eval)
SysVStep /etc/rc.d/np.d/SysVStep.pm 287
InstallSoftwareConfig::startActions
SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 SysVStep::run
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 (eval)
Monitoring /etc/rc.d/np.d/Monitoring.pm 51 MacroSysVStep::startModule
SysVStep /etc/rc.d/np.d/SysVStep.pm 287 Monitoring::startActions
SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 30 SysVStep::run
main /usr/sbin/Monitoring 28 MacroSysVStep::run
main /usr/sbin/Monitoring 28 (eval)
2011-10-12 07:58:07 Monitoring: !! Monitoring configuration load failed
2011-10-12 07:58:07 Monitoring: !! Monitoring configuration not
loaded - not starting MOC functions!
2011-10-12 07:58:07 Monitoring: WARNING: STARTED BUT *NOT* RUNNING
2011-10-12 07:58:07 Monitoring: ERRORS ENCOUNTERED DURING LAST ACTION:
2011-10-12 07:58:07 Monitoring: !! Monitoring configuration load failed
2011-10-12 07:58:07 Monitoring: !! Monitoring configuration not
loaded - not starting MOC functions!
Starting Monitoring ...
Starting InstallSoftwareConfig ... [ FAIL ]
[ FAIL ]
2011-10-12 07:58:07 InstallSoftwareConfig: WARNING: STARTED BUT *NOT*
RUNNING
2011-10-12 07:58:07 InstallSoftwareConfig: ERRORS ENCOUNTERED DURING
LAST ACTION:
2011-10-12 07:58:07 InstallSoftwareConfig: !! RHN::Exception:
RHN::DB connect('//localhost/xe','spacewalk',...) failed: ORA-24327:
need explicit attach before authenticating a user (DBD ERROR:
OCISessionBegin)
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 224
RHN::Exception::DB::throw
DBI
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 636
RHN::DB::handle_error
DBI
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm 689
DBI::__ANON__
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 215 DBI::connect
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 180
RHN::DB::direct_connect
NOCpulse::NOCpulseini
/usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/NOCpulseini.pm 45 RHN::DB::connect
InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 22
NOCpulse::NOCpulseini::connect
InstallSoftwareConfig /etc/rc.d/np.d/InstallSoftwareConfig.pm 21 (eval)
SysVStep /etc/rc.d/np.d/SysVStep.pm 287
InstallSoftwareConfig::startActions
SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 SysVStep::run
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 86 (eval)
Monitoring /etc/rc.d/np.d/Monitoring.pm 51 MacroSysVStep::startModule
SysVStep /etc/rc.d/np.d/SysVStep.pm 287 Monitoring::startActions
SysVStep /etc/rc.d/np.d/SysVStep.pm 118 SysVStep::startStep
MacroSysVStep /etc/rc.d/np.d/MacroSysVStep.pm 30 SysVStep::run
main /usr/sbin/Monitoring 28 MacroSysVStep::run
main /usr/sbin/Monitoring 28 (eval)
2011-10-12 07:58:07 MonitoringScout: !! Monitoring configuration
load failed
2011-10-12 07:58:07 MonitoringScout: WARNING: STARTED BUT *NOT* RUNNING
2011-10-12 07:58:07 MonitoringScout: ERRORS ENCOUNTERED DURING LAST ACTION:
2011-10-12 07:58:07 MonitoringScout: !! Monitoring configuration
load failed
Starting MonitoringScout ...
[ FAIL ]
Starting rhn-search...
Starting cobbler daemon: [60G[[0;32m OK [0;39m]
Starting RHN Taskomatic...
Done.
4.) Me trying to find what the error is with the oracle listener.
[root at spacewalk ~]#
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/lsnrctl
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 12-OCT-2011 08:02:37
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Message 850 not found; No message file for product=network, facility=NL
LSNRCTL> stat
Message 1053 not found; No message file for product=network,
facility=TNSTNS-12541: Message 12541 not found; No message file for
product=network, facility=TNS
TNS-12560: Message 12560 not found; No message file for
product=network, facility=TNS
TNS-00511: Message 511 not found; No message file for product=network,
facility=TNS
Linux Error: 111: Connection refused
LSNRCTL>
LSNRCTL> start
Message 1070 not found; No message file for product=network,
facility=TNSTNS-12545: Message 12545 not found; No message file for
product=network, facility=TNS
TNS-12560: Message 12560 not found; No message file for
product=network, facility=TNS
TNS-00515: Message 515 not found; No message file for product=network,
facility=TNS
Linux Error: 2: No such file or directory
LSNRCTL> stop
Message 1053 not found; No message file for product=network,
facility=TNSTNS-12541: Message 12541 not found; No message file for
product=network, facility=TNS
TNS-12560: Message 12560 not found; No message file for
product=network, facility=TNS
TNS-00511: Message 511 not found; No message file for product=network,
facility=TNS
Linux Error: 111: Connection refused
5.) tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xe)
)
)
6.) listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = spacewalk)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
7.) I started the oracle server via the /etc/init.d/oracle-xe as well.
This sets up the environment variables etc needed for oracle.
I then did a sqlplus /nolog.
[root at spacewalk ~]# /etc/init.d/oracle-xe start
Starting Oracle Net Listener.
Starting Oracle Database 10g Express Edition Instance.
[root at spacewalk ~]# /etc/init.d/oracle-xe status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 12-OCT-2011 08:06:04
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 12-OCT-2011 08:05:55
Uptime 0 days 0 hr. 0 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=spacewalk.tlabs.ac.za)(PORT=1521)))
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 "XE_XPT" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully
[root at spacewalk ~]#
sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Wed Oct 12 08:07:16 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> start
SP2-1506: START, @ or @@ command has no arguments
SQL>
8.) End of posts
Any help would be really appreciated...
Regards
Lee
More information about the Spacewalk-list
mailing list