Home » Infrastructure » Unix » Missing initsid.ora file
Missing initsid.ora file [message #165162] Tue, 28 March 2006 10:58 Go to next message
sikyala
Messages: 33
Registered: May 2005
Member
I created a new database using dbca and I am trying to log in to the database. However when I enter connect /as sysdba
it reads that I am connect to an idle instance. When I type startup I get the following errors:

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter '/u01/oracle/product/app/9.2.0.1/dbs/initgabriele.ora

I checked the directory that it is searching for the initsid.ora file in and it does not exist. There is a spfileGabriele.ora file. I don't understand why the initgabriele.ora was not created when I used dbca. How do I fix this? Please help?
Re: Missing initsid.ora file [message #165191 is a reply to message #165162] Tue, 28 March 2006 20:50 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
issue the following commands & post the results back here
env | sort
Re: Missing initsid.ora file [message #165619 is a reply to message #165191] Fri, 31 March 2006 01:42 Go to previous messageGo to next message
madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india
Member
oracle by default creates spfile,and it should use spfile while starting the database. however you can create pfile from spfile using the command create pfile from spfile; provided that you have correct env variable for ORACLE_SID

Thanks
Madhu
Re: Missing initsid.ora file [message #165693 is a reply to message #165619] Fri, 31 March 2006 09:25 Go to previous messageGo to next message
sikyala
Messages: 33
Registered: May 2005
Member
/export/home/oracle> env | sort
CC=gcc
DISPLAY=:0.0
EDITOR=vi
ENV=/export/home/oracle/.kshrc
HISTSIZE=400
HOME=/export/home/oracle
LANG=C
LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:/usr/local/X11/lib:/usr/dt/lib:/usr/openwin/lib:/u01/oracle/product/app/9.2.0.1/lib
LOGNAME=oracle
MAIL=/var/mail//oracle
MANPATH=/usr/local/man:/usr/man:/usr/local/X11/man:/usr/local/apache/man
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/oracle/product/app/9.2.0.1
ORACLE_SID=Gabriele
PAGER=more
PATH=/usr/local/bin:/bin:/usr/ccs/bin:/etc:/usr/etc:/usr/local/X11/bin:/usr/ucb:/usr/openwin/bin:/usr/local/etc:/usr/sbin:/usr/local/ bin/perl:/u01/oracle/product/app/9.2.0.1/bin:/plbin140.sol2:/opt/Acrobat4/bin
PS1=$PWD>
PWD=/export/home/oracle
SHELL=/bin/ksh
SQLPATH=/export/home/oracle
SSH_CLIENT=156.80.168.90 1966 22
SSH_CONNECTION=156.80.168.90 1966 156.80.168.48 22
SSH_TTY=/dev/pts/5
TERM=xterm
TZ=US/Eastern
USER=oracle
VISUAL=/usr/bin/vi
_=/bin/env
Re: Missing initsid.ora file [message #165896 is a reply to message #165162] Mon, 03 April 2006 04:22 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
You really should not be putting sid and server info on the internet, just my opinion.

ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/oracle/product/app/9.2.0.1

Should be

ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/app/9.2.0.1
export ORACLE_HOME
Also,
PATH=$PATH:/usr/local/bin:/bin:/usr/ccs/bin:/etc:/usr/etc:/usr/local/X11/bin:/usr/ucb:/usr/openwin/bin:/usr/local/etc:/usr/sbin:/usr/ local/bin/perl:plbin140.sol2:/opt/Acrobat4/bin:$ORACLE_HOME:$ORACLE_HOME/bin
export PATH

PWD=/export/home/oracle - I would just take this out.

[Updated on: Mon, 03 April 2006 04:22]

Report message to a moderator

Previous Topic: ./runInstaller: syntax error at the line 1
Next Topic: Moving from AIX 4.3.3 to AIX 5.3
Goto Forum:
  


Current Time: Thu Mar 28 14:45:23 CDT 2024