Problem polega na tym iz nie moge sie polaczyc z baza danych przez przedladarke.Po wpisanieu http://127.0.0.1:8080/apex dostaje blat wczytania strony no i tu zaczynaja sie problemy. Na google znalazlem duzo takich problemow ale jakos nie pomoglo mi to rozwiazac tematy. Moze pokaze na poczatku co mi pokazuje konsola
/etc/hosts
127.0.0.1 localhost.localdomin localhost
127.0.1.1 debian.toya.net.pl debian
# The following lines are desirable for IPv6 capable hosts
::1 localhost ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts[/code]
debian:/home/amon# lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 03-JAN-2009 21:32:21
Copyright (c) 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=debian)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
podobne pokazuje przy starcie
debian:/home/amon# lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 03-JAN-2009 21:55:19
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
NL-00280: error creating log stream /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
NL-00278: cannot open log file
SNL-00016: snlfohd: error opening file
Linux Error: 13: Permission denied
Listener failed to start. See the error message(s) above..
mino ze baza jest uruchomiona i w czasie uruchamia na konsoli nic nie wywala status jest nastepujacy
debian:/home/amon# /etc/init.d/oracle-xe status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 03-JAN-2009 21:56:32
Copyright (c) 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=debian)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
debian:/home/amon#
moj listener.org wyglada tak
GNU nano 2.0.7 File: ...duct/10.2.0/server/network/admin/listener.ora
listener.ora Network Configuration File:
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 = debian)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)[/code]
a tnsnames.ora tak wyglada
GNU nano 2.0.7 File: ...duct/10.2.0/server/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = debian)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
no i niby wcześniej moglem sie polczyc z baza przez sqlplus a teraz tez nie bardzo
debian:/home/amon# sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on So Sty 3 22:17:05 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect
Enter user-name: system
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
Linux Error: 13: Permission denied
i tak sie zastanawiam czy nie powinienem miec w katalogu /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/
pliku sqlnet.ora no bo teraz nie mam takiego
Z drugiej strony nie mam usr/lib/oracle/xe/oradata/XE/control.dbf nie wiem cz ten plik jest mi niezbedny ale podczas instalacji sie nie utworzyl.
Na google znalazłem duzo podabnych problemow ale jakos ciezko mi bylo znaleŹĆ rozwiazanie.Probowalem pomowe instalacje ale to nie pomaga...