Remove one instance - can't run a bat file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Remove one instance - can't run a bat file

  1. #1
    Join Date
    Mar 2002
    Posts
    25

    Angry

    Problem one:
    I have an oracle enterprise edition 8.1.6 with three instances. I want to remove one instance without harming the other. I have stopped the services for the extra instance but I want to remove it.

    Problem two:
    Also, since I created the second and third instance, I can no longer run my bat file which does an export at night to be backed up to tape. It ran without failure until I added the new instances. The error that it gives me in incorrect username and password. I use the full global username. I can do an export mannually just using the exp command and it works fine with the same usernames and passwords.

    I have created a passwordfile for each with entries=5 and also commented out remote_logon_passwordfile=exclusive in the init.ora

    HELP!

  2. #2
    Join Date
    Mar 2002
    Posts
    15
    Answer one:
    You can use this tool:

    oradim -DELETE -SID yoursid

    then reboot the operating system.

    Answer two:

    you may set your ORACLE_SID with your current instance's and try again.


    [Edited by wolfshome on 03-14-2002 at 07:36 PM]
    Gaga ghost

  3. #3
    Join Date
    Mar 2002
    Posts
    25
    Thank you for the information. I am new to Oracle tho and I don't understand how to set my oracle_sid with my current instance. Could you please do a "how to".

  4. #4
    Join Date
    Mar 2002
    Posts
    25
    I forgot to mention that I am working on a Windows2000 server and that Oracle is installed on D:
    Do I just go to the command prompt and type
    D:\SET ORACLE_SID=
    What if I want to run a bat file on the second instance also? Should I put this command in the begining of each bat file for each instance?


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