LINUX.ORG.RU
Форум — General  

FC5 и Oracle 10g


0

0

Установил 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

★★
← не BAG ли
Поиск файлов →
Ответ на: комментарий от SI

Вообще после включения ПК состояние службы 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

Почему служба нормально не стартует

Gooddy ★★
() автор топика
Ответ на: комментарий от SI

Файл /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/log/localhost/client/css.log





Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle. All rights reserved.
[ OCRUTL][3069818560]u_set_ocr_error: Parameter was NULL
2006-06-08 14:03:27.645: [ OCROSD][3069818560]utgdv:2:ocr loc file cannot be opened
2006-06-08 14:03:27.646: [ OCROSD][3069818560]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
[ OCRUTL][3069818560]u_set_gbl_comp_error: Parameter was NULL
2006-06-08 14:03:27.646: [ OCRRAW][3069818560]proprinit: Could not open raw device
2006-06-08 14:03:27.646: [ default][3069818560]a_init:7!: Backend init unsuccessful : [33]
[ OCRUTL][3069818560]u_set_ocr_error: Parameter was NULL
2006-06-08 14:03:27.646: [ CSSCLNT][3069818560]clsssinit: error(33 ) in OCR initialization

LEM stack 1: error [clsdfopen1] [

LEM stack 2: error [clsdfgenfullname] [sclsdgcwd]

[ OCRUTL][3086026432]u_set_comp_error: Parameter was NULL
[ OCRUTL][3086026432]u_set_ocr_error: Parameter was NULL
2006-06-15 12:13:09.758: [ OCROSD][3086026432]utgdv:2:ocr loc file cannot be opened
2006-06-15 12:13:09.758: [ OCROSD][3086026432]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
[ OCRUTL][3086026432]u_set_gbl_comp_error: Parameter was NULL
2006-06-15 12:13:09.758: [ OCRRAW][3086026432]proprinit: Could not open raw device
2006-06-15 12:13:09.758: [ default][3086026432]a_init:7!: Backend init unsuccessful : [33]
[ OCRUTL][3086026432]u_set_ocr_error: Parameter was NULL
2006-06-15 12:13:09.758: [ CSSCLNT][3086026432]clsssinit: error(33 ) in OCR initialization

[ OCRUTL][3086829248]u_set_comp_error: Parameter was NULL
[ OCRUTL][3086829248]u_set_ocr_error: Parameter was NULL
2006-06-15 14:25:31.095: [ OCROSD][3086829248]utgdv:2:ocr loc file cannot be opened
2006-06-15 14:25:31.095: [ OCROSD][3086829248]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
[ OCRUTL][3086829248]u_set_gbl_comp_error: Parameter was NULL
2006-06-15 14:25:31.095: [ OCRRAW][3086829248]proprinit: Could not open raw device
2006-06-15 14:25:31.095: [ default][3086829248]a_init:7!: Backend init unsuccessful : [33]
[ OCRUTL][3086829248]u_set_ocr_error: Parameter was NULL
2006-06-15 14:25:31.095: [ CSSCLNT][3086829248]clsssinit: error(33 ) in OCR initialization

Gooddy ★★
() автор топика
Ответ на: комментарий от Gooddy

cloneDBCreation.log

Control file created.


PL/SQL procedure successfully completed.

ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 146800640 bytes
Fixed Size 1257668 bytes
Variable Size 58724156 bytes
Database Buffers 83886080 bytes
Redo Buffers 2932736 bytes

Control file created.


System altered.


Database altered.


Database altered.


System altered.


System altered.


Database altered.


Tablespace altered.


TABLESPACE_NAME
------------------------------
USERS


SID PROGRAM SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
36 oracle@localhost.localdomain (QMNC) 7


39 sqlplus@localhost.localdomain (TNS V1-V3) 1
SYS

40 oracle@localhost.localdomain (MMNL) 3



SID PROGRAM SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
41 oracle@localhost.localdomain (MMON) 3


42 oracle@localhost.localdomain (RECO) 1


43 oracle@localhost.localdomain (SMON) 1



SID PROGRAM SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
44 oracle@localhost.localdomain (CKPT) 1


45 oracle@localhost.localdomain (LGWR) 1


46 oracle@localhost.localdomain (DBW0) 1



SID PROGRAM SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
47 oracle@localhost.localdomain (MMAN) 1


48 oracle@localhost.localdomain (PSP0) 1


49 oracle@localhost.localdomain (PMON) 1



12 rows selected.


User altered.


User altered.


System altered.

CloneRmanRestore.log

ORACLE instance started.

Total System Global Area 146800640 bytes
Fixed Size 1257668 bytes
Variable Size 58724156 bytes
Database Buffers 83886080 bytes
Redo Buffers 2932736 bytes

TO_CHAR(SYSTIMEST
-----------------
20060608 02:03:32

Allocating device....
Specifying datafiles...
Specifing datafiles...
Restoring ...
Restore done.

PL/SQL procedure successfully completed.


TO_CHAR(SYSTIMEST
-----------------
20060608 02:04:46

postDBCreation.log

PL/SQL procedure successfully completed.


File created.

Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 146800640 bytes
Fixed Size 1257668 bytes
Variable Size 58724156 bytes
Database Buffers 83886080 bytes
Redo Buffers 2932736 bytes
Database mounted.
Database opened.

'UTL_RECOMP_BEGIN:'||TO_CH
--------------------------
utl_recomp_begin: 02:05:52


PL/SQL procedure successfully completed.


postScripts.log


Library created.


Directory created.


Commit complete.


PL/SQL procedure successfully completed.


Commit complete.



Gooddy ★★
() автор топика
Ответ на: комментарий от SI

Вот все мои лог файлы

/etc/csh.login
/home/sashnyov/TEMP/Office2k3.log
/root/install.log
/root/install.log.syslog
/usr/lib/firefox-1.5.0.3/install.log
/usr/lib/oracle/xe/app/oracle/admin/XE/bdump/alert_XE.log
/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/onlinelog/o1_mf_1_28hxlbp4_ .log
/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/onlinelog/o1_mf_2_28hxld65_ .log
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log/CloneRmanRestore. log
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log/cloneDBCreation.l og
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log/postDBCreation.lo g
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log/postScripts.log
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/log/localhost/client/css.log
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
/usr/lib/rpm/rpm.log
/usr/share/apps/kturtle/examples/ru/arrow.logo
/usr/share/apps/kturtle/examples/ru/curly.logo
/usr/share/apps/kturtle/examples/ru/example2.logo
/usr/share/apps/kturtle/examples/ru/example3.logo
/usr/share/apps/kturtle/examples/ru/flower.logo
/usr/share/apps/kturtle/examples/ru/square.logo
/usr/share/apps/kturtle/examples/ru/triangle.logo
/usr/share/doc/lirc-0.8.0/remotes/logitech/lircd.conf.logitech
/usr/share/doc/lirc-0.8.0/remotes/logitech/lircmd.conf.logitech
/usr/share/doc/xsane-0.99/xsane.LOGO
/usr/share/doc/xterm-213/xterm.log.html
/var/log/Xorg.0.log
/var/log/Xorg.0.log.old
/var/log/anaconda.log
/var/log/boot.log
/var/log/boot.log.1
/var/log/boot.log.2
/var/log/boot.log.3
/var/log/boot.log.4
/var/log/prelink.log
/var/log/scrollkeeper.log
/var/log/yum.log
/var/log/yum.log.1
/var/log/gdm/:0.log
/var/log/gdm/:0.log.1
/var/log/gdm/:0.log.2
/var/log/gdm/:0.log.3
/var/log/gdm/:0.log.4

Gooddy ★★
() автор топика
Ответ на: комментарий от SI



/usr/lib/oracle/xe/app/oracle/admin/XE/bdump/alert_XE.logFri Jun 16

13:14:25 2006
Starting ORACLE instance (normal)
Cannot determine all dependent dynamic libraries for /proc/self/exe
The open() system call failed for the file /proc/self/exe
Linux Error: 13: Permission denied
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 62914560
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
sga_target = 146800640
control_files = /usr/lib/oracle/xe/oradata/XE/control.dbf
__db_cache_size = 67108864
compatible = 10.2.0.1.0
db_recovery_file_dest = /usr/lib/oracle/xe/app/oracle/flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
background_dump_dest = /usr/lib/oracle/xe/app/oracle/admin/XE/bdump
user_dump_dest = /usr/lib/oracle/xe/app/oracle/admin/XE/udump
core_dump_dest = /usr/lib/oracle/xe/app/oracle/admin/XE/cdump
audit_file_dest = /usr/lib/oracle/xe/app/oracle/admin/XE/adump
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 41156608
MMAN started with pid=4, OS id=2724
PSP0 started with pid=3, OS id=2722
PMON started with pid=2, OS id=2720
DBW0 started with pid=5, OS id=2726
LGWR started with pid=6, OS id=2728
CKPT started with pid=7, OS id=2730
SMON started with pid=8, OS id=2732
RECO started with pid=9, OS id=2734
CJQ0 started with pid=10, OS id=2736
MMON started with pid=11, OS id=2738
Fri Jun 16 13:14:27 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2740
Fri Jun 16 13:14:27 2006
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Fri Jun 16 13:14:28 2006
ALTER DATABASE MOUNT
Fri Jun 16 13:14:32 2006
Setting recovery target incarnation to 2
Fri Jun 16 13:14:32 2006
Successful mount of redo thread 1, with mount id 2474384628
Fri Jun 16 13:14:32 2006
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Jun 16 13:14:32 2006
ALTER DATABASE OPEN
Fri Jun 16 13:14:32 2006
Beginning crash recovery of 1 threads
Fri Jun 16 13:14:32 2006
Started redo scan
Fri Jun 16 13:14:32 2006
Completed redo scan
89 redo blocks read, 19 data blocks need recovery
Fri Jun 16 13:14:32 2006
Started redo application at
Thread 1: logseq 3, block 63227
Fri Jun 16 13:14:32 2006
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3 Reading mem 0
Mem# 0 errs 0: /usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/onlinelog/o1_mf_2_28hxld65_ .log
Fri Jun 16 13:14:32 2006
Completed redo application
Fri Jun 16 13:14:32 2006
Completed crash recovery at
Thread 1: logseq 3, block 63316, scn 456006
19 data blocks read, 19 data blocks written, 89 redo blocks read
Fri Jun 16 13:14:32 2006
Thread 1 advanced to log sequence 4
Thread 1 opened at log sequence 4
Current log# 1 seq# 4 mem# 0: /usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/onlinelog/o1_mf_1_28hxlbp4_ .log
Successful open of redo thread 1
Fri Jun 16 13:14:32 2006
SMON: enabling cache recovery
Fri Jun 16 13:14:35 2006
Successfully onlined Undo Tablespace 1.
Fri Jun 16 13:14:35 2006
SMON: enabling tx recovery
Fri Jun 16 13:14:35 2006
Database Characterset is AL32UTF8
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2755
Fri Jun 16 13:14:42 2006
Completed: ALTER DATABASE OPEN
Fri Jun 16 13:14:42 2006
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Jun 16 13:15:03 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2208K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==
Fri Jun 16 13:16:14 2006
Shutting down instance: further logons disabled
Fri Jun 16 13:16:14 2006
Stopping background process QMNC
Fri Jun 16 13:16:14 2006
Stopping background process CJQ0
Fri Jun 16 13:16:16 2006
Stopping background process MMNL
Fri Jun 16 13:16:17 2006
Stopping background process MMON
Fri Jun 16 13:16:18 2006
Shutting down instance (immediate)
License high water mark = 4
Fri Jun 16 13:16:18 2006
Stopping Job queue slave processes
Fri Jun 16 13:16:18 2006
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Fri Jun 16 13:16:20 2006
ALTER DATABASE CLOSE NORMAL
Fri Jun 16 13:16:20 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Jun 16 13:16:21 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 4
Successful close of redo thread 1
Fri Jun 16 13:16:21 2006
Completed: ALTER DATABASE CLOSE NORMAL
Fri Jun 16 13:16:21 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active

Gooddy ★★
() автор топика
Вы не можете добавлять комментарии в эту тему. Тема перемещена в архив.
← не BAG ли
General
Поиск файлов →