Home » RDBMS Server » Server Administration » Init.ora in 8.1.7
Init.ora in 8.1.7 [message #50758] Thu, 04 April 2002 18:18 Go to next message
gjowers
Messages: 1
Registered: April 2002
Junior Member
I can't seem to get the DB to use my new init.ora file it always reverts to some default config. I have checked evey .ora file I can find to no avail. I specify at startup the correct init.ora, but it seems to ignore it and use the default settings anyway.

Report message to a moderator

Re: Init.ora in 8.1.7 [message #50759 is a reply to message #50758] Thu, 04 April 2002 18:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
very ODD!!!!
whats the version of oracle?
with 9i we have something called as spfile.
copy the initsid.ora to a very different location.
and do the changes.
connect to svrmgrl ( with 9i no svrmgrl).
svrmgrl> startup open pfile='newlocationinitsid.ora'

Report message to a moderator

Re: Init.ora in 8.1.7 [message #50775 is a reply to message #50758] Fri, 05 April 2002 04:44 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
This has happened to be once before. The DBA before me had put a copy of the init.ora file in the /usr/bin folder. Took me some time to figure out.

Start off with searching the complete drive, starting at root, for the initSID.ora file.

cd /
find . -name initSID.ora

(or do similarly in NT)

Report message to a moderator

Previous Topic: Trigger presence KILLS performance
Next Topic: oracle imp trick
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 10:30:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.