MGR-04545: too many parameters

[mallard]

When trying to shutdown or startup my database using scripts, I receive the above message after server mgr has been opened. My startup and shutdown scripts are as follows:


connect internal
startup
exit



connect internal
shutdown immediate
exit


Any ideas what this message could mean and/or how to resolve?

Thanks alot!

[Kishore]

Is it connecting internal,

Is it Shell Script

If so, make it Startup Normal;

and Shutdown Immediate;

[mallard]

It is connecting internal..

It is a .sql scipt that is executed by a .bat file under Windows NT....

In my shutdown script, I do have shutdown immediate and it still has a problem...


Any other thoughts?

[mhaller]

Please post the whole script.

[mallard]

The entire shutdown.sql and startdown.sql script is contained in my original message. All the bat file does is set the SID, startup server mgr and call each script as follows:

SET ORACLE_SID=TSTLIMS
d:\Oracle\Ora81\BIN\Svrmgrl @d:\Oracle Backups\shutdown.sql


SET ORACLE_SID=TSTLIMS
d:\Oracle\Ora81\BIN\Svrmgrl @d:\Oracle Backups\Oracle Scripts\startup.sql

[mhaller]

Try

shutdown.sql:
svrmgrl<<EOF
connect internal
shutdown immediate
quit
EOF


SET ORACLE_SID=TSTLIMS
d:\Oracle Backups\shutdown.sql

[mallard]

Problem turned out to be that in my directory names there was a space. Ex: d:\Oracle Backups\Backup Scripts\shutdown.bat. When changed the directory names and made it all one word, the problem was resolved.

Thanks to all that offered assistance!