ORacle Multiple instance running windows 7-

[Duke]

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?

 

[icebags]

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.

 

[Duke]

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.??

 

[icebags]

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

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

 

[Duke]

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..

 

[icebags]

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

 

[Duke]

yeah i changed it to auto & done the same