$ lsnrctl services LSNRCTL for HPUX: Version 9.2.0.8.0 - Production on 26-OCT-2009 09:43:54 Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521)) Services Summary... Service "ibss" has 1 instance(s). Instance "ibss2", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:2654953 refused:0 state:ready LOCAL SERVER Service "ora9i" has 1 instance(s). Instance "ora9i2", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:98747 refused:0 state:ready LOCAL SERVER The command completed successfully
# su - oracle $ sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 11 03:38:46 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.SQL> startup nomout; SP2-0714: invalid combination of STARTUP options SQL> alter database mount; alter database mount * ERROR at line 1: ORA-01034: ORACLE not available SQL> alter database open 2 ; alter database open * ERROR at line 1: ORA-01034: ORACLE not available SQL> ============================================================================感谢“tangren”先生,我想我已经知道了,结果是没有可用的实例,是吗???
LSNRCTL for HPUX: Version 9.2.0.8.0 - Production on 26-OCT-2009 09:43:54
Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
Services Summary...
Service "ibss" has 1 instance(s).
Instance "ibss2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:2654953 refused:0 state:ready
LOCAL SERVER
Service "ora9i" has 1 instance(s).
Instance "ora9i2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:98747 refused:0 state:ready
LOCAL SERVER
The command completed successfully
$sqlplus "/ as sysdba"
sql>startup nomount;
sql>alter database mount;
sql>alter database open;
$ sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 11 03:38:46 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.SQL> startup nomout;
SP2-0714: invalid combination of STARTUP options
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL>
============================================================================感谢“tangren”先生,我想我已经知道了,结果是没有可用的实例,是吗???