Bonjour à tous,
Je viens d'installer Oracle Database 11g (sous linux Fedora Core 4). Lorsque j'essaie de me connecter avec le Oracle Enterprise Manager (la page web) en tant que SYSDBA j'accède sans problème, mais lorsque je tente d'éxécuté des requêtes sur la base de données j'obtient:
[oracle@localhost db_2]$ bin/sqlplus /NOLOG
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Aug 16 02:59:30 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> CONNECT / AS SYSDBA
Connected to an idle instance.
SQL> select * from tab;
select * from tab
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
Je recherche sur quelques forum et ils disent de taper "startup", mais
[oracle@localhost db_2]$ bin/sqlplus /NOLOG
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Aug 16 02:59:30 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> CONNECT / AS SYSDBA
Connected to an idle instance.
SQL> select * from tab;
select * from tab
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
SQL>
J'obtient cette erreur.. Quelqu'un a une idée ?
(Si cela peut aider:
[oracle@localhost db_2]$ bin/lsnrctl status
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 16-AUG-2007 03:01:37
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 16-AUG-2007 02:53:42
Uptime 0 days 0 hr. 7 min. 54 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/app/oracle/product/11.1.0/db_2/network/admin/listener.ora
Listener Log File /home/oracle/app/oracle/product/11.1.0/db_2/log/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1522)))
Services Summary...
Service "oracle" has 1 instance(s).
Instance "oracle", status READY, has 1 handler(s) for this service...
Service "oracleXDB" has 1 instance(s).
Instance "oracle", status READY, has 1 handler(s) for this service...
Service "oracle_XPT" has 1 instance(s).
Instance "oracle", status READY, has 1 handler(s) for this service...
The command completed successfully)
Partager