Installation af Oracle på Fedora - næsten lykkedes
HejJeg har downloadet en Oracle 10.2 Express Edition fra Oracle.com, og kørt den ind på min spritnye Fedora jf. deres vejledning - dvs. rpm -ivh Oracle_pakke.rpm, og derefter oracle_xe configure, og angiv porte og div. andet.
Nu er problemet så bare, at jeg ikke kan lave en forbindelse via listeneren - jeg synes, at det lugter af, at det er den der er problemet, men efter et par timers forgæves søgen på google er jeg løbet tør for ideer.
Når jeg prøver at connecte fra en SQLPlus får jeg:
C:\Documents and Settings\kga>sqlplus system/password@XE
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 27 11:38:59 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
TNSping ser ud til at virke:
C:\Documents and Settings\kga>tnsping XE
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-JAN-2
006 11:39:37
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = fedora)(
PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
OK (10 msec)
Men listeneren på fedoraen er det vist noget galt med:
LSNRCTL for Linux: Version 10.2.0.1.0 - Beta on 26-JAN-2006 17:15:07
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fedora)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Beta
Start Date 26-JAN-2006 17:01:14
Uptime 0 days 0 hr. 13 min. 53 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=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...
Service "XE" has 1 instance(s).
Instance "XE", status BLOCKED, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "XE", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
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 = TCP)(HOST = fedora)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
TNSNames.ora:
# tnsnames.ora Network Configuration File:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = fedora)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Hvad gør jeg galt?
