Hello,
I had some stability problems on my Ubuntu Linux machine with Oracle 10g, so the box crashed. After reboot I was not able to restart the database. In EM I can see that the listener is up but the db instance is down and the Agent says: "ORA-01034: ORACLE not available". If I try to start the DB instance in EM, I always get this Error: "RemoteOperationException: error reading error from command". I tried every possible combination of Host-ID and DB-ID.
Here are the config files and steps I made up to the present:
/srv/oracle/network/admin/listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /srv/oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /srv/oracle)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
/srv/oracle/network/admin/tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
AVAORA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
$ /etc/init.d/oracle start
Starting Oracle:
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-AUG-2006 21:59:29
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /srv/oracle/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /srv/oracle/network/admin/listener.ora
Log messages written to /srv/oracle/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 29-AUG-2006 21:59:29
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /srv/oracle/network/admin/listener.ora
Listener Log File /srv/oracle/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Processing Database instance "orcl": log file /srv/oracle/startup.log
TZ set to Europe/Berlin
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ............................. started.
------------------------------------------------------------------
Logs are generated in directory /srv/oracle/localhost_orcl/sysman/log
OK
$ tail /srv/oracle/startup.log
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> ERROR:
ORA-01031: insufficient privileges
SQL> ORA-01031: insufficient privileges
SQL>
/srv/oracle/bin/dbstart: Database instance "orcl" warm started.
$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 28 16:44:12 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect sys/PW @AVAORA as sysdba
Connected to an idle instance.
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> startup open pfile=/srv/oracle/admin/orcl/pfile/init.ora.7162006162511
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 62916852 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> shutdown
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup nomount pfile=/srv/oracle/admin/orcl/pfile/init.ora.7162006162511
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL>
$ cat /srv/oracle/admin/orcl/udump/orcl_ora_19105.trc
Oracle Database 10g Release 10.2.0.1.0 - Production
ORACLE_HOME = /srv/oracle
System name: Linux
Node name: Server
Release: 2.6.15-26-386
Version: #1 PREEMPT Thu Aug 3 02:52:00 UTC 2006
Machine: i686
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 19105, image: oracleorcl@Server
*** SERVICE NAME:() 2006-08-28 21:54:17.849
*** SESSION ID:(160.3) 2006-08-28 21:54:17.849
Thread 1 checkpoint: logseq 50, block 2, scn 1926062
cache-low rba: logseq 49, block 3
on-disk rba: logseq 49, block 2161, scn 1906060
start recovery at logseq 50, block 2, scn 1926062
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 0Kb in 0.44s => 0.00 Mb/sec
Total physical reads: 4096Kb
Longest record: 0Kb, moves: 0/1 (0%)
Longest LWN: 0Kb, moves: 0/1 (0%), moved: 0Mb
Last redo scn: 0x0000.001d63af (1926063)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
*** 2006-08-28 21:54:18.300
KCRA: start recovery claims for 0 data blocks
*** 2006-08-28 21:54:18.301
KCRA: blocks processed = 0/0, claimed = 0, eliminated = 0
*** 2006-08-28 21:54:18.302
Recovery of Online Redo Log: Thread 1 Group 1 Seq 50 Reading mem 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
I hope someone can help me with that problem. Thanks!
Best regards, Tobias.