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.
I was trying to run an sql script from the NT command line, and pass that script a parameter. The sql script first line is the connect statement. It's second line is the startup command where I try to substitue a "Start" variable that is received as a parameter to the script.
I think I have solved the problem with a work around. I have to set the oracle_sid environment variable anyway, so I have substituted that (%oracle_sid%) instead and it works.