| LRM-00116: syntax error at 'db_name' following '=' [message #157958] |
Tue, 07 February 2006 08:40  |
oraclechick
Messages: 33
Registered: February 2006
|
Member |
|
|
Hi,
I get the error below when trying to create an spfile....
SQL> create spfile = '/u01/app/oracle/product/10.2.0/dbs/spfiletestdb.ora' from pfile = '/u01/app/oracle/product/10.2.0/dbs/inittestdb.ora'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00116: syntax error at 'db_name' following '='
I'm creating a database via a korn shell script, and have created the pfile also via the script. Here is what is in my script regarding the db_name....
sid=$1
pfile="$ORACLE_HOME/dbs/init${sid}.ora"
# make pfile
echo "db_domain="" " >> $pfile
echo "db_name=${sid}" >> $pfile
Does the db_name have to be in capital letters? If so, how do i do this in the script? If not, why am i getting this error (i get this also in sql*plus, not only via my script)?
|
|
|
|
| Re: LRM-00116: syntax error at 'db_name' following '=' [message #158120 is a reply to message #157958] |
Wed, 08 February 2006 09:54  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Best to create your pfile first by hand in notepad or vi or whatever to make sure the syntax of the parameters is correct first. Then startup the db using that pfile to verify. Then create the spfile from that pfile after verified. Capitalization shouldn't matter, but proper quotes do.
Once you have a correct pfile, you can write a correct script to generate it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
