Hi expert,
i'm trying to shutdown the db but the command don't finish.
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 2 11:24:37 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> shutdown normal;
in alert file log:
Active process 13138 user 'oracle' program 'oracleTMPDB@SvilDB01'
Active process 6615 user 'oracle' program 'oracleTMPDB@SvilDB01'
Active process 8262 user 'oracle' program 'oracleTMPDB@SvilDB01'
SHUTDOWN: waiting for logins to complete.
Fri Jul 2 11:44:49 2010
MMNL absent for 1203 secs; Foregrounds taking over
$ date
Fri Jul 2 12:17:08 CEST 2010
I can connect because:
$ echo $ORACLE_SID
TMPDB
$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 2 12:21:09 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> select name from v$database;
select name from v$database
*
ERROR at line 1:
ORA-01034: ORACLE not available
what kind of check can I do?
Many thanks for all suggests.
Cheers,
Lain