Oracle 10g R2 on SLES10 (zSeries)
I installed Oracle 10g (10.2.0.2) on SLES10 for zSeries.
I installed software only.
I then applied the 10.2.0.3 patchset.
Then ran NETCA (Network Configuration Assistant)
and DBCA (Database configuration assitant) to create the database (with samples)
All seems well. I can bring up OEM and everything seems fine.
However, when I try to use SQLPLUS: sqlplus '/as sysdba'
and try a select statement, I get ORA01034: ORACLE not available
So, I try "startup" it returns:
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oracle/app/oracle/product/10.1.0/db_1/dbs/initorcl.ora'
SQL>
Sure enough, it doesn't exist.
At that directory, I find:
-rw-rw---- 1 oracle oinstall 1552 2008-08-13 14:48 hc_Cityworks01.dat
-rw-r--r-- 1 oracle oinstall 12920 2001-05-03 00:30 initdw.ora
-rw-r--r-- 1 oracle oinstall 8385 1998-09-11 17:43 init.ora
-rw-rw---- 1 oracle oinstall 24 2008-08-13 14:50 lkCITYWORK
-rw-rw---- 1 oracle oinstall 24 2008-08-13 14:53 lkCITYWORKS_01
-rw-r----- 1 oracle oinstall 12288 2008-08-13 14:54 orapwCityworks01
-rw-r----- 1 oracle oinstall 12288 2008-08-13 15:01 spfileCityworks01.ora
oracle@linux64:~/app/oracle/product/10.1.0/db_1/dbs>
Then, I did something really stupid and cycled the Linux machine. Now, nothing comes up (even OEM that was running).
How, at this point, can I tell the database to use a different spfile?
Thanks
Tom Duerbusch
THD Consulting