I need help starting up database

Posted on 2006-10-31
Last Modified: 2013-12-11
I created a database. Then I logged in to sqlplus. But when I tried to startup the database I got the following error:

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/oracle/product/app/'

So I tried to create a spfile thinking that would solve the problem. But I got the following error:

SQL> create spfile from pfile;
create spfile from pfile
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file

I checked the directory in question. It is as follows:
/u01/oracle/product/app/> ls -l\
> ls -l
total 78
   2 -rw-r-----   1 oracle   dba           57 Oct 19 14:23 afiedt.buf
  18 -rw-r--r--   1 oracle   dba         8402 Oct 19 13:55 init.ora
   2 -rw-r-----   1 oracle   dba          987 Oct 19 14:12 initGabriele.ora
   2 -rw-r-----   1 oracle   dba          996 Oct 19 14:12 initGabriele.ora.old
  26 -rw-r--r--   1 oracle   dba        12920 Mar  9  2002 initdw.ora
   2 -rw-rw----   1 oracle   dba           24 Oct 19 13:56 lkDEFAULT
   2 -rw-rw----   1 oracle   dba           24 Oct 19 15:39 lkGABRIELE
   2 -rw-rw----   1 oracle   dba           24 Oct 30 14:11 lkRMAN
   4 -rwSr-----   1 oracle   dba         1536 Mar 28  2006 orapwGabriele
   4 -rwSr-----   1 oracle   dba         1536 Oct 30 14:16 orapwRMAN
   8 -rw-r-----   1 oracle   dba         3584 Oct 19 15:47 spfileGabriele.ora
   6 -rw-r-----   1 oracle   dba         2560 Oct 30 14:10 spfileRMAN.ora

Could someone please tell me what the problem is?
Question by:sikyala
LVL 18

Assisted Solution

rbrooker earned 250 total points
ID: 17844782

the startup command is looking for your pfile for the database.  the pfile that it is looking for is : initrman.ora, you do not have this file listed in the directory.
do you have one somewhere?  to find one type :

find / -name initrman.ora -print

if this finds a file called initrman.ora somewhere, you can create a soft link to it from ${ORACLE_HOME}/dbs by :

cd ${ORACLE_HOME}/dbs
ln -s /path/to/initrman.ora

this will then create a file
initrman.ora -> /path/to/initrman.ora
when you do a ls.

then try and start the database.

if you do not have a pfile called initrman.ora, take init.ora and change those lines that matter ( eg dbname etc... ) to suit the rman database and then place the new file in ${ORACLE_HOME}/dbs and start the database.

once you have your pfile, create the spfile...

good luck :)
LVL 48

Accepted Solution

schwertner earned 250 total points
ID: 17848889
Every time you create a 9i DB in $ORACLE_BASE\admin\pfile
directory is stored a init<SID>.ora parameter file.
Use it to start the DB:

SQL>startup pfile=........init<SID>.ora

After that create SPFILE from the pfile:

SQL>create SPFILE='....SPFILE<sid>.ora' FROM pfile='....init.<sid>.ora>

You can also do some modifications to the parameter file, but make a backup copy of the file
in order to start the DB if you add something wrong.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
1 FROM DUAL wont work with additional columns ?? 4 46
pivot rows to columns 1 34
Read XML values 8 41
return value in based on value passed 6 27
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question