ORacle Multiple instance running windows 7-

7 posts · originally from https://geek.digit.in/community/threads/oracle-multiple-instance-running-windows-7.176032/

how to run multiple instances in oracle?
using set oracle_sid=sid .. & when i say sqlplus / as sysdba... its asking password.. even i give sys and password it's not accepting...
is it anything to do with os privilege? if so how to deal with it.. how to run two instances at a time?

hmmm quite old thread, not sure if u still need answer, still.....

C:> set oracle_sid=<oracle_instance>
C:> sqlplus "/as sysdba"

that will do. firstu have to create those instances / i.e. databases though.

Well i did that & even check using "set o" to check the environment still can't login to dat instance.. so

am thinking as i installed it in D: so should i go to D: & do this setoracle.. or any where is fine.??

ow.....long time and u are still at it ?

anywhere is fine. post the command prompt screen shot that you are doing.

well i switched to linux as it is good for this kinda stuff & .. it was Service issue.. it was set to Manual i changed it to .. Auto now everything is fine..

service was down probably. u need to up the listener then service if they are not set to auto on during computer startup.

yeah i changed it to auto & done the same