SQL*Plus (MOSC)

MOSC Banner

parameter to sql script

edited Nov 28, 2014 4:46AM in SQL*Plus (MOSC) 2 commentsAnswered ✓

Hi all,

on 11.2.0.4 on Windows 2008 server

I run a script :

sql>@0-createdb.sql MYDBNAME

In which :

startup nomount pfile=%ORACLE_HOME%\database\init&1.ora

But when running I receive :

SQL> startup nomount pfile=%ORACLE_HOME%\database\init&1.ora

LRM-00109: could not open parameter file 'C:\app\administrateur\product\11.2.0\dbhome_1\database\initMYDBNAMEora'

ORA-01078: failure in processing system parameters

How should I write %ORACLE_HOME%\database\init&1.ora in my script to preserve dot befor ora ?

Thank you.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center