Установил oracle-xe-univ-10.2.0.1-1.0.i386.rpm
Выбираю в меню Go To Database Home Page выдает
Попытка соединения не удалась
Firefox не может установить соединение с сервером 127.0.0.1:8080.
* Возможно сайт временно недоступен или перегружен запросами. Подождите некоторое время и попробуйте снова.
* Если вы не можете загрузить ни одну страницу, проверьте настройки вашего соединения с сетью.
* Если ваш компьютер или сеть защищены брандмауэром или прокси-сервером, убедитесь что Firefox разрешен выход в Интернет.
А при выборе Run SQL Command Line нормально подсоединяюсь к БД и выполняю запросы.
Состояние службы oracle-xe
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 15-JUN-2006 12:13:10
Copyright © 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 15-JUN-2006 12:13:09
Uptime 0 days 0 hr. 0 min. 1 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=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
FC5 и Oracle 10g
Модератор: Модераторы разделов
-
Ramarus
- Сообщения: 18
- ОС: FedoraCore
Re: FC5 и Oracle 10g
А Apache у тебя запущен?
-
123456
- Сообщения: 490
Re: FC5 и Oracle 10g
Вообще после включения ПК состояние службы oracle-xe почему-то ненормальное
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 15-JUN-2006 14:20:21
Copyright © 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Если делаю перезапуск службы то она перестартуе без ошибок
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 15-JUN-2006 14:25:30
Uptime 0 days 0 hr. 0 min. 0 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=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Стартую БД
И соответственно тогда нормально проходит Go To Database Home Page
Почему служба нормально не стартует
-
Ramarus
- Сообщения: 18
- ОС: FedoraCore
Re: FC5 и Oracle 10g
Не стартует только сервис LISTENER как положено.
Логи можешь выложить?
Логи можешь выложить?
-
123456
- Сообщения: 490
Re: FC5 и Oracle 10g
Какие?????
В файле prelink.log выдает следущее
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/kgpmon
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/kgpmon: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/lsnrctl
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/lsnrctl: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tkprof
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tkprof: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/hsdepxa
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/hsdepxa: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libagtsh.so.1.0
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/cursize
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/cursize: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/expdp
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/expdp: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tg4pwd
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tg4pwd: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libagtsh.so.1.0
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/maxmem
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/maxmem: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sysresv
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sysresv: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/extproc
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/extproc: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libagtsh.so.1.0
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/dgmgrl
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/dgmgrl: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/trcroute
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/trcroute: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/ctxkbtc
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/ctxkbtc: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/wrap
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/wrap: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/rman
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/rman: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/dbfsize
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/dbfsize: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlldr
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlldr: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/exp
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/exp: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/agtctl
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/agtctl: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libagtsh.so.1.0
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/dbv
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/dbv: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/impdp
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/impdp: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/ctxlc
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/ctxlc: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nid
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nid: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sbttest
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sbttest: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/loadpsp
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/loadpsp: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/hsots
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/hsots: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libagtsh.so.1.0
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/imp
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/imp: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnsping
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnsping: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/dumpsga
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/dumpsga: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tstshm
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tstshm: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/orapwd
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/orapwd: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libsqlplus.so
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/ctxload
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/ctxload: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/kgmgr
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/kgmgr: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/mapsga
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/mapsga: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
/usr/sbin/prelink: Could not prelink /usr/bin/yelp because its dependency /usr/lib/mozilla-1.7.13/libgtkembedmoz.so could not be prelinked
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/hsalloci
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/hsalloci: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libagtsh.so.1.0
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/trcldr
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/trcldr: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/extjob
/usr/sbin/prelink: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/extjob: Cannot prelink against non-PIC shared library /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
Prelinking /usr/bin/gnome-about-me
/usr/sbin/prelink: /usr/bin/gnome-about-me: Cannot prelink against non-PIC shared library /usr/lib/libGL.so.1.2