SQL> conn sys/oracle@xzomc as sysdba
Connected to an idle instance.
SQL> startup pfile=/oracleapp/u01/app/oracle/admin/xzomc/pfile/initgomcr.ora
LRM-00109: could not open parameter file '/oracleapp/u01/app/oracle/admin/xzomc/pfile/initgomcr.ora'
ORA-01078: failure in processing system parameters
解决办法:
$ cp $ORACLE_BASE/admin/xzomc/pfile/init.ora.728200794421 /oracleapp/u01/app/oracle/product/10.2.0/dbs/initrawdb.ora
SQL> conn sys/oracle@xzomc as sysdba;
Connected to an idle instance.
SQL> startup pfile=$ORACLE_BASE/admin/xzomc/pfile/init.ora.728200794421
ORACLE instance started.
Total System Global Area 2550136832 bytes
Fixed Size 1980808 bytes
Variable Size 536872568 bytes
Database Buffers 1996488704 bytes
Redo Buffers 14794752 bytes
Database mounted.
Database opened.
也可能是ORACLE_SID的问题，问题出在设置oracle用户.bash_profile文件的ORACLE_SID变量时，写为了 ORACLE_SID=wilson ，在startup的时候报错，其实真正的数据库实例名称是venus。