| Missing initsid.ora file [message #165162] |
Tue, 28 March 2006 10:58  |
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 #165619 is a reply to message #165191] |
Fri, 31 March 2006 01:42  |
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 |
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 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
