I am trying to write some instance and database creation scripts for an oracle instance I have on NT.

I can create the instance without a problem. My problem comes when I try to call the script to create the database. I am using sqlplus /nolog because svrmgrl is going away in future releases of oracle. The root of the problem is that I am passing a single parameter to the sql script and the substitution is not taking place.

Here is the command line

sqlplus /nolog @run.sql instance1

Here is a little bit of the code

connect internal/
startup nomount pfile=d:\oracle\admin\&1\pfile\init.ora
.
.
.

I have tried enclosing the pfile path in quotes, unquoting for the substitution variable. Nothing seems to work.

I am using oracle 8.1.7. Does anyone have any thoughts?

Thanks,

John E.