MGR-04545: too many parameters
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: MGR-04545: too many parameters

  1. #1
    Join Date
    Sep 2000
    Posts
    96
    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!

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Is it connecting internal,

    Is it Shell Script

    If so, make it Startup Normal;

    and Shutdown Immediate;
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Sep 2000
    Posts
    96
    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?


  4. #4
    Join Date
    Apr 2000
    Posts
    126

    Wink MGR-04545: too many parameters

    Please post the whole script.

  5. #5
    Join Date
    Sep 2000
    Posts
    96
    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


  6. #6
    Join Date
    Apr 2000
    Posts
    126
    Try

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


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




  7. #7
    Join Date
    Sep 2000
    Posts
    96
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width